SQL server performance troubleshoot using performance counters

  • 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.

  • 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;

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

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