ISSUE : Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server is not able to read SQL server error log files. We have checked that SQL Server Error log files are accessible on file system.
1) When we are running SP_readerrorlog, XP_readerrorlogs or XP_enumerrorlogs, query keeps running without showing results.
2) When We try to browse error logs from SQL Server GUI, the wizard is also hanging.
FINDINGS :
1) We found all sessions running & stuck on waittype “PREEMPTIVE_OS_GETPROCADDRESS”
PREEMPTIVE_OS_GETPROCADDRESS is a new wait type that was introduced in SQL Server 2008 to track time taken by GetProcAddress to load the entrypoint in the DLL when Extended Stored Procedure calls are made by the SQL Server instance.
2) We check what is actually SP_readerrorlog, XP_readerrorlogs or XP_enumerrorlogs trying to execute. As we all know, all this 3 store procedures are extended store procedure. Moreover, running same xpstart.dll
3) Other extended store procedures are working fine.
RESOLUTION :We have rebooted the server so that call to xpstar.dll will work properly.
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
We are having the same issue on a couple of our servers… Any chance you found out what caused it or if there is an alternative to rebooting the Server in order to resolve?
I did not find any other solution to resolve this. This issue may be occur due to API unresponsiveness.