June 6, 2005 at 1:18 pm
Hi, I have a Server running Windows 2000 sp4 and Sql Server 2000 sp4. It has Intranes Databases, suddenly no body can open the Intranet page, an error occured.
I tried to connect to my server but an error ocurr, then I looked at Event viewer and i saw a warning 17424 Warning: Open Objects parameter may be too low. The next error message 17426: Run sp_configure to increase the parameter value, both messages repeats many times.
Actually the server is running without error mesagges.
Does anyone has an Idea why it hapenned, and how to fix it?.
Thanks for your help.
June 6, 2005 at 2:52 pm
The error message is saying that there were no unused (unassigned) open objects available when one was needed, so an inactive (but assigned) had to be used for the new object. The message is repeated every 1000th time this happens.
What value do you have for the open objects configuration option? Execute this:
USE master
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configure 'open objects'
It is normally 0, which means that SQL Server dynamically manages it for you. If you set it to a higher value it will make SQL Server keep more available space for open objects, which could get rid of the error message. Unfortunately there does not seem to exist any good way of stating what value to use for this setting (undocumented DBCC DES can give you a hint of how many objects are in use right now), so in general the default value of 0 should be best.
In any case, I do not think that this error message in itself is what is causing the logon errors. It seems that you have a memory problem, since logins are not being handled correctly and dynamic memory settings seem to be lowered by SQL Server. Both of these memory allocations happen in the unreserved MemToLeave area which is not as large as the buffer pool, so if you are using for instance extended stored procedures then there might be something leaking memory there.
June 9, 2005 at 12:26 pm
Hey Chris, where did you get this piece of information --> "The message is repeated every 1000th time this happens."
... enquiring minds want to know ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 9, 2005 at 2:30 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply