Monday, March 19, 2012

dbcc memusage

when I issued "dbcc memusage",
I got the errors:
Server: Msg 8966, Level 16, State 4, Line 1
Could not read and latch page (1:929) with latch type SH. VerifyPageId faile
d.
but when I issued: "dbcc checkdb", it is working ok...
I have searched on the net, couldn't find any solution for it..
Would you please advise?Well if you look in BooksOnLine it will tell you that it is no longer
supported and I believe there were even reports of it being dangerous to
run. What is it you are trying to look for?
Andrew J. Kelly SQL MVP
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:8764FA14-93CF-4AC8-8165-3AEDEF7C4B93@.microsoft.com...
> when I issued "dbcc memusage",
> I got the errors:
> Server: Msg 8966, Level 16, State 4, Line 1
> Could not read and latch page (1:929) with latch type SH. VerifyPageId
> failed.
> but when I issued: "dbcc checkdb", it is working ok...
> I have searched on the net, couldn't find any solution for it..
> Would you please advise?|||Andrew,
I was looking for why this 'dbcc memusage' is not working on this server
only, but working on other servers...Is something wroing with this server?
If not, how can I approve to the manager? What is not supported? it is in SQ
L
Server 2000 SP4. Thanks in advance.
"Andrew J. Kelly" wrote:

> Well if you look in BooksOnLine it will tell you that it is no longer
> supported and I believe there were even reports of it being dangerous to
> run. What is it you are trying to look for?
> --
> Andrew J. Kelly SQL MVP
>
> "renhai" <renhai@.discussions.microsoft.com> wrote in message
> news:8764FA14-93CF-4AC8-8165-3AEDEF7C4B93@.microsoft.com...
>
>|||I hope you got my reply I just sent to you...
"Andrew J. Kelly" wrote:

> Well if you look in BooksOnLine it will tell you that it is no longer
> supported and I believe there were even reports of it being dangerous to
> run. What is it you are trying to look for?
> --
> Andrew J. Kelly SQL MVP
>
> "renhai" <renhai@.discussions.microsoft.com> wrote in message
> news:8764FA14-93CF-4AC8-8165-3AEDEF7C4B93@.microsoft.com...
>
>|||This is directly from BOL:
Removed; no longer supported or available. Remove all references of DBCC
MEMUSAGE and replace with references to these Performance Monitor counters.
Just because a command can be executed it does not mean in any way that it
is supported. If it is not in BOL then all bets are off and you run it at
your own risk. Who knows why it fails on that one machine since it is
unsupported in the first place. Use on of the supported commands to get the
information you require.
Andrew J. Kelly SQL MVP
"renhai" <renhai@.discussions.microsoft.com> wrote in message
news:2A28A250-24D7-4059-BD72-047C71EE4106@.microsoft.com...[vbcol=seagreen]
> Andrew,
> I was looking for why this 'dbcc memusage' is not working on this server
> only, but working on other servers...Is something wroing with this
> server?
> If not, how can I approve to the manager? What is not supported? it is in
> SQL
> Server 2000 SP4. Thanks in advance.
> "Andrew J. Kelly" wrote:
>

No comments:

Post a Comment