Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Windows 64bit > Issues Logging SQL Server performance counters to counter log

Reply
Thread Tools

Issues Logging SQL Server performance counters to counter log

 
 
bertcord@gmail.com
Guest
Posts: n/a
 
      09-16-2005
I would like to save performance information using perfmon.exe using
the CounterLogs functionality. I am currently running a clustered
SQL2000 SP4 machine running on Windows 2003 Advanced x64. When starting
perfmon.exe I noticed that the SQL counters are not available, after
some messing around I found another copy of perfmon.exe in
C:\WINDOWS\SysWOW64\perfmon.exe.

If I start this executable I can now see the SQL Server performance
counters. And can interactively watch performance. The problem arises
when I attempt to create a CounterLog. I can create the counter log and
add the SQLServer counters but it does not log the SQLCounters.

Looking in the event log I get the following messages

The service was unable to add the counter '\\BEDB3\SQLServer:General
Statistics\User Connections' to the test log or alert. This log or
alert will continue, but data for that counter will not be collected.
The error returned is: The specified object is not found on the system.

Anyone know how to get this working?

Bert

 
Reply With Quote
 
 
 
 
bertcord@gmail.com
Guest
Posts: n/a
 
      09-21-2005
anyideas?

 
Reply With Quote
 
 
 
 
Charlie Russel - MVP
Guest
Posts: n/a
 
      09-21-2005
I'd suggest asking over on the SQL Server sections of the newsgroups. It's
clearly a bug, but I don't know enough about SQL Server to know if there's a
workaround. Someone there should.

--
Charlie.
http://msmvps.com/xperts64

wrote:
> anyideas?



 
Reply With Quote
 
bertcord@gmail.com
Guest
Posts: n/a
 
      09-25-2005
Thanks Charlie,

I have also asked there but I guess not too many people using SQL2000
on x64, every one gearing up for SQL2005 I guess. I am betting that
this issuse might exist for any 32bit performance counters. Do you
know any other 32bit applications that have performance counters that I
can test this theory on?

Thanks
Bert

 
Reply With Quote
 
Charlie Russel - MVP
Guest
Posts: n/a
 
      09-25-2005
Sorry, Bert. Not really my area of expertise.

--
Charlie.
http://msmvps.com/xperts64

wrote:
> Thanks Charlie,
>
> I have also asked there but I guess not too many people using SQL2000
> on x64, every one gearing up for SQL2005 I guess. I am betting that
> this issuse might exist for any 32bit performance counters. Do you
> know any other 32bit applications that have performance counters that I
> can test this theory on?
>
> Thanks
> Bert



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Logging exception with java.util.logging.Logger#log() to file only Royan Java 1 04-01-2008 09:42 PM
Performance counters Dmitry Duginov ASP .Net 5 12-07-2004 12:58 AM
Re: ASP.NET Performance Counters are all zero ... ? Michael Carr ASP .Net 4 01-12-2004 04:30 PM
Re: ASP.NET Performance Counters are all zero ... ? Michael Carr ASP .Net 0 01-09-2004 03:15 AM
.NET Clr Data performance counters Erik Cruz ASP .Net 0 10-27-2003 02:08 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57