September 15, 2009 at 10:33 pm
How to optimize memory in SQL Server 2008. I am very new on this topic.Any help will be highly regarded.
September 16, 2009 at 2:01 am
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
September 16, 2009 at 6:49 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply