Post reply

if sql server slow

  • February 12, 2009 at 2:05 am

    #201069

    HI,

    can any one tell me?

    For Learning purpose if sql server slow, as a sql dba what are the steps must to be followed?

    Thanks

  • February 12, 2009 at 6:54 am

    #942804

    It depends. Use perfmon and profiler for watching the metrics for the apps/server and what statements are being called to try and catch poor performing queries. Look at your hardware configuration (disk speed, CPU speed, number of each, memory, Raid, etc.). How are your databases are setup -separate physical drives for data and log? Are indexes setup and optimized? It's not simply one answer. You'll need to watch everything over a period of time and understand the big picture to truly optimize your setup.

    There is plenty on the internet to help you - Google it.

    http://technet.microsoft.com/en-us/library/aa964133(SQL.90).aspx

    http://blogs.msdn.com/queryoptteam/

    http://www.mssqlcity.com/Tips/tipSQL2000.htm

    -- You can't be late until you show up.

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

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