S
S
Sarpon2014-07-05 11:55:50
Web traffic analysis
Sarpon, 2014-07-05 11:55:50

Constant bursts of MS SQL disk subsystem counters, is it normal?

Good afternoon. I work with MS SQL 2008 R2. Not satisfied with the performance of the application. I looked at the disk counters, the average values ​​​​of the counters are normal, but stable "bursts" are observed. Whether such behavior of a disk subsystem is normal?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
C
Cool Admin, 2014-07-07
@ifaustrue

Perhaps normal. It is possible that this is a cache / log reset.
It’s impossible to say without more accurate data: how the base is configured, its size, the dimension of bursts (and I think something else, but I won’t say more precisely)
Open performance monitoring and find the process that generates the load.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question