[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

set max memory for sql server

Posted on 2009-04-07
2
Medium Priority
?
315 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
1 Comment
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

873 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