Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

how to configure sql server memory Expand / Collapse
Author
Message
Posted Saturday, November 29, 2008 4:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
I tried to google the querys I need to run inside query analyser in order to configure sql server memory to use 3GB, but I could'nt find. Please advice and also let me know the change I should do to the bin\config.sys file. Thanks!
Post #610799
Posted Saturday, November 29, 2008 5:37 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Use:

EXEC sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'min server memory', '0'

EXEC sp_configure 'max server memory', '3000'
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE

HTH.
MJ
Post #610808
Posted Saturday, November 29, 2008 9:13 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
Do I need to change config.sys file under the bin folder? Thanks.
Post #610831
Posted Sunday, November 30, 2008 2:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
You've left a lot of important information out.

32 bit? 64 bit?
What OS
What edition of SQL 2005?
How much memory does the server have?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #610843
Posted Sunday, November 30, 2008 2:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 6,318, Visits: 13,623
GilaMonster (11/30/2008)
You've left a lot of important information out.


you may or may not need to configure the /3GB switch in the boot.ini (i assume you meant this file and not the config.sys) and also enable AWE


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #610952
Posted Sunday, November 30, 2008 5:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
In addition to running the below queries:
Do we also need to configure the /3GB switch in the boot.ini file?
When do we enable AWE? before running these queries?

EXEC sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'min server memory', '0'

EXEC sp_configure 'max server memory', '3000'
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE

Thanks!
Post #610977
Posted Sunday, November 30, 2008 11:23 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
Mh (11/30/2008)
In addition to running the below queries:
Do we also need to configure the /3GB switch in the boot.ini file?
When do we enable AWE? before running these queries?


No idea. You haven't given us enough information. Please answer the questions I asked.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #611045
Posted Tuesday, December 2, 2008 9:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 15, Visits: 1,206
Hello !
I am kind of looking for the same answers.
Do I have to enable AWE and switch \3GB on 64 BIT SERVER 8GB RAM , Windows 2003 Standard /SQL 2005 Standard?
So far I configured max memory to 6GB on server
with minimum 1 GB.
Thank you.
Post #612141
Posted Tuesday, December 2, 2008 10:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
No. 3gb and AWE are for 32 bit only.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #612227
Posted Tuesday, December 2, 2008 10:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 15, Visits: 1,206
THANK YOU.
I guess this is not going to be problem to reverse it if I already enabled AWE in sp_configure
Post #612237
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse