Perfmon SQL Server counters not appearing in list for saveds coun

Hi James
"JimLad" wrote:

> Hi,
> I set up a counter log to record SQL data in perfmon. This included a
> few O/S counters and
> SQL Server:Buffer Manager/Buffer Cache Hit Ratio
> SQL Server:General Statistics/User Connections
> I am now trying to look at the data through Perf Mon on the same
> machine. However I can only add O/S counters to the view. The SQL
> Server counters don't appear in the list.
> Any ideas?
> Cheers,
> James
I assume this is opening the log file? In which case I suspect the counters
weren't collected. Are the counters available if you try to add them to the
system monitor?
If you are on a 64 bit server are you running the correct version of perfmon?
John
Hi James
"JimLad" wrote:

> On Jul 9, 1:28 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi John,
> Yes, I am opening the log file. And yes they are available in Sys Mon.
> It's a virtualised 32bit server I believe (Intel Xeon 3.2GHz).
> As for perfmon version I'm just using the one in Administrative Tools.
> So, I definitely put the counters in the log. Why haven't they been
> recorded? I notice there is something about objects as well. I only
> put the individual counters in. Do I need to put the whole SQL Server
> object in?
> Cheers,
> James
If they are in the file it should be ok or the file is somehow corrupt. You
should not need to include anything other than the specific counters. Try
doing a new one with just one of the counters and see what happens.
You could try importing the file into SQL 2005 profiler it you have a
corresponding profile.
John
|||On Jul 9, 12:52 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi James
>
>
> "JimLad" wrote:
>
>
>
>
>
>
>
>
> If they are in the file it should be ok or the file is somehow corrupt. You
> should not need to include anything other than the specific counters. Try
> doing a new one with just one of the counters and see what happens.
> You could try importing the file into SQL 2005 profiler it you have a
> corresponding profile.
> John- Hide quoted text -
> - Show quoted text -
James,
This just happened to me last week. In my case, I could see the all
counters except for SQL Server counters (Availible memory, buffer
etc). It was a permissions issue. You can "run as" and when I changed
to administrator of the box who has sa access, they appeared.
Hope this helps.
Kristina