|
Home > Archive > MS SQL Server > March 2006 > dbcc memusage
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| renhai 2006-03-30, 8:23 pm |
| 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 J. Kelly 2006-03-30, 8:23 pm |
| 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@microso
ft.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?
| |
| renhai 2006-03-31, 9:23 am |
| 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:
> 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@microso
ft.com...
>
>
>
| |
| renhai 2006-03-31, 9:23 am |
| 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@microso
ft.com...
>
>
>
| |
| Andrew J. Kelly 2006-03-31, 9:23 am |
| 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@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|
|