Keep running out of memory?

There is a server configuration called 'Open Objects' that
you will need to modify.
Run this to determine current count (look for open objects
in results)
USE master
EXEC sp_configure 'show advanced option', '1'
--Here is the message:
Configuration option 'show advanced options' changed from
0 to 1.
Run the RECONFIGURE command to install.
RECONFIGURE
EXEC sp_configure
If you need to increase it, just use this command
USE master
EXEC sp_configure 'OPEN OBJECTS', '#of objects'

>--Original Message--
>Does anyone know how-to fix this error?
>17424 :
>Warning: OPEN OBJECTS parameter may be too low.
>
>.
>The values defaults to 0, which means auto-config. SQL Server will use the m
emory as it needs for open
objects. This error message often indicates that one need more memory in the
machine, quite simply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"sbauer" <anonymous@.discussions.microsoft.com> wrote in message news:e4c701c411d9$b3bcd950$
a001280a@.phx.gbl...
> There is a server configuration called 'Open Objects' that
> you will need to modify.
> Run this to determine current count (look for open objects
> in results)
> USE master
> EXEC sp_configure 'show advanced option', '1'
> --Here is the message:
> Configuration option 'show advanced options' changed from
> 0 to 1.
> Run the RECONFIGURE command to install.
> RECONFIGURE
> EXEC sp_configure
> If you need to increase it, just use this command
> USE master
> EXEC sp_configure 'OPEN OBJECTS', '#of objects'
>|||I have 4 Gig of memory in this server and a pretty small database (50 meg).
Do you still think it is a memory problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> The values defaults to 0, which means auto-config. SQL Server will use the
memory as it needs for open
> objects. This error message often indicates that one need more memory in
the machine, quite simply.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "sbauer" <anonymous@.discussions.microsoft.com> wrote in message
news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||What are your settings (sp_configure) for max server memory and open objects
?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.ph
x.gbl...
> I have 4 Gig of memory in this server and a pretty small database (50 meg)
.
> Do you still think it is a memory problem?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> memory as it needs for open
> the machine, quite simply.
> news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
was already set to 1. So I changed it back to '0' and hopefully auto config
should work better. What do you think? Below are those settings you ask
for:
Server Memory
Minimum 4
Maximum: 2147483647
Config_value: 2147483647
Run_value: 2147483647
Open Objects
Minimum 0
Maximum 2147483647
Config_value 1000
Run_value 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> What are your settings (sp_configure) for max server memory and open
objects?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
meg).
in
the
in
>|||Show advanced options does not control auto-config for the other options. It
does only that the option name
implies.
Someone has configured open objects to 1000, way way too low for a productio
n environment. I recommend you set
it back to auto, 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uMtja6nEEHA.1272@.TK2MSFTNGP12.ph
x.gbl...
> when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
> was already set to 1. So I changed it back to '0' and hopefully auto conf
ig
> should work better. What do you think? Below are those settings you ask
> for:
> Server Memory
> Minimum 4
> Maximum: 2147483647
> Config_value: 2147483647
> Run_value: 2147483647
> Open Objects
> Minimum 0
> Maximum 2147483647
> Config_value 1000
> Run_value 1000
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> objects?
> news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
> meg).
> in
> the
> in
>|||How do you set it back to auto? Is the below values correct for auto?
open objects
Minimum: 0
Maximum: 2147483647
Config_Value: 0
Run_Value: 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Show advanced options does not control auto-config for the other options.
It does only that the option name
> implies.
> Someone has configured open objects to 1000, way way too low for a
production environment. I recommend you set
> it back to auto, 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
I
config
ask
in
(50
wrote
use
memory
>|||All parameters for sp_configure are documented in Books Online. For Open Obj
ects, 0 is auto config. After
setting this, you need to execute RECONFIGURE and for some parameters, you a
lso need to restart SQL Server
(check BOL if this is one of these). It seems you have already set it to 0,
but that value if not in effect
yes (run_value is 1000) so you either need to do RECONFIGURE or restart SQL
Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:OTI17xzEEHA.3976@.TK2MSFTNGP12.ph
x.gbl...
> How do you set it back to auto? Is the below values correct for auto?
> open objects
> Minimum: 0
> Maximum: 2147483647
> Config_Value: 0
> Run_Value: 1000
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> It does only that the option name
> production environment. I recommend you set
> news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
> I
> config
> ask
> in
> (50
> wrote
> use
> memory
>|||Thanks for all the help! A reboot fixed it, all is working fine now!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Lks540EEHA.3344@.tk2msftngp13.phx.gbl...
> All parameters for sp_configure are documented in Books Online. For Open
Objects, 0 is auto config. After
> setting this, you need to execute RECONFIGURE and for some parameters, you
also need to restart SQL Server
> (check BOL if this is one of these). It seems you have already set it to
0, but that value if not in effect
> yes (run_value is 1000) so you either need to do RECONFIGURE or restart
SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:OTI17xzEEHA.3976@.TK2MSFTNGP12.phx.gbl...
in
options.
'1'
auto
you
wrote
open
database
<tibor_please.no.email_karaszi@.hotmail.nomail.com>
will
message
>