Exchange Database Sessions Event ID 1164

tferro999
tferro999 used Ask the Experts™
on
So I have been having this recurring problem with my Exchange 2003 server for quite some time now.  About every two weeks ill come into work and find that my users cannot check their exchange email.  I check the server and all services are running.  When I check the event viewer I see...

Event ID 1164

No database session was available to satisfy a request on database "First Storage Group\Mailbox Store (SHREK)".  The number of sessions configured via the Active Directory attribute msExchESEParamMaxSessions on the storage group may be set too low for the level of activity on this storage group.
 The current value for this parameter is 209.

The first time I saw this error I did some searching on EE and found the following fix for it...

Ensure that you have opened ADSIEDIT on the DC or on the Exchange Server.
It does not matter even if you open using Workstation untill you have appropriate permissions.
Open Adsiedit
Right click on AdsiEdit and click on Connect to. A small window would open.
Look for "Select a Well Known Naming convention" and select "Configuration".
Click Ok and you should see Configuration[mybox.domain.com]
Expand this and you should see Cn=Configuration. Expand and reach to SErvices==>Microsoft Exchange==>Org Name ==> Administrative Groups==>First Administrative Group==>Server Name==> Information Store==>First Storage Group.
Right Click on the First Storage Group and then look for msExchESEParamMaxSessions value and edit it.

So back on 12/12/06 I change the value from 209 to 400.  What is strange is that I still get this error every 2 weeks or so and have to reboot the exchange server.  I tried checking this setting again using the same ADSIEDIT and to my suprise it does not exist anymore.  I did some searching on the Microsoft website and found the following article...

http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=Exchange&ProdVer=6.5.6940.0&EvtID=1164&EvtSrc=MSExchangeIS&LCID=1033

It says that sometimes you might not find the paramter msExchESEParamMaxSessions but dont be alarmed becuase you can calculate the same value from the following attributes..

msExchMaxPoolThreads (default value 4)

msExchMaxThreads (default value 100)

msExchBackgroundThreads (default value 57)

The number of sessions configured is: msExchMaxPoolThreads*number of processors)+msExchBackgroundThreads+(msExchMaxThreads*3/4).

So I look at the attributes of my Information store using ADSIEDIT to find these parameters and they don't exist either.

I'm completely lost at this point.  Apparently I have a very busy Exchange server that cant handle all of the incoming requests to the database.  This is understandable except for all the available fixes have not worked and I can't even find these attributes to attempt to change them.

Any Ideas???

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Expert of the Year 2007
Expert of the Year 2006

Commented:
The first thing I would suggest is run the Exchange Best Practises tool on the server and see if it flags anything.

Simon.

Author

Commented:
Health Check

Database and log files on same volume
IMAP4 fast message retrieval
WINS Primary is blank
PDC emulator is not excluded from Directory Service (DSAccess) topology
SMTP server accepts basic authentication
Crash upload logging disabled
Outlook connection range

None of these seem to be related to my problem but I could be wrong.
Expert of the Year 2007
Expert of the Year 2006

Commented:
Thing is, you shouldn't need to change those parameters at all. I don't think I have had to change them on any build i have done for some time, possibly back to E5.5 days.

Do you have anything else accessing the server? CRM, Blackberry etc? Something that could be causing the problem by not releasing sessions?

Simon.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Nope, nothing like that.  Just OWA, and exchange users.  Maybe the occasional POP3 or IMAP user.
Expert of the Year 2007
Expert of the Year 2006

Commented:
Any AV software configured to do a scan of the database at regular intervals?

Simon.

Author

Commented:
I'm running Sophos AV on this machine and although there are no scheduled scans, it does have on-access scanning.  It was set to scan whenever a file was read.  This could be why the database had so many sessions.

If I add an exclusion for the MDBDATA folder where the databases are held should this avoid that problem? Or do I need to exclude the entire Exchsrvr directory?
Expert of the Year 2007
Expert of the Year 2006
Commented:
The best practises with file based AV is to exclude the data folders, although I exclude the entire /exchsrvr folder so that the smtp traffic isn't touched either. If you have the transaction logs elsewhere then those should be excluded.

Any Exchange level AV that could be doing something similar?

Simon.

Author

Commented:
I have no Exchange specific AV software running on this server because our campus screens all the incoming traffic.  Hopefully those file exclusions take care of the problem.  Thanks for your help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial