Performance Monitor Counter Analysis

SQLLover21 201 Reputation points

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


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,725 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Tom Phillips 17,631 Reputation points

    I suggest you start here:

    All performance counters are reset on reboot. So that really makes no difference.

  2. Seeya Xi-MSFT 16,246 Reputation points

    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:
    we can understand the relevant parameters of the sql server performance counter.

    Best regards,

    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.

    0 comments No comments