Post reply

sp_SQLSMTPMail up and died on us

  • December 31, 2009 at 2:52 pm

    #1098021

    I know these threads are old. A place for whom I do some work had the same problem and I wanted to share this just in case it might help someone.

    Rebooting helps for a while of course as mentioned above. As someone points out though, it is not pleasant to ask Networking to reboot every so often.

    The URL http://support.microsoft.com/kb/941105/en-us might describe the problem. This company has Windows Server 2003 and I think that the problem described with Windows Server 2003 in that URL is the problem at this place.

    The article at that URL says that there is a HOT FIX for the error messages after Sql Server 2005 or Sql Server 2000 has been running for some time on Windows Server 2003 or on Windows 2000: "Failed to load FileName.dll" and "Attempts to load any type of dll might fial within the Sql Server process."

    The article says that when you run Sql Server 2005/2000 on a Windows Server 2003-based or Windows Server 2000-based computer, you might get an error about a dll initialization routine failing.

    This problem occurs because no thread local storage (TLS) slot is available for the SQL Server process (Sqlservr.exe). This is a problem in Windows Server 2003 and in Windows 2000.

    When SQL Server unloads a DLL, the TLS slots that the DLL uses may not be released because of a problem in the TlsFree function. If SQL Server frequently loads various DLLs, and then unloads these DLLs, these DLLs use up all the available TLS slots. Eventually, SQL Server can no longer load a DLL that requires TLS slots.

    The article says that there is a HOT FIX to download for Windows Server 2003 and provides a "Workaround" for Windows Server 2000.

    Anyway, I just wanted to post this in case it is helpful to anybody who in the past wrote in this thread or anybody in the future who reads this thread.

  • December 31, 2009 at 3:16 pm

    #1098024

    Oh, I am sorry as now I see that the post just before mine provided the same URL that I provided. I had failed to notice that there is a second page of posts for this thread.

    Networking at this company refuses to download the Hot Fix for Windows Server 2003, so unfortunately I need to have this company's Networking reboot every time the sp_SQLSMTPMail emails stop being sent successfully.

    I also would be interested if anybody has tried the Hot Fix for Windows Server 2003 and whether or not the Hot Fix worked.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply