Solved

set max memory for sql server

Posted on 2009-04-07
2
308 Views
Last Modified: 2012-05-06
The memory usage of the process "sqlservr.exe" when it higher , the performance of SQL Server  was better

After applying windows update and configuring larger virtual memory, the memory usage of
"sqlservr.exe" has come down and so is the performance

I like to find if, I can tweak any parameters at SQL Server engine to make "sqlservr.exe" use larger memory allocation. If I can find a link to any article that treats this subject, it will be great too

currently min server memory is 0 , max server memory is a very large amount

Thanks
0
Comment
Question by:Greens8301
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 500 total points
ID: 24093543
the speed change is due to virtual memory usage. you can not control when windows will push the application memory to page file.  in the second scenario SQL memory is getting flushed to page file due to which the memory in the task manager shows less than what it is using.

use process explorer for better inforamtion about the SQL server process
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

some links that will help to understand memory usage of SQL
http://msdn.microsoft.com/en-us/library/aa905152(SQL.80).aspx
http://support.microsoft.com/kb/321363
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question