xp_readerrorlog issues?
TedMaulUK
Posts: 4 Bronze 1
Hi,
Anyone had any issues with xp_readerrorlog in 7.1.2.8327 ? I'm seeing several instances as per the image which doesn't look good...
...and they all originate from SQL Monitor
kill doesn't work , removing that server from the list of monitored ones does nothing and stopping the actual monitoring service (which runs on a different server to that) does nothing either!
Short of rebooting this server in the middle of the day I'm at a loss as to what to do.
Any advice appreciated
Anyone had any issues with xp_readerrorlog in 7.1.2.8327 ? I'm seeing several instances as per the image which doesn't look good...
...and they all originate from SQL Monitor
kill doesn't work , removing that server from the list of monitored ones does nothing and stopping the actual monitoring service (which runs on a different server to that) does nothing either!
Short of rebooting this server in the middle of the day I'm at a loss as to what to do.
Any advice appreciated
Tagged:
Comments
SQL 2005 on Windows Server 2003R2 64 bit
You'll likely run into another issue after this in that Windows Server 2003 isn't supported by SQL Monitor v7 (and hasn't been since v5). It's apparently worked up until v7.0.8 where we switched over to using more WMI queries instead of remote registry, so you could get away with using v7.0.7 (download here) which also happens to not use xp_readerrorlog).
Kind regards,
Alex
Have you visited our Help Center?
Have got SP4 going on this week and have downgraded to v6 but for now everything is working as it should, cheers. Will upgrade back to 7.0.7 later on this week.