February 20, 2006 at 2:55 pm
Hi..
Just i am wondring here...by firing this i got nothing..is there any possibilities that sysperfinfo is getting null...
SELECT cntr_value/1024 as 'MBs used'
from master.dbo.sysperfinfo
where object_name = 'SQLServer:Memory Manager' and
counter_name = 'Total Server Memory (KB)'
Regards,
Papillon
February 20, 2006 at 3:41 pm
Remove/Modify the where caluse criteria and see the results...
-Krishnan
February 21, 2006 at 5:10 am
Hi..
I also fired this..
SELECT *
from master.dbo.sysperfinfo
but still i got nothing.....
Regards,
Papillon
March 7, 2006 at 6:39 am
Your perfmon counters seem to be missing. Search for unlodctr and sqlctr80.dll and you will find instructions on how to fix it.
March 7, 2006 at 6:48 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply