This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 34%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hello, I am a new DBA and was tasked to gather performance counters before and after SQL Server restart.
I have set up the counters to monitor and now have the results. I am having difficulty understanding the counters reports and graphs.
If someone can point me in the right direction to be able to understand/analyze the counters better that will be a great help to me!
If you can also comment any blogs/posts where I can read more in depth, that would be great also.
I will post the before and after screenshots of the counters below. If anyone sees any area where deeper investigation needs to be done, please let me know. TIA.
A little background:
SQL Server 2014 running on windows server 2012 r2 standalone
8 cores, 16 logical processors
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @SQLLover21 ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
I suggest you start here:
https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
All performance counters are reset on reboot. So that really makes no difference.
@Tom Phillips - after the restart, we captured 1.5 weeks of counter captures. So I would think we can still get a true representation of counters being affected. Please correct me if I am wrong
1.5 weeks is not very long. Some SQL Servers run for a year without a reboot.
I can tell from your "page faults" you have a memory issue. You must set "Max Server Memory" to a reasonable value for your server to operate without swapping RAM to disk.
@Tom Phillips - is page fault counter alone detective of a memory issue? when i use task manager to manually monitor, the memory does not go above 70%. I know that if memory is above 90%, it indicates memory issue.
Task manager numbers included the page file size. You do not want a server using the page file at all.
Hi @SQLLover21 ,
Agree with Tom >All performance counters are reset on reboot. So that really makes no difference.
We should pay more attention to the value rather than the change of values before and after.
From this link: https://solutioncenter.apexsql.com/top-sql-server-memory-pressure-counters/
we can understand the relevant parameters of the sql server performance counter.
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.