WMI / Monitoring SQL Server: Failed to load performance counter

To the Ipswitch web site

Ipswitch Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



WMI / Monitoring SQL Server: Failed to load performance counterExpand / Collapse
Author
Message
Posted 5/22/2007 8:03:09 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 10/22/2007 2:01:49 AM
Posts: 23, Visits: 4
Hi, when I try to test SQL Server 2005 (Standart edition) with Whatsup 11.0.1 i get the
following output. anyone any idea?


Checking CPU ...
Performance counter 'MonSql:CPU_MAX' requires two polls
Checking Memory ...
Check succeeded for MonSql:MEMORY_MIN
Checking Disk Performance ...
Performance counter 'MonSqlISK_READ_MAX' requires two polls
Performance counter 'MonSqlISK_WRITE_MAX' requires two polls
Checking Disk Space ...
Check succeeded for MonSqlISK_FREE_SPACE_MIN
Checking System ...
Check succeeded for MonSql:SYSTEM_MAX
Checking Buffers ...
Failed to load performance counter for 'MonSql:BUFFERS_READ_MAX'. Error=0x80041010
Failed to load performance counter for 'MonSql:BUFFERS_WRITE_MAX'. Error=0x80041010
Cache is not enabled for checking.
Checking Locks ...
Failed to load performance counter for 'MonSql:LOCKS_NUMWAIT_MAX'. Error=0x80041010
Failed to load performance counter for 'MonSql:LOCKS_AVGWAIT_MAX'. Error=0x80041010
Checking Transactions ...
Failed to load performance counter for 'MonSql:TRANSACTIONS_ACTIVE_MAX'. Error=0x80041010
Failed to load performance counter for 'MonSql:TRANSACTIONS_PERSEC_MAX'. Error=0x80041010
Checking Users ...
Failed to load performance counter for 'MonSql:USERS_LOGINPERSEC_MAX'. Error=0x80041010
Failed to load performance counter for 'MonSql:USERS_CONNECTIONS_MAX'. Error=0x80041010
Checking MSSQLSERVER ...
MonSql:MSSQLSERVER is running
Checking SQLSERVERAGENT ...
MonSql:SQLServerAgent is running
Distributed Transaction Coordinator is not enabled for checking.
Microsoft Search is not enabled for checking.
SQL Server Analysis Services is not enabled for checking.
SQL Server Reporting Services is not enabled for checking.
SQL Server Integration Services is not enabled for checking.
SQL Server FullText Search is not enabled for checking.
SQL Server Browser is not enabled for checking.
SQL Server Active Directory Helper is not enabled for checking.
SQL Server VSS Writer is not enabled for checking.
Custom Thresholds is not enabled for checking.

--- Check failed
Post #32693
Posted 8/15/2007 9:32:46 AM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Forum Members
Last Login: 7/30/2008 5:41:17 PM
Posts: 143, Visits: 39
No responses? I am also seeing an error with sql monitor:

Failed to load performance counter for 'MonSql:LOCKS_NUMWAIT_MAX'. Error=0x80041010

Don Click
Network Manager
Denton County, Texas

Post #35826
Posted 8/15/2007 6:05:40 PM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Ipswitch Employees
Last Login: Today @ 9:44:17 AM
Posts: 423, Visits: 872
That particular error means 'Invalid class', you are trying to access something that does not exist... MS site offers some help:
http://www.microsoft.com/technet/scriptcenter/topics/help/wmi.mspx#EHAAC

I'm sure WUG stuff is correct (no typos), so it is more likely that that class is not available on that computer, so use the links in the above article to re-register, or restart WMI service on the target machine.

Daniel Donnelly

Post #35834
Posted 6/30/2008 6:13:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 6/30/2008 8:18:59 AM
Posts: 3, Visits: 7
Hi,

I have the same problem, and i search on the internet for a long time. Here the answer who correct the isssue for me :

type at the command prompt of the sql server you want to monitor : wmiadap /f (No message would be displayed).

(The /f switch still forces an update of the WMI classes from the performance libraries.)

Restart WMI Service if necessary.

hope that help !

Regards.

Post #45006
Posted 7/31/2008 6:24:47 AM


Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Forum Members
Last Login: 2 days ago @ 7:33:26 AM
Posts: 182, Visits: 177
apare (6/30/2008)
Hi,

I have the same problem, and i search on the internet for a long time. Here the answer who correct the isssue for me :

type at the command prompt of the sql server you want to monitor : wmiadap /f (No message would be displayed).

(The /f switch still forces an update of the WMI classes from the performance libraries.)

Restart WMI Service if necessary.

hope that help !

Regards.


Thanks apare...
but did not work to me!! :-(


Acting is so much more real than reality!
Post #45800
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Dave, Mark Singh, kevin r gillis, Jason Benton, Brandon Felger, Ben Henderson, Tripp Allen, Will Sansbury, Hush, FTPplanet.com, Hugh Garber, George Dailey, WUP-PM, mmulryan@ipswitch.com, mswimm

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 4:16pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.016. 7 queries. Compression Enabled.