Improve company productivity with a Business Account.Sign Up

x
?
Solved

set max memory for sql server

Posted on 2009-04-07
2
Medium Priority
?
318 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

588 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