Reminders

SQL Server Monitor

2 years ago
OfflineMichael Moore
Michael Moore

We are using the built in SQL Server Monitor in WUG 15.0.1. On occassion we get the message below from just one of our SQL servers. It is cryptic at best and our dba team lead is claiming it is a false positive because of the failed to load performance counter verbage. Anyone have any insight into this so I can argue/discuss this intelligently? Thanks!

Mike

Battleship (192.168.88.54) has a problem.
MonSql:Up=[ MonSql:MEMORY_MIN(OK) MonSql:DISK_FREE_SPACE_MIN(OK) MonSql:SYSTEM_MAX(OK) MonSql:MSSQLSERVER(Running) MonSql:SQLServerAgent(Running) MonSql:MSDTC(Running)]
MonSql:Down=[ MonSql:CPU_MAX(Failed to load performance counter for 'MonSql:CPU_MAX'. Error=0x80041010)]
MonSql:UpSinceLast=[]
MonSql:DownSinceLast=[]
MonSql:CPU_MAX=[Failed to load performance counter for 'MonSql:CPU_MAX'. Error=0x80041010]
MonSql:MEMORY_MIN=[OK]
MonSql:DISK_READ_MAX=[Not checked]
MonSql:DISK_WRITE_MAX=[Not checked]
MonSql:DISK_FREE_SPACE_MIN=[OK]
MonSql:SYSTEM_MAX=[OK]
MonSql:BUFFERS_READ_MAX=[Not checked]
MonSql:BUFFERS_WRITE_MAX=[Not checked]
MonSql:CACHE_HITRATIO_MIN=[Not checked]
MonSql:CACHE_USECOUNT_MIN=[Not checked]
MonSql:LOCKS_NUMWAIT_MAX=[Not checked]
MonSql:LOCKS_AVGWAIT_MAX=[Not checked]
MonSql:TRANSACTIONS_ACTIVE_MAX=[Not checked]
MonSql:TRANSACTIONS_PERSEC_MAX=[Not checked]
MonSql:USERS_LOGINPERSEC_MAX=[Not checked]
MonSql:USERS_CONNECTIONS_MAX=[Not checked]
MonSql:MSSQLSERVER=[Running]
MonSql:SQLServerAgent=[Running]
MonSql:MSDTC=[Running]
MonSql:MSSearch=[Not checked]
MonSql:Alerts=[Not checked]
MonSql:OLAP_ENABLED=[Not checked]
MonSql:REPORTS_ENABLED=[Not checked]
MonSql:INTEGRATION_ENABLED=[Not checked]
MonSql:FULLTEXTSEARCH_ENABLED=[Not checked]
MonSql:BROWSER_ENABLED=[Not checked]
MonSql:ADHELPER_ENABLED=[Not checked]
MonSql:SQLWRITER_ENABLED=[Not checked]
Monitors that are down include: SQL Server Monitor

Concluded

0 Conclusions:

3 Replies

OnlineWhatsUp Guru (Jason Williams) WhatsUp Guru (Jason Williams) said 2 years ago

Hey Mike,

The error code that is part of the monitor results listed above (Error=0x80041010), is the Microsoft WMI error for invalid class.  The rest of the monitor is running fine, including other performance counters.  The counter that is used for CPU is %UserTime, which is part of the Win32_PerfRawData_PerfOS_Processor WMI class.

It is going to take some investigating to figure out why you are getting this error message, and for that I would recommend opening a case with our support group.  If it isn't a big deal to you, then I would recommend disabling the CPU check in that monitor and using the SNMP CPU Performance monitor instead.


OfflineMichael Moore Michael Moore said 2 years ago

Yeah did that and got the reply that I suspected. No troubleshooting whatsoever just "that's a WMI problem, call Microsoft". It is your software and your monitor that is sending these false alerts and they happen very randomly so...WMI appears to be working or the monitor wouldn't function at all. Gotta wonder why we pay maintenance.


OnlineWhatsUp Guru (Jason Williams) WhatsUp Guru (Jason Williams) said 2 years ago

Michael,

I am sorry that you are frustrated.  I don't know exactly which platform your Exchange machine is running, but we have a number of documented cases with customers running Windows Server 2008 and having WMI issues.  Even with Server 2003 there are reported issues.  There are many articles, blog posts and forum threads discussing these issues.

If you don't think it is a WMI issue, then you should be able to create a new WMI Active Monitor that is pointed at that class.  You should see the same behavior as the SQL Server monitor, with the sporatic failures.  If this monitor doesn't give you any problems, then I would be happy to help you configure a script monitor that did the calculations to figure out the CPU usage %.  I also made a suggestion of disabling that specific check and using SNMP as another alternative.  If you would like happy setting eiher of these up, please just let me know.

 


Would you like to comment?

You must be a member. Sign In if you are already a member.

  • 1,555 views
  • 1 version
  • 3 replies
  • 1 follower
     
Post Date:
November 4, 2011
Posted By:
Michael Moore

Related Content

    Search this area

    About this forum

    • 232k views
    • 3096 topics
    • 63 followers
       

    Post questions and find answers for all things related to the Standard and Premium Editions of WhatsUp gold.


    Viewed 1,555 times