Microsoft KB Archive/148961

= XADM: Event ID 9037 Advising Increased JET Tables =

Article ID: 148961

Article Last Modified on 10/28/2006

-

APPLIES TO


 * Microsoft Exchange Server 4.0 Standard Edition
 * Microsoft Exchange Server 5.0 Standard Edition
 * Microsoft Exchange Server 5.5 Standard Edition

-



This article was previously published under Q148961



SYMPTOMS
When you run the Microsoft Exchange Server information store, the following error appears in the Windows NT Event Log:

Event:9037

Source:MSExchangeIS Private

Type:Error

Category:None

Description:

No database session was available to satisfy a request. The registry value SYSTEM\CurrentControlSet\Services\MSExchangeIS\ParametersPrivate\ Sessions may be set too low for the level of activity on this server.



CAUSE
This event ID is caused by slow response times from calls made to JET by the information store. By default, the information store opens 60 JET tables during initialization. In some cases this may not be adequate. Event ID 9037 is an error from the MSExchangeIS warning that the number of tables should be increased on the specific server receiving the error.



RESOLUTION
Increase the number of JET tables by adding the following registry setting under the HKEY_LOCAL_MACHINE subtree under the following subkey:

  SYSTEM\CurrentControlSet\Services\MSExchangeIS\ParametersPrivate
 * 1) Highlight the ParametersPrivate key. From the Edit menu, select Add Value. Add Value Name of "Sessions" and select Data Type as REG_DWORD. Select OK. Add value of 70 in Data dialog box and select Decimal. Choose OK.
 * 2) Restart the MSExchangeIS and monitor for the 9037 Event ID.

If this Event ID occurs again you will want to increase the sessions again until the error has been eliminated. Each Jet table that is opened will consume additional RAM on the machine so you will not want to configure this beyond what is necessary to avoid the error.



MORE INFORMATION
This related error can also be generated by the MSExchange Public IS.

Event:9038

Source:MSExchangeIS Public

Type:Error

Category:None

Description:

No database session was available to satisfy a request. The registry value SYSTEM\CurrentControlSet\Services\MSExchangeIS\ParametersPublic\ Sessions may be set too low for the level of activity on this server.

If this error occurs, the same changes outlined above apply. However, the "Sessions" addition should be added under the HKEY_LOCAL_MACHINE subtree under the following subkey:

  SYSTEM\CurrentControlSet\Services\MSExchangeIS\ParametersPublic

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

218439 XADM: PerfMon Counters for Monitoring Exchange DB Sessions

Keywords: kbprb kbusage KB148961

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.