Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Event ID:2009 table reached the maximum size

Status
Not open for further replies.

Adminman

MIS
Nov 28, 2001
46
US
Every day on my PDC, the System Log is loaded of Event ID: 2009,Source: Srv,Type: Error. The description is: The server could not expand a table because the table reached the mximum size.

I checked out MS knowledge base article (Q 165815) and there it lists a couple of different errors that would apprear in the data. My error is listed as 0x3e9 (srv_table_file) "This indicates that no more file IDs (FIDS) can be allocated to rocess the various open file server message blocks (SMBs) because of a shortage of available FIDs." I followed their directions by checking out the currently open files and total opened files (Performance monitor). Level averages 49 and the number of file open (via srvr mgr) shows 59, well within the limit of 2048. Rebooting the server does not resolve the problem.

Any suggestions?

Thanks.
 
From eventid.net:
"This behavior can also occur if a third-party program has leaked memory and/or resources."

Anything funky running on the server?

-gbiello
 
gbiello-

No, there hasn't been anything new that been installed recently to raise a eye brow. Running MS SQL 6.5, with a custom front end, but that's been running fairly well since January. Only thing is one datat partition is running out of space (less than a gig). Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top