SQL Server Performance

Database Monitoring Scripts for SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by raagi2000, May 28, 2009.

  1. raagi2000 New Member

    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
  2. satya Moderator

    What kind of monitoring methods you would like to follow?
    What kind of environment you have to take care?
  3. ghemant Moderator

    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!

Share This Page