February 27, 2009 at 2:04 am
We have a number of boxes each running a single instance (the default instance) with one user database. Each box runs some very low volume Windows file sharing, but apart from that they are dedicated to running SQL Server 7 SP4. All boxes have either 512MB or 1024MB of RAM.
A number of the boxes have had their "open objects" setting set to 1000. According to BOL, the default is 0, which allows it to be configured dynamically by SQL Server. Some of the boxes were upgraded from 6.5 but I haven't checked whether there is any correlation between those boxes and the settings yet.
Are there any specific reasons why someone might want to change this value?
The rest of the servers have the default value of 0 set, and there don't appear to be any issues with any servers whatever the setting. I'm not sure whether to look at changing the value to 0 across all servers or leave it alone (if it aint broke, don't fix it).
Cheers,
Simon 🙂
February 27, 2009 at 8:18 am
I don't know of a good reason to set this. I think it was something you might have altered in v6.5. Or maybe someone was getting an error at some point and wanted a min number available.
http://msdn.microsoft.com/en-us/library/aa196701(SQL.80).aspx
March 5, 2009 at 1:32 am
I've found out that all the servers were given a new installation of SQL 7 rather than upgrading to it from 6.5. Nobody is aware of any reason why the values were set so I'm going to change the value back to default on one of the servers and monitor it closely...
March 5, 2009 at 7:45 am
Simon Liddle (3/5/2009)
a new installation of SQL 7
New??
-- You can't be late until you show up.
March 6, 2009 at 2:24 am
tosscrosby (3/5/2009)
Simon Liddle (3/5/2009)
a new installation of SQL 7New??
The servers were clean installs with only SQL 7 installed - no SQL 6.5.
March 6, 2009 at 2:37 am
Simon Liddle (3/6/2009)
tosscrosby (3/5/2009)
Simon Liddle (3/5/2009)
a new installation of SQL 7New??
The servers were clean installs with only SQL 7 installed - no SQL 6.5.
I think tosscrosby was refering to the fact that they were new installations of SQL Server 7, given that SQL Server has moved on to version 2008 😉
As to your setting for open objects, this was pertinent in 6.5, I've used it myself there, not sure about 7.0. Perhaps try 1 server first, leave it for a bit and see what happens, monitoring it carefully.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply