Friends,

I need scripts for below things .Pls help me.

1)Alert for CPU, if it reaches above 70%,80% & 90% threshol
2)Alert for Memory, if it crosses memory pages/sec > 20% & Memory available bytes less than 5mb and Buffer cache
hit ratio is below 99%
3)Alert for Disk IO, if Disk time usage > 55 and Average Queue Length > 10
4)Alert if the SQL processes are blocked
Alert if drive space reaches more than 80% of the total drive space
5)Alert if the datafiles reach 80% of the space allocated
6)Alert if Tempdb is 80% full and log space is 80% full
7)Alert if the SQL services & databases are stopped and not running


Thanks