on 08-05-2015 6:00 PM
Hi all,
I have a question about sp_sysmon output, more precisely the figures between 'task context switch due to cache search miss' and 'cache miss' in data cache management.
Let's take an example of sp_sysmon.
The task context switch due to cache search miss shows the number below
Cache Search Misses 22.6 43.3 13582 9.7 %
This number looks high and my data cache might not be well configured but if I look at the Data Cache Management section , I have
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 15436.0 29495.5 9261597 99.9 %
Total Cache Misses 22.6 43.3 13586 0.1 %
Now the total cache misses looks fairly low and my data cache seems OK for me.
Could you explain me the difference between the 9.7% on one hand and the 0.1% on the other hand?
Thanks
Simon
To rephrase what Avinash said:
HTH.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Avinash, Andrew for your inputs.
I'll try to find out those missing objects and potentially bind them to a named cache.
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can not compare percentages like that.
First figure 9.7% is based on "total number of context switches" so the the denominator to calculate percent is total number of context switches.
For the second figure it is based on total number of hits+misses within all data caches. So hits + misses will add up to 100% as you can see.
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.