Hi all,
I need a sql server powershell scripts to take the health check and mail through the database mail.
-
Disk space and last backup status. -
CPU Utilization. -
Memory details and current memory status -
Blocking details -
Deadlock details -
Connection details -
SQL Server Wait types -
Top Queries
a. By CPU
b. By Duration
c. By I/O
-
Index information
a. Index fragmentation
b. Missing indexes
c. Un-used indexes
- Database growth history.
Please help on this