SQLS2K: Tunning SQL Server 2000

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  April 15, 2008 at 10:56 am

  #76962

  Hello,

  Is there any way to get what is really using the memory of my instance?

  What should i check or what should i run on my instance to check what is really damaging performance inside SQL Server instance?

  I know that i should use the performance monitor but i really don't know what points should i check without affecting the performance of my instance that its really bad.

  Note: This is one SQL Server 2000 instance.

  Thanks and regards.

  JMSM [Wink]

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  April 15, 2008 at 2:47 pm

  #802802

  Have a look at the audit & performance tuning articles on

  http://www.sql-server-performance.com/articles/audit/main.aspx