Solved

Performance monitor VS  sys.dm_os_performance_counters

Posted on 2014-12-07
4
164 Views
Last Modified: 2014-12-10
Hi Experts ,

Does anyone knows why some counters values are different in performance monitor and sys.dm_os_performance_counters . and how can I make them equal.
For example buffer cache hit ratio is almost 100 in performance monitor but in DMV is different . or Checkpoint pages/sec  is  0  in performance monitor and in DMV is more than 80000.

Regards
0
Comment
Question by:shahin37
  • 2
  • 2
4 Comments
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40486323
Please give us an example (screenshot).
Also confirm that you are watching for the same instances in both counters.
0
 

Author Comment

by:shahin37
ID: 40488016
Hi Vitor,

here is the screen shot, I hope it helps you to diagnose the issue.
Counters.png
0
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40488514
Ok, now I see what you are talking about.
They are on different scale. For example for Buffer cache hit ratio, in SQL Server you get the number of pages in buffer cache and in Performance Monitor you get the percentage used.
0
 

Author Comment

by:shahin37
ID: 40493012
Thanks Vitor
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question