Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of Butler Bros
Butler Bros🇺🇸

Am I interpreting perfmon counter values properly? (SQL server)
Was hoping soemone might tell me if I'm interpreting this perfmon graph properly,
as it related to SQL server counters..
In the following graphic, you can see the 2 counters I'm capturing, for purposes of seeing SQL server I/O for Reads/Writes needing to go to Disk, instead of getting them from buffer memory.
My question is, since I've set the vertical scale to 100, and the counters are both displaying in ms, is it correct to say the Avg Disk sec/Write(in RED) is mostly
staying below 10ms?
and the Reads(in BLUE) are mainly above 10ms, even going off the chart a few times..?
In this User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

SOLUTION
Avatar of Máté FarkasMáté Farkas🇭🇺

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of Butler BrosButler Bros🇺🇸

ASKER

ok, let's assume I wrote the wrong thing I was monitoring.
Can we then focus on the question of graph / scale/ interpretation?

To restate even more plainly: how can I best display the graph to show counters that
output in milliseconds, where I'm looking to show say, values from 0 to  100ms?
Avatar of Máté FarkasMáté Farkas🇭🇺

Actually those counters show values in Seconds in millisecond precision and because the values can be between 1 millisec and 10 000 millisec (10 seconds) so displaying it in a linear scale is almost impossible.
So you should use another counter: https://blogs.technet.microsoft.com/askcore/2012/03/16/windows-performance-monitor-disk-counters-explained
Avatar of Butler BrosButler Bros🇺🇸

ASKER

here's what those counters look like.. any thoughts?
why does  the read counter appear to go downward?
and are they both well over the 1 or 2 you mentioned, much of the time?


User generated image
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

If you're trying to analyze a disk performance I would recommend you to check the %Disk Time (% Disk Read Time, % Disk Write Time)  counters. The returned values will be more easy to read as they are percentages, so between 0 and 100.
Avatar of Vitor MontalvãoVitor Montalvão🇨🇭

Capture also the Disk Transfers/sec (Disk Reads/sec, Disk Writes/sec)  counters. Together with the %Disk Time, you should have a better look of the disk performance.
Avatar of Butler BrosButler Bros🇺🇸

ASKER

sigh..
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTION
Avatar of Scott PletcherScott Pletcher🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of Butler BrosButler Bros🇺🇸

ASKER

thanks fellas.
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.