SQL server performance troubleshoot using performance counters

• IT researcher

  SSCertifiable

  Points: 7602

  More actions

  April 6, 2013 at 1:25 am

  #292114

  I am having sql server 2008 r2 server. I saw that yesterday the server so slow. When i see performance counters some of the values are so high . So how to troubleshoot sql server performance according to the data below.I have taken the average value and maximum value of each counter for a day.

  

• pnauta

  Valued Member

  Points: 53

  More actions

  May 28, 2013 at 9:29 am

  #1619019

  This is SQL Express, a free version. There are some limitations.

  I see a manchine with 7 GB RAM available. Yet I get the idea SQL is not using a lot of it. Can you confirm? Is memory usage limited in any way?

  Can you post the output of this statement?

  SELECT * FROM sys.dm_os_wait_stats;