k2000rajesh (12/21/2009)
iam installing sqlserver 2005 on my machinehow to impliment essantial monitoring script on local Box
I recommend taking a look at RedGate's SQL Response product (link is at top right of this site).
Without more specifics on what to monitor and why, I can't recommend a specific script. But SQL Response will monitor just about everything you would want, so definitely take a look at it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon