Tool to analyse performance

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  May 8, 2008 at 8:53 am

  #122321

  Hello everybody,

  I need to know if there is any good(excellent) tool so that i can check performance, create reports, do optimizations in my SQL Server Instances.

  I've installed a new cluster that at the beginning he performance was fantastic. Now 3 months after i've done that migration my cluster is completely down :crazy:

  The cluster is formed by two quad core machines with 16GB of RAM and i cant explain to my client what is happening on the cluster.

  When i activate my performance monitor ,what options should i check to get this information?

  How can i get this precious info without getting the server down.

  Thanks and regards

  JMSM 😉

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  May 8, 2008 at 9:06 am

  #812467

  you should have a baseline to know if performance is down:

  http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

  http://www.sql-server-performance.com/articles/per/hardware_tuning_performance_p1.aspx

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  May 9, 2008 at 8:51 am

  #813110

  Thanks a lot

  Regards.

  JMSM 😉