Can I use an SQL statement to configure an SQL server to use Fixed
Memory size as opposed to the default Dynamic ? I don't want to use
the GUI.
Thanks
Sid.Hello,
You will have to use SP_CONFIGURE system storedprocedure.
Below example will tell SQL Server to use 4 GB of RAM.
SP_CONFIGURE 'max server memory', 4096
RECONFIGURE
GO
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172763475.361495.109810@.p10g2000cwp.googlegroups.com...
> Can I use an SQL statement to configure an SQL server to use Fixed
> Memory size as opposed to the default Dynamic ? I don't want to use
> the GUI.
> Thanks
> Sid.
>|||I suppose you could use
sp_configure with the following arguments:
max server memory (MB)
min server memory (MB)
and then reconfigure. Any particular reason you want to turn off the dynamic
memory management?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I suppose you could use
> sp_configure with the following arguments:
> max server memory (MB)
> min server memory (MB)
> and then reconfigure. Any particular reason you want to turn off the dynam
ic
> memory management?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
We are configuring the memory of a server that runs one of our vendors
applications. If we don't set the memory constraints, the application
will eventually use all the memory and seize the server. Right now we
set the memory as fixed and set its size at half the system memory.
Is there any way to specify the fixed memory with a variable ?
( 50% )
Thanks
Sid.|||No, You will have set the memory in MB based on the physical memory
availability.
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172766417.255720.121360@.30g2000cwc.googlegroups.com...
> On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> We are configuring the memory of a server that runs one of our vendors
> applications. If we don't set the memory constraints, the application
> will eventually use all the memory and seize the server. Right now we
> set the memory as fixed and set its size at half the system memory.
> Is there any way to specify the fixed memory with a variable ?
> ( 50% )
> Thanks
> Sid.
>
>
>|||Something like this should do it:
declare @.x int
select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
from sys.dm_os_sys_info
exec sp_configure 'max server memory (MB)', @.x
reconfigure
exec sp_configure 'min server memory (MB)', @.x
reconfigure
Note that I'd thoroughly test this sort of code first - I haven't thoroughly
tested sys.dm_os_sys_info on different environments yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Something like this should do it:
> declare @.x int
> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> from sys.dm_os_sys_info
> exec sp_configure 'max server memory (MB)', @.x
> reconfigure
> exec sp_configure 'min server memory (MB)', @.x
> reconfigure
> Note that I'd thoroughly test this sort of code first - I haven't thorough
ly
> tested sys.dm_os_sys_info on different environments yet.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the example.
Question: Why are you not setting the 'fixed' as opposed to the Max
and Min ?|||> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
There is no such setting. There's a max and a min. The GUI fools us into bel
ieving that there's a
fixed, but it only sets max and min to the same value.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
> On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Thanks for the example.
> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
>|||On Mar 1, 12:54 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no such setting. There's a max and a min. The GUI fools us into b
elieving that there's a
> fixed, but it only sets max and min to the same value.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
When I try to execute I get "Incorrect syntax near the keywork 'as' "
Thanks
Sid.|||Sorry - it's from an earlier query. Please remove "as
Half_physical_memory_in_MB" and run it.
Paul Ibison
Showing posts with label size. Show all posts
Showing posts with label size. Show all posts
Sunday, March 25, 2012
Config SQL Server properties to use Fixed Memory
Can I use an SQL statement to configure an SQL server to use Fixed
Memory size as opposed to the default Dynamic ? I don't want to use
the GUI.
Thanks
Sid.
Hello,
You will have to use SP_CONFIGURE system storedprocedure.
Below example will tell SQL Server to use 4 GB of RAM.
SP_CONFIGURE 'max server memory', 4096
RECONFIGURE
GO
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172763475.361495.109810@.p10g2000cwp.googlegr oups.com...
> Can I use an SQL statement to configure an SQL server to use Fixed
> Memory size as opposed to the default Dynamic ? I don't want to use
> the GUI.
> Thanks
> Sid.
>
|||I suppose you could use
sp_configure with the following arguments:
max server memory (MB)
min server memory (MB)
and then reconfigure. Any particular reason you want to turn off the dynamic
memory management?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I suppose you could use
> sp_configure with the following arguments:
> max server memory (MB)
> min server memory (MB)
> and then reconfigure. Any particular reason you want to turn off the dynamic
> memory management?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
We are configuring the memory of a server that runs one of our vendors
applications. If we don't set the memory constraints, the application
will eventually use all the memory and seize the server. Right now we
set the memory as fixed and set its size at half the system memory.
Is there any way to specify the fixed memory with a variable ?
( 50% )
Thanks
Sid.
|||No, You will have set the memory in MB based on the physical memory
availability.
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172766417.255720.121360@.30g2000cwc.googlegro ups.com...
> On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> We are configuring the memory of a server that runs one of our vendors
> applications. If we don't set the memory constraints, the application
> will eventually use all the memory and seize the server. Right now we
> set the memory as fixed and set its size at half the system memory.
> Is there any way to specify the fixed memory with a variable ?
> ( 50% )
> Thanks
> Sid.
>
>
>
|||Something like this should do it:
declare @.x int
select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
from sys.dm_os_sys_info
exec sp_configure 'max server memory (MB)', @.x
reconfigure
exec sp_configure 'min server memory (MB)', @.x
reconfigure
Note that I'd thoroughly test this sort of code first - I haven't thoroughly
tested sys.dm_os_sys_info on different environments yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Something like this should do it:
> declare @.x int
> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> from sys.dm_os_sys_info
> exec sp_configure 'max server memory (MB)', @.x
> reconfigure
> exec sp_configure 'min server memory (MB)', @.x
> reconfigure
> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> tested sys.dm_os_sys_info on different environments yet.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the example.
Question: Why are you not setting the 'fixed' as opposed to the Max
and Min ?
|||On Mar 1, 12:54 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
> fixed, but it only sets max and min to the same value.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172772610.650684.3930@.v33g2000cwv.googlegrou ps.com...
>
>
>
>
>
>
> - Show quoted text -
When I try to execute I get "Incorrect syntax near the keywork 'as' "
Thanks
Sid.
|||Sorry - it's from an earlier query. Please remove "as
Half_physical_memory_in_MB" and run it.
Paul Ibison
|||On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Sorry - it's from an earlier query. Please remove "as
> Half_physical_memory_in_MB" and run it.
> Paul Ibison
I had already done that, but I still get " Invalid object name
'sys.dm_os_sys_info' "
I am using SQL 2k
Thanks
Sid.
Memory size as opposed to the default Dynamic ? I don't want to use
the GUI.
Thanks
Sid.
Hello,
You will have to use SP_CONFIGURE system storedprocedure.
Below example will tell SQL Server to use 4 GB of RAM.
SP_CONFIGURE 'max server memory', 4096
RECONFIGURE
GO
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172763475.361495.109810@.p10g2000cwp.googlegr oups.com...
> Can I use an SQL statement to configure an SQL server to use Fixed
> Memory size as opposed to the default Dynamic ? I don't want to use
> the GUI.
> Thanks
> Sid.
>
|||I suppose you could use
sp_configure with the following arguments:
max server memory (MB)
min server memory (MB)
and then reconfigure. Any particular reason you want to turn off the dynamic
memory management?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I suppose you could use
> sp_configure with the following arguments:
> max server memory (MB)
> min server memory (MB)
> and then reconfigure. Any particular reason you want to turn off the dynamic
> memory management?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
We are configuring the memory of a server that runs one of our vendors
applications. If we don't set the memory constraints, the application
will eventually use all the memory and seize the server. Right now we
set the memory as fixed and set its size at half the system memory.
Is there any way to specify the fixed memory with a variable ?
( 50% )
Thanks
Sid.
|||No, You will have set the memory in MB based on the physical memory
availability.
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172766417.255720.121360@.30g2000cwc.googlegro ups.com...
> On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> We are configuring the memory of a server that runs one of our vendors
> applications. If we don't set the memory constraints, the application
> will eventually use all the memory and seize the server. Right now we
> set the memory as fixed and set its size at half the system memory.
> Is there any way to specify the fixed memory with a variable ?
> ( 50% )
> Thanks
> Sid.
>
>
>
|||Something like this should do it:
declare @.x int
select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
from sys.dm_os_sys_info
exec sp_configure 'max server memory (MB)', @.x
reconfigure
exec sp_configure 'min server memory (MB)', @.x
reconfigure
Note that I'd thoroughly test this sort of code first - I haven't thoroughly
tested sys.dm_os_sys_info on different environments yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Something like this should do it:
> declare @.x int
> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> from sys.dm_os_sys_info
> exec sp_configure 'max server memory (MB)', @.x
> reconfigure
> exec sp_configure 'min server memory (MB)', @.x
> reconfigure
> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> tested sys.dm_os_sys_info on different environments yet.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the example.
Question: Why are you not setting the 'fixed' as opposed to the Max
and Min ?
|||On Mar 1, 12:54 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
> fixed, but it only sets max and min to the same value.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172772610.650684.3930@.v33g2000cwv.googlegrou ps.com...
>
>
>
>
>
>
> - Show quoted text -
When I try to execute I get "Incorrect syntax near the keywork 'as' "
Thanks
Sid.
|||Sorry - it's from an earlier query. Please remove "as
Half_physical_memory_in_MB" and run it.
Paul Ibison
|||On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Sorry - it's from an earlier query. Please remove "as
> Half_physical_memory_in_MB" and run it.
> Paul Ibison
I had already done that, but I still get " Invalid object name
'sys.dm_os_sys_info' "
I am using SQL 2k
Thanks
Sid.
Config SQL Server properties to use Fixed Memory
Can I use an SQL statement to configure an SQL server to use Fixed
Memory size as opposed to the default Dynamic ? I don't want to use
the GUI.
Thanks
Sid.Hello,
You will have to use SP_CONFIGURE system storedprocedure.
Below example will tell SQL Server to use 4 GB of RAM.
SP_CONFIGURE 'max server memory', 4096
RECONFIGURE
GO
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172763475.361495.109810@.p10g2000cwp.googlegroups.com...
> Can I use an SQL statement to configure an SQL server to use Fixed
> Memory size as opposed to the default Dynamic ? I don't want to use
> the GUI.
> Thanks
> Sid.
>|||I suppose you could use
sp_configure with the following arguments:
max server memory (MB)
min server memory (MB)
and then reconfigure. Any particular reason you want to turn off the dynamic
memory management?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I suppose you could use
> sp_configure with the following arguments:
> max server memory (MB)
> min server memory (MB)
> and then reconfigure. Any particular reason you want to turn off the dynamic
> memory management?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
We are configuring the memory of a server that runs one of our vendors
applications. If we don't set the memory constraints, the application
will eventually use all the memory and seize the server. Right now we
set the memory as fixed and set its size at half the system memory.
Is there any way to specify the fixed memory with a variable ?
( 50% )
Thanks
Sid.|||No, You will have set the memory in MB based on the physical memory
availability.
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172766417.255720.121360@.30g2000cwc.googlegroups.com...
> On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> I suppose you could use
>> sp_configure with the following arguments:
>> max server memory (MB)
>> min server memory (MB)
>> and then reconfigure. Any particular reason you want to turn off the
>> dynamic
>> memory management?
>> Cheers,
>> Paul Ibison SQL Server MVP,www.replicationanswers.com
> We are configuring the memory of a server that runs one of our vendors
> applications. If we don't set the memory constraints, the application
> will eventually use all the memory and seize the server. Right now we
> set the memory as fixed and set its size at half the system memory.
> Is there any way to specify the fixed memory with a variable ?
> ( 50% )
> Thanks
> Sid.
>
>
>|||Something like this should do it:
declare @.x int
select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
from sys.dm_os_sys_info
exec sp_configure 'max server memory (MB)', @.x
reconfigure
exec sp_configure 'min server memory (MB)', @.x
reconfigure
Note that I'd thoroughly test this sort of code first - I haven't thoroughly
tested sys.dm_os_sys_info on different environments yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Something like this should do it:
> declare @.x int
> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> from sys.dm_os_sys_info
> exec sp_configure 'max server memory (MB)', @.x
> reconfigure
> exec sp_configure 'min server memory (MB)', @.x
> reconfigure
> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> tested sys.dm_os_sys_info on different environments yet.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the example.
Question: Why are you not setting the 'fixed' as opposed to the Max
and Min ?|||> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
fixed, but it only sets max and min to the same value.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
> On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> Something like this should do it:
>> declare @.x int
>> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
>> from sys.dm_os_sys_info
>> exec sp_configure 'max server memory (MB)', @.x
>> reconfigure
>> exec sp_configure 'min server memory (MB)', @.x
>> reconfigure
>> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
>> tested sys.dm_os_sys_info on different environments yet.
>> Cheers,
>> Paul Ibison SQL Server MVP,www.replicationanswers.com
> Thanks for the example.
> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
>|||On Mar 1, 12:54 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Question: Why are you not setting the 'fixed' as opposed to the Max
> > and Min ?
> There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
> fixed, but it only sets max and min to the same value.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
>
> > On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> >> Something like this should do it:
> >> declare @.x int
> >> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> >> from sys.dm_os_sys_info
> >> exec sp_configure 'max server memory (MB)', @.x
> >> reconfigure
> >> exec sp_configure 'min server memory (MB)', @.x
> >> reconfigure
> >> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> >> tested sys.dm_os_sys_info on different environments yet.
> >> Cheers,
> >> Paul Ibison SQL Server MVP,www.replicationanswers.com
> > Thanks for the example.
> > Question: Why are you not setting the 'fixed' as opposed to the Max
> > and Min ... Hide quoted text -
> - Show quoted text -
When I try to execute I get "Incorrect syntax near the keywork 'as' "
Thanks
Sid.|||Sorry - it's from an earlier query. Please remove "as
Half_physical_memory_in_MB" and run it.
Paul Ibison|||On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Sorry - it's from an earlier query. Please remove "as
> Half_physical_memory_in_MB" and run it.
> Paul Ibison
I had already done that, but I still get " Invalid object name
'sys.dm_os_sys_info' "
I am using SQL 2k
Thanks
Sid.|||For SQL2K, check out below:
sysconfigures
syscurconfigs
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
> On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> Sorry - it's from an earlier query. Please remove "as
>> Half_physical_memory_in_MB" and run it.
>> Paul Ibison
> I had already done that, but I still get " Invalid object name
> 'sys.dm_os_sys_info' "
> I am using SQL 2k
> Thanks
> Sid.
>|||On Mar 2, 10:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> For SQL2K, check out below:
> sysconfigures
> syscurconfigs
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
>
> > On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> >> Sorry - it's from an earlier query. Please remove "as
> >> Half_physical_memory_in_MB" and run it.
> >> Paul Ibison
> > I had already done that, but I still get " Invalid object name
> > 'sys.dm_os_sys_info' "
> > I am using SQL 2k
> > Thanks
> > Sid.- Hide quoted text -
> - Show quoted text -
Nice to know those tables are there, but I didn't see a field for
system memory.
Sid.|||You mean row? Did you turn on "show advanced options"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172865017.402571.254540@.8g2000cwh.googlegroups.com...
> On Mar 2, 10:37 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> For SQL2K, check out below:
>> sysconfigures
>> syscurconfigs
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "sid" <sidwe...@.alexian.net> wrote in message
>> news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
>>
>> > On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> >> Sorry - it's from an earlier query. Please remove "as
>> >> Half_physical_memory_in_MB" and run it.
>> >> Paul Ibison
>> > I had already done that, but I still get " Invalid object name
>> > 'sys.dm_os_sys_info' "
>> > I am using SQL 2k
>> > Thanks
>> > Sid.- Hide quoted text -
>> - Show quoted text -
> Nice to know those tables are there, but I didn't see a field for
> system memory.
> Sid.
>|||As far as I can tell from digging through the system tables on SQL Server
2000 this info wasn't available to TSQL directly. You could read it in a COM
object and reference that in a stored proc using the sp_oa.. procedures.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 6, 4:32 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> As far as I can tell from digging through the system tables on SQL Server
> 2000 this info wasn't available to TSQL directly. You could read it in a COM
> object and reference that in a stored proc using the sp_oa.. procedures.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks Paul, thats about what I had figured.
I atleast got what I needed out of it.
Sid.
Memory size as opposed to the default Dynamic ? I don't want to use
the GUI.
Thanks
Sid.Hello,
You will have to use SP_CONFIGURE system storedprocedure.
Below example will tell SQL Server to use 4 GB of RAM.
SP_CONFIGURE 'max server memory', 4096
RECONFIGURE
GO
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172763475.361495.109810@.p10g2000cwp.googlegroups.com...
> Can I use an SQL statement to configure an SQL server to use Fixed
> Memory size as opposed to the default Dynamic ? I don't want to use
> the GUI.
> Thanks
> Sid.
>|||I suppose you could use
sp_configure with the following arguments:
max server memory (MB)
min server memory (MB)
and then reconfigure. Any particular reason you want to turn off the dynamic
memory management?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I suppose you could use
> sp_configure with the following arguments:
> max server memory (MB)
> min server memory (MB)
> and then reconfigure. Any particular reason you want to turn off the dynamic
> memory management?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
We are configuring the memory of a server that runs one of our vendors
applications. If we don't set the memory constraints, the application
will eventually use all the memory and seize the server. Right now we
set the memory as fixed and set its size at half the system memory.
Is there any way to specify the fixed memory with a variable ?
( 50% )
Thanks
Sid.|||No, You will have set the memory in MB based on the physical memory
availability.
Thanks
Hari
"sid" <sidwelle@.alexian.net> wrote in message
news:1172766417.255720.121360@.30g2000cwc.googlegroups.com...
> On Mar 1, 10:13 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> I suppose you could use
>> sp_configure with the following arguments:
>> max server memory (MB)
>> min server memory (MB)
>> and then reconfigure. Any particular reason you want to turn off the
>> dynamic
>> memory management?
>> Cheers,
>> Paul Ibison SQL Server MVP,www.replicationanswers.com
> We are configuring the memory of a server that runs one of our vendors
> applications. If we don't set the memory constraints, the application
> will eventually use all the memory and seize the server. Right now we
> set the memory as fixed and set its size at half the system memory.
> Is there any way to specify the fixed memory with a variable ?
> ( 50% )
> Thanks
> Sid.
>
>
>|||Something like this should do it:
declare @.x int
select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
from sys.dm_os_sys_info
exec sp_configure 'max server memory (MB)', @.x
reconfigure
exec sp_configure 'min server memory (MB)', @.x
reconfigure
Note that I'd thoroughly test this sort of code first - I haven't thoroughly
tested sys.dm_os_sys_info on different environments yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Something like this should do it:
> declare @.x int
> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> from sys.dm_os_sys_info
> exec sp_configure 'max server memory (MB)', @.x
> reconfigure
> exec sp_configure 'min server memory (MB)', @.x
> reconfigure
> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> tested sys.dm_os_sys_info on different environments yet.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks for the example.
Question: Why are you not setting the 'fixed' as opposed to the Max
and Min ?|||> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
fixed, but it only sets max and min to the same value.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
> On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> Something like this should do it:
>> declare @.x int
>> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
>> from sys.dm_os_sys_info
>> exec sp_configure 'max server memory (MB)', @.x
>> reconfigure
>> exec sp_configure 'min server memory (MB)', @.x
>> reconfigure
>> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
>> tested sys.dm_os_sys_info on different environments yet.
>> Cheers,
>> Paul Ibison SQL Server MVP,www.replicationanswers.com
> Thanks for the example.
> Question: Why are you not setting the 'fixed' as opposed to the Max
> and Min ?
>|||On Mar 1, 12:54 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Question: Why are you not setting the 'fixed' as opposed to the Max
> > and Min ?
> There is no such setting. There's a max and a min. The GUI fools us into believing that there's a
> fixed, but it only sets max and min to the same value.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172772610.650684.3930@.v33g2000cwv.googlegroups.com...
>
> > On Mar 1, 11:38 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> >> Something like this should do it:
> >> declare @.x int
> >> select @.x = physical_memory_in_bytes / 500.0 as Half_physical_memory_in_MB
> >> from sys.dm_os_sys_info
> >> exec sp_configure 'max server memory (MB)', @.x
> >> reconfigure
> >> exec sp_configure 'min server memory (MB)', @.x
> >> reconfigure
> >> Note that I'd thoroughly test this sort of code first - I haven't thoroughly
> >> tested sys.dm_os_sys_info on different environments yet.
> >> Cheers,
> >> Paul Ibison SQL Server MVP,www.replicationanswers.com
> > Thanks for the example.
> > Question: Why are you not setting the 'fixed' as opposed to the Max
> > and Min ... Hide quoted text -
> - Show quoted text -
When I try to execute I get "Incorrect syntax near the keywork 'as' "
Thanks
Sid.|||Sorry - it's from an earlier query. Please remove "as
Half_physical_memory_in_MB" and run it.
Paul Ibison|||On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Sorry - it's from an earlier query. Please remove "as
> Half_physical_memory_in_MB" and run it.
> Paul Ibison
I had already done that, but I still get " Invalid object name
'sys.dm_os_sys_info' "
I am using SQL 2k
Thanks
Sid.|||For SQL2K, check out below:
sysconfigures
syscurconfigs
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
> On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> Sorry - it's from an earlier query. Please remove "as
>> Half_physical_memory_in_MB" and run it.
>> Paul Ibison
> I had already done that, but I still get " Invalid object name
> 'sys.dm_os_sys_info' "
> I am using SQL 2k
> Thanks
> Sid.
>|||On Mar 2, 10:37 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> For SQL2K, check out below:
> sysconfigures
> syscurconfigs
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "sid" <sidwe...@.alexian.net> wrote in message
> news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
>
> > On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> >> Sorry - it's from an earlier query. Please remove "as
> >> Half_physical_memory_in_MB" and run it.
> >> Paul Ibison
> > I had already done that, but I still get " Invalid object name
> > 'sys.dm_os_sys_info' "
> > I am using SQL 2k
> > Thanks
> > Sid.- Hide quoted text -
> - Show quoted text -
Nice to know those tables are there, but I didn't see a field for
system memory.
Sid.|||You mean row? Did you turn on "show advanced options"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sid" <sidwelle@.alexian.net> wrote in message
news:1172865017.402571.254540@.8g2000cwh.googlegroups.com...
> On Mar 2, 10:37 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> For SQL2K, check out below:
>> sysconfigures
>> syscurconfigs
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "sid" <sidwe...@.alexian.net> wrote in message
>> news:1172851212.691239.101580@.s48g2000cws.googlegroups.com...
>>
>> > On Mar 1, 4:59 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> >> Sorry - it's from an earlier query. Please remove "as
>> >> Half_physical_memory_in_MB" and run it.
>> >> Paul Ibison
>> > I had already done that, but I still get " Invalid object name
>> > 'sys.dm_os_sys_info' "
>> > I am using SQL 2k
>> > Thanks
>> > Sid.- Hide quoted text -
>> - Show quoted text -
> Nice to know those tables are there, but I didn't see a field for
> system memory.
> Sid.
>|||As far as I can tell from digging through the system tables on SQL Server
2000 this info wasn't available to TSQL directly. You could read it in a COM
object and reference that in a stored proc using the sp_oa.. procedures.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On Mar 6, 4:32 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> As far as I can tell from digging through the system tables on SQL Server
> 2000 this info wasn't available to TSQL directly. You could read it in a COM
> object and reference that in a stored proc using the sp_oa.. procedures.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks Paul, thats about what I had figured.
I atleast got what I needed out of it.
Sid.
Config changes on SQL 2k don't stick.
We have a SQL 2k server and we are trying change the file size to
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLSer...=12717
7
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.comsqlsql
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLSer...=12717
7
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.comsqlsql
Thursday, March 22, 2012
Config changes on SQL 2k don't stick.
We have a SQL 2k server and we are trying change the file size to
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.
1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.
|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.
1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.
|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
Config changes on SQL 2k don't stick.
We have a SQL 2k server and we are trying change the file size to
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> > We have a SQL 2k server and we are trying change the file size to
> > increase its self by Mbytes as opposed to percent.
> >
> > But the setting won't stick. You can select it, "OK" close the config
> > manager and open it back up and its set back to "Percent".
> >
> > Yes, I have rights and I did select OK and we booted the machine
> > several times.
> >
> > Any help is appreciated.
> >
> > Thanks
> >
> > Sid.
> >
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
increase its self by Mbytes as opposed to percent.
But the setting won't stick. You can select it, "OK" close the config
manager and open it back up and its set back to "Percent".
Yes, I have rights and I did select OK and we booted the machine
several times.
Any help is appreciated.
Thanks
Sid.1) What account are you using to make this change?
2) What release of SQL Server are you using?
3) How are you trying to implement this change (EM, QA?)
4) Are there any messages in either the SQL Server or server event
logs that suggest anything?
5) Was this database originally created on the server or was it
transferred from another server or a different version of SQL Server
(e.g. 7.0)?
On 1 Nov 2006 14:08:56 -0800, "sid" <sidwelle@.alexian.net> wrote:
>We have a SQL 2k server and we are trying change the file size to
>increase its self by Mbytes as opposed to percent.
>But the setting won't stick. You can select it, "OK" close the config
>manager and open it back up and its set back to "Percent".
>Yes, I have rights and I did select OK and we booted the machine
>several times.
>Any help is appreciated.
>Thanks
>Sid.|||Hello, sid
A related bug is being discussed on Microsoft Connect:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177
Razvan
sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.|||sid wrote:
> We have a SQL 2k server and we are trying change the file size to
> increase its self by Mbytes as opposed to percent.
> But the setting won't stick. You can select it, "OK" close the config
> manager and open it back up and its set back to "Percent".
> Yes, I have rights and I did select OK and we booted the machine
> several times.
> Any help is appreciated.
> Thanks
> Sid.
>
Try setting the growth options using ALTER DATABASE instead of the GUI...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We did find that on one of our test servers we were experiencing the
same problem that we could make the change stick through the GUI by
just selecting the "growth by Mbytes" and not changing the amount
setting away from "1 meg" until after a boot. It just shouldn't be that
way ...
We'll try it on the live server today.
I'll try the "Alter " command next.
Thanks
Sid.
Tracy McKibben wrote:
> sid wrote:
> > We have a SQL 2k server and we are trying change the file size to
> > increase its self by Mbytes as opposed to percent.
> >
> > But the setting won't stick. You can select it, "OK" close the config
> > manager and open it back up and its set back to "Percent".
> >
> > Yes, I have rights and I did select OK and we booted the machine
> > several times.
> >
> > Any help is appreciated.
> >
> > Thanks
> >
> > Sid.
> >
> Try setting the growth options using ALTER DATABASE instead of the GUI...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
Subscribe to:
Posts (Atom)