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