SQLTeam.com | Weblogs | Forums

Powershell scripts for SQL server health check


#1

Hi all,

I need a sql server powershell scripts to take the health check and mail through the database mail.

  1.   Disk space and last backup status.
    
  2.   CPU Utilization.
    
  3.   Memory details and current memory status
    
  4.   Blocking details
    
  5.   Deadlock details
    
  6.   Connection details
    
  7.   SQL Server Wait types
    
  8.   Top Queries
    

a. By CPU

b. By Duration

c. By I/O

  1.   Index information
    

a. Index fragmentation

b. Missing indexes

c. Un-used indexes

  1. Database growth history.

Please help on this