Hello,
I'm trying to change some Config options via Enterprise Manager, ie
Memory etc..
I can make the change with no problem but when I go back into the
Configuration options the change hasn't taken effect' It looks like the
sysadmin guys have locked down the server but any ideas where to look' If I
do an Sp_Configure <> Then it works fine?
Thanks
JulianHow do you have SQL Server registered in Enterprise Manager? Right clisk on
the server name and choose Edit SQL Server registration properties. Is the
same account that is running sp_configure from Query Analyzer? If the
account you are using is a sysadmin then you should have no problem from
Enterprise Manager.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Both running as SA
"Rand Boyd [MSFT]" wrote:
> How do you have SQL Server registered in Enterprise Manager? Right clisk on
> the server name and choose Edit SQL Server registration properties. Is the
> same account that is running sp_configure from Query Analyzer? If the
> account you are using is a sysadmin then you should have no problem from
> Enterprise Manager.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Showing posts with label memory. Show all posts
Showing posts with label memory. Show all posts
Tuesday, March 27, 2012
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.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
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
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.
Sunday, February 19, 2012
Concurrent query optimization
I have a server with Windows 2000, SQL Server 2000, 2 1GHz
processors and 1.5GHz of memory. The users were
complaining of slowness today from tehir web application.
The only message that I found in any of the logs was the
following:
This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 2 queries and
performance may be adversely affected.
I don't know if this is giving me any info cuz I don't
know what the message means. Is there anywhere (or
anyone) that can explain this to me?This probably means that you are not using Standard Edition or
Enterprise Edition of SQL-Server, but the MSDE or some other version
that cannot be licensed for real production loads.
The statement
SELECT @.@.version
should tell you which edition is installed.
Gert-Jan
Tom Griffin wrote:
> I have a server with Windows 2000, SQL Server 2000, 2 1GHz
> processors and 1.5GHz of memory. The users were
> complaining of slowness today from tehir web application.
> The only message that I found in any of the logs was the
> following:
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 2 queries and
> performance may be adversely affected.
> I don't know if this is giving me any info cuz I don't
> know what the message means. Is there anywhere (or
> anyone) that can explain this to me?|||Thanks for your reply. You are correct; this server was
installed with SQL Server 2000 Personal Edition. We have
the licensing for the Standard Edition, but apparently it
was not installed properly. Is there a "simple" method to
upgrade to the Standard Edition?
Tom
>--Original Message--
>This probably means that you are not using Standard
Edition or
>Enterprise Edition of SQL-Server, but the MSDE or some
other version
>that cannot be licensed for real production loads.
>The statement
> SELECT @.@.version
>should tell you which edition is installed.
>Gert-Jan
>
>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
application.
>> The only message that I found in any of the logs was the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>.
>|||See
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/instsql/in_overview_2xtf.asp
>--Original Message--
>Thanks for your reply. You are correct; this server was
>installed with SQL Server 2000 Personal Edition. We have
>the licensing for the Standard Edition, but apparently it
>was not installed properly. Is there a "simple" method
to
>upgrade to the Standard Edition?
>Tom
>>--Original Message--
>>This probably means that you are not using Standard
>Edition or
>>Enterprise Edition of SQL-Server, but the MSDE or some
>other version
>>that cannot be licensed for real production loads.
>>The statement
>> SELECT @.@.version
>>should tell you which edition is installed.
>>Gert-Jan
>>
>>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
>1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
>application.
>> The only message that I found in any of the logs was
the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>>.
>.
>
processors and 1.5GHz of memory. The users were
complaining of slowness today from tehir web application.
The only message that I found in any of the logs was the
following:
This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 2 queries and
performance may be adversely affected.
I don't know if this is giving me any info cuz I don't
know what the message means. Is there anywhere (or
anyone) that can explain this to me?This probably means that you are not using Standard Edition or
Enterprise Edition of SQL-Server, but the MSDE or some other version
that cannot be licensed for real production loads.
The statement
SELECT @.@.version
should tell you which edition is installed.
Gert-Jan
Tom Griffin wrote:
> I have a server with Windows 2000, SQL Server 2000, 2 1GHz
> processors and 1.5GHz of memory. The users were
> complaining of slowness today from tehir web application.
> The only message that I found in any of the logs was the
> following:
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 2 queries and
> performance may be adversely affected.
> I don't know if this is giving me any info cuz I don't
> know what the message means. Is there anywhere (or
> anyone) that can explain this to me?|||Thanks for your reply. You are correct; this server was
installed with SQL Server 2000 Personal Edition. We have
the licensing for the Standard Edition, but apparently it
was not installed properly. Is there a "simple" method to
upgrade to the Standard Edition?
Tom
>--Original Message--
>This probably means that you are not using Standard
Edition or
>Enterprise Edition of SQL-Server, but the MSDE or some
other version
>that cannot be licensed for real production loads.
>The statement
> SELECT @.@.version
>should tell you which edition is installed.
>Gert-Jan
>
>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
application.
>> The only message that I found in any of the logs was the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>.
>|||See
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/instsql/in_overview_2xtf.asp
>--Original Message--
>Thanks for your reply. You are correct; this server was
>installed with SQL Server 2000 Personal Edition. We have
>the licensing for the Standard Edition, but apparently it
>was not installed properly. Is there a "simple" method
to
>upgrade to the Standard Edition?
>Tom
>>--Original Message--
>>This probably means that you are not using Standard
>Edition or
>>Enterprise Edition of SQL-Server, but the MSDE or some
>other version
>>that cannot be licensed for real production loads.
>>The statement
>> SELECT @.@.version
>>should tell you which edition is installed.
>>Gert-Jan
>>
>>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
>1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
>application.
>> The only message that I found in any of the logs was
the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>>.
>.
>
Friday, February 17, 2012
Concurrent (completely independent) Statements.
Hi!
We are migrating an DB2 database to sql server 2005. We have used the 1.2 jdbc driver. It consumes lots of memory when we have several resultssets opened on different statments. Then we tried JTDS (http://jtds.sourceforge.net/), it worked fine. It's supports concurrent staments. We would like to stick with microsofts driver. My question is: will we se this supported in microsofts driver (soon)!
Joachim
Hi,
By any chance, are you setting the "responseBuffering" property to "adaptive"?
To keep back compatibility with our v1.1 driver behavior, our default behavior is to cache the entire resultset. So, in your scenario where you have multiple resultsets open at the same time, the driver will consume a lot of memory.
With responseBuffering=adaptive enabled, the driver will only consume as much memory as needed to retrieve the immediate data from the wire. Specifically, for CLOB and BLOB are streamed unless marked by the application.
I love to hear back if responseBuffering=adaptive resolves your scenario.
Jimmy
|||Hi!Setting the property responseBuffering=adaptive did not help. When the first statment is opened, there is no increase in memory usage. As soon as we opens the next resultset the memory usage start to increase rapidly. When we use the jdts driver this does not happend. As i wrote before, we would like to use the microsoft driver (its the corporate strategy).
But we need to see the memory handling as in jdts.
Thanks for your rapid replay.
Joachim
Concurrent (completely independent) Statements.
Hi!
We are migrating an DB2 database to sql server 2005. We have used the 1.2 jdbc driver. It consumes lots of memory when we have several resultssets opened on different statments. Then we tried JTDS (http://jtds.sourceforge.net/), it worked fine. It's supports concurrent staments. We would like to stick with microsofts driver. My question is: will we se this supported in microsofts driver (soon)!
Joachim
Hi,
By any chance, are you setting the "responseBuffering" property to "adaptive"?
To keep back compatibility with our v1.1 driver behavior, our default behavior is to cache the entire resultset. So, in your scenario where you have multiple resultsets open at the same time, the driver will consume a lot of memory.
With responseBuffering=adaptive enabled, the driver will only consume as much memory as needed to retrieve the immediate data from the wire. Specifically, for CLOB and BLOB are streamed unless marked by the application.
I love to hear back if responseBuffering=adaptive resolves your scenario.
Jimmy
|||Hi!Setting the property responseBuffering=adaptive did not help. When the first statment is opened, there is no increase in memory usage. As soon as we opens the next resultset the memory usage start to increase rapidly. When we use the jdts driver this does not happend. As i wrote before, we would like to use the microsoft driver (its the corporate strategy).
But we need to see the memory handling as in jdts.
Thanks for your rapid replay.
Joachim
Subscribe to:
Posts (Atom)