June 10, 2003 at 3:58 pm
when I want to see what I have in sysperfinfo table
the sql returns empty rows.
I have no idea why>
Could you help
Thx
June 10, 2003 at 7:38 pm
Hi
Run perfmon.exe, any counters exist for your instance?
I would say no, or if they are there, they are returning no values.
Search for previous posts on resolving this if that is the case.
Also note with SP3 of Win2k, dont have a perfmon trace running at the same time your bounce your DB, you may get a shared memory error and subsequently find that some of the core memory counters are not populated. This is a known bug.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply