We are getting below error intermittently on Active Node . The same systems is running from past 5 Years.
This is SQL Server 2005 on Windows Server 2003 (Active/Passive).
Whenever we getting this error, We are failover from Node1(Active ) to Node2 (Passive) and rebooting the Node1. After successful reboot moving back to Node1.
We don't have any security/permissions use with SQL Server Agent.
Event Type: Error
Event Source: Perflib
Event Category: None
Event ID: 1023
Time: 10:52:09 PM
Windows cannot load extensible counter DLL SQLSERVERAGENT, the first DWORD in data section is the Windows error code.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0000: 08 00 00 00 ....
From the error message, this issue can occur if some other application blocks accessing some SQL Server agent dlls or folder, after restarting the server, the lock was released. If the issue occur again, I suggest following the steps on the KB912399 to take
related permissions first without restarting the nodes. If the issue persists, please let us know.
Event ID: 1023 occurs, and counter data is not logged when you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters http://support.microsoft.com/kb/912399