Post reply

How to setup baseline for Sql server?

  • June 1, 2004 at 1:51 am

    #161447

    How to setup rules or process which find out if any given SQL server has reached its capacity (CPU, Memory, Disk queue lenth, No. of database etc) or not .

    Thanks in advance for any idiea on this.

    -SNT

     

  • June 4, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 4, 2004 at 10:20 am

    #509052

    I am sure this is not what you want to hear but, let me explain about what I am doing for that just in case..

    There isn't any really easy way by just using SQL Server tool. It is doable to read perfmon data by using ActiveX and other stuff but not recommendable. I watch Database Size by using DTS package so that I can calculate the database growth rate but rest of them, I found 3rd party tool is a lot easier. This is one of the product I found very useful if you have a lot of sql servers as well as other servers to watch.

    http://www.mercury.com/us/products/application-management/foundation/monitors/sitescope/

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply