DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 308604 - Last Review: October 9, 2003 - Revision: 3.1

This article was previously published under Q308604

SYMPTOMS

SQLMail may stop responding (hang) when the server that you are using is run in Fiber mode. Fiber mode is when you set the lightweight pooling option ON by using the sp_configure stored procedure.

When SQLMail stops responding:
  • You cannot invoke any new SQLMail functions such as:

    • xp_sendmail
    • xp_readmail
    • xp_findnextmsg
    • xp_deletemail

    -and-

  • Existing SQLMail connections do not work.
From a SQL Server perspective, generally all new non-SQLMail connections and existing non-SQLMail connections function normally. However, there may be rare situations in which SQL Server may also become unresponsive.

MORE INFORMATION

Both MAPI and SQLMail make use of "critical section" synchronization objects in their implementation. The implementation details of both MAPI and SQLMail may encounter situations where the initial thread is scheduled out after entering a critical section and later may get rescheduled to a different thread. The rescheduling to a different thread causes the program to stop responding. According to the Microsoft Windows 32 documentation, a thread that enters the critical section must be the same one to exit the critical section or the critical section is not released. If the critical section is not released, the program may stop responding. Due to these architectural limitations of SQLMail and MAPI, Microsoft does not recommend or support SQLMail when the server is running in Fiber mode.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
303287  (http://support.microsoft.com/kb/303287/EN-US/ ) BUG: DTC Transactions Fail When SQL Runs in Lightweight Pooling

APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbprb KB308604
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support