Hi Guyz I am setting up automatic monitoring of SQL 2005 on WIN2K3 R2 does anyone have the scripts or pointers i can use it as a reference or make changes to the existing script to suit my environment. some of them i can think of drive space monitoring , database growth monitoring including table size , blocking , deadlocks etc etc thanks
What kind of monitoring methods you would like to follow? What kind of environment you have to take care?
One way of doing this, you can set an alert by setting up threshold values! Is this what you are looking for! Or please be more specific what you are looking for!