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

SQL Server 2008 Memory Optimization Expand / Collapse
Author
Message
Posted Tuesday, September 15, 2009 10:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 9, 2014 10:00 AM
Points: 274, Visits: 1,469
How to optimize memory in SQL Server 2008. I am very new on this topic.Any help will be highly regarded.
Post #788694
Posted Wednesday, September 16, 2009 2:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 28, 2014 8:38 AM
Points: 103, Visits: 215
could you be more specific ? what's the issue you try to solve ? what goal you want to achieve ?

in general a starting pointer can be:
SQL Server 2008 Books Online (August 2009)
Memory Architecture
http://msdn.microsoft.com/en-us/library/ms187499.aspx
Post #788755
Posted Wednesday, September 16, 2009 6:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:17 AM
Points: 13,885, Visits: 28,280
If you have a problem that you can document that you're seeing with memory, it'll be possible to help. Otherwise, there's very little you need to do with memory on your server. It's largely managed by SQL Server itself. A few options you have for managing memory, optimize the application workload (tune the queries & processes), allocate more memory to SQL Server, switch to 64bit if you're on 32 (better and more memory available), if you're using 32bit and you have 4gb of memory you can use the /3gb switch in the boot.ini to access mroe memory for SQL Server, PAE memory beyond 4gb can be used in SQL server again by modifying the boot.ini.

That's about it. The most important thing you can do is write your queries and manage your processes such that they work well. After that, let SQL Server manage the memory for you.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #788881
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse