PRB: SQLMail Is Not Supported When You Run the Server in Fiber Mode

Article translations Article translations
Article ID: 308604 - View products that this article applies to.
This article was previously published under Q308604
Expand all | Collapse all

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 BUG: DTC Transactions Fail When SQL Runs in Lightweight Pooling

Properties

Article ID: 308604 - Last Review: October 9, 2003 - Revision: 3.1
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbprb KB308604

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com