SQL Server Performance Forum – Threads Archive

BDCC CHACHESTATS

Can anyone tell me why DBCC CACHESTATS returns all zeros?
It seems to return zeros on our servers that have SP3, but works fine on the server that has SP4. Is it just that DBCC CACHESTATS doesn’t work in SP3 or is there some other issue?

---

no its not that it works on sp3 also.
regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

---

Thanks. I thought that must be ths case.
If it is supposed to work on SP3 then, do you have any idea why it isn’t?

---

I believe that undocumented DBCC statement has been included from SP4 onwards. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

yes it is working on sp3
check this post, which may help you
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=5354 —————————————-
http://spaces.msn.com/members/dineshasanka

---

It is working but it’s just returning zeros for everything. Any ideas why?

---

yes it is undocumented, but it was there before sp4 —————————————-
http://spaces.msn.com/members/dineshasanka

---

working means it gives values for me. I will cehck little more about this —————————————-
http://spaces.msn.com/members/dineshasanka

---

My bad… yes it works on SP3a as well. Dan
Could you please confirm whether you’ve applied SP3 or SP3a, as SP3a is a good one with bug fixes as compared to SP3 release. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

I believe it is just SP3. The version is 8.00.760. Does that mean SP3?… where do I look to find out for sure?

---

try this
SELECT SERVERPROPERTY(‘ProductLevel’)
GO
—————————————-
http://spaces.msn.com/members/dineshasanka

---

It says it’s just SP3.
So does DBCC CACHESTATS not work properly in SP3?

---

it works on SP3!! I installed SQL 2000 personal edition on win2k professional(SP4) machine and applied SP3 (not sp3a) and executed DBCC CACHESTATS .. this was returning values for all counters (not in zero’s) I am not sure whats wrong in your testing.. can you check installation logs of SQL and SP3
from WINNT folder? sqlsp.log
sqlstp.log
Deepak Kumar –An eye for an eye and everyone shall be blind

---

Both the logs say Installation Succeeded at the end.

---

<br />Ok, can you check if other DBCC statements return results or display zero’s only: -<br /><br />DBCC memorystatus (undocumented)<br />DBCC memusage (undocumented) <br />DBCC proccache <br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /> I hope you know about these statements and make yourself confirm before running on any production server.<br /><br />Deepak Kumar<br /><br />–An eye for an eye and everyone shall be blind

---

There are two servers that have SP3 where DBCC CACHESTATS returns zero values.
On both servers, those other three DBCC commands work fine.
However, on one server the DBCC MEMUSAGE command gave the following messages: DBCC memusage
Server: Msg 8966, Level 16, State 4, Line 1
Could not read and latch page (1:35115) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:35113) with latch type SH. VerifyPageId failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:35114) with latch type SH. VerifyPageId failed. I guess that’s an unrelated problem, but is that anything to worry about?!… what does it mean? Thanks for all your help

---

Looks like hardware problem on SQL Server run DBCC CHECKDB to correct any inconsistency. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>