|
| | | Forum Member
 
Group: Forum Members
Last Login: 2 days ago @ 5:46:24 AM
Posts: 32, Visits: 104 |
| | Hi, I'm getting a fail on the SQL monitor. WUG is 11.0.3 on Win 2003 sever, the SQL is SQL 2000 on Win 2003 server. Any ideas what may be the problem? NB: If I use WMI to the SQL 2000 box from WUG's Active Monitors the counters are shown but seem to have a value of 0. MonSql own=[ MonSql:BUFFEP5_PEAD_MAX(Failed to load performance counter for 'MonSql:BUFFERS_READ_MAX'. Error=0x80041010) MonSql:BUFFEPS_WPITE_MAX(Failed to load performance counter for 'MonSql:BUFFERS_WRITE_MAX'. Error=0x80041010) MonSql :LOCKS_NUMWAIT_MAX(Failed to load performance counter for 'MonSql :LOCKS_NUMWAIT_MAX'. Error=0x80041010) MonSql :LOCKS_AVGWAIT_MAX(Failed to load performance counter for 'MonSql :LOCKS_AVGWAIT_MAX'. Error=0x80041010) MonSql :TPANSACTIONS_ACTIVE_MAX(Failed to load performance counter for 'MonSql :TRANSACTIONS_ACTIVE_MAX'. Error=0x80041010) MonSql :TPANSACTIONS_PEPSEC_MAX(Failed to load performance counter for 'MonSql :TRANSACTIONS_PERSEC_MAX'. Error=0x80041010) |
| |
| | | Forum 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. |
| |
|
|