I have SQL 2000 server with two instances installed on the
box. The server has 4 GB RAM.
(1)How can I choose SQL server memory settings to obtain
better performance for both instances?
(2)Should I choose "Dynamic" setting or "Fixed memory"
setting?
Thanks in advance.
DonActually, there is no direct answer for this. It depends
on how much memory is required for SQL Server and
applications using this sql server.
It also depends on any other applications running on the
same box.
In General, You have to allocate for OS,SQLServer and
then for other applications.
Please read this to get some idea on how SQL Server memory
works. http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_config_9zfy.asp
Also , read "memory architecture" from BOL.
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>I have SQL 2000 server with two instances installed on
the
>box. The server has 4 GB RAM.
>(1)How can I choose SQL server memory settings to obtain
>better performance for both instances?
>(2)Should I choose "Dynamic" setting or "Fixed memory"
>setting?
>Thanks in advance.
>Don
>.
>|||Thanks for your good recommendation.
-Don
>--Original Message--
>Actually, there is no direct answer for this. It depends
> on how much memory is required for SQL Server and
>applications using this sql server.
>It also depends on any other applications running on the
> same box.
> In General, You have to allocate for OS,SQLServer and
>then for other applications.
> Please read this to get some idea on how SQL Server
memory
> works. http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_config_9zfy.asp
> Also , read "memory architecture" from BOL.
> SQLVarad (MCDBA-1999,MCSE-1999)
>>--Original Message--
>>I have SQL 2000 server with two instances installed on
>the
>>box. The server has 4 GB RAM.
>>(1)How can I choose SQL server memory settings to obtain
>>better performance for both instances?
>>(2)Should I choose "Dynamic" setting or "Fixed memory"
>>setting?
>>Thanks in advance.
>>Don
>>.
>.
>|||Don,
What edition of sql server are you running? If it's std edition then you
can only use 2GB (actually 1.7) per instance anyway. Unless you know for
sure that one instance always needs more than the other or you have other
apps that always require a specific amount you are probably best to leave it
dynamic. That way the two instances can give and take as needed.
--
Andrew J. Kelly
SQL Server MVP
"Don Walter" <dw_msg@.yahoo.com> wrote in message
news:078501c3a409$fa4199d0$a301280a@.phx.gbl...
> I have SQL 2000 server with two instances installed on the
> box. The server has 4 GB RAM.
> (1)How can I choose SQL server memory settings to obtain
> better performance for both instances?
> (2)Should I choose "Dynamic" setting or "Fixed memory"
> setting?
> Thanks in advance.
> Don
Showing posts with label memory. Show all posts
Showing posts with label memory. Show all posts
Wednesday, March 7, 2012
How to Set Max Memory?
I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
How to Set Max Memory?
I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!
You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!
|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>
|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!
You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!
|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>
|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
How to Set Max Memory?
I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >
> >
> >Any help would be appreciated.
> >Thanks!
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >Any help would be appreciated.
> >Thanks!- Hide quoted text -
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >
> >
> >Any help would be appreciated.
> >Thanks!
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >Any help would be appreciated.
> >Thanks!- Hide quoted text -
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.
How to set -g startup option? is it permanent?
Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003
Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.c om...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003
Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.c om...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
How to set -g startup option? is it permanent?
Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
How to set -g startup option? is it permanent?
Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
Subscribe to:
Posts (Atom)