July 9, 2009 at 2:33 am
Currently our database server, 8cpu's 16gig ram, consistently uses 94%-98% of physical memory and 47%-49% of virtual memory. Is this to be expected and if not are there any methods to reduce this memory usage
July 9, 2009 at 7:13 am
What is your environment? Windows version/edition, SQL Server version/edition? 32 or 64 bit etc?
July 9, 2009 at 7:13 am
What is your environment? Windows version/edition, SQL Server version/edition? 32 or 64 bit etc?
July 10, 2009 at 4:29 am
dwaggott (7/9/2009)
Currently our database server, 8cpu's 16gig ram, consistently uses 94%-98% of physical memory and 47%-49% of virtual memory. Is this to be expected and if not are there any methods to reduce this memory usage
The physical memory usage seems a touch high - even on a dedicated server. I normally recommend leaving at least 1GB RAM free (yours is around 350MB), so make sure you have set the max memory sp_configure setting appropriately - especially if you are using AWE or lock pages in memory. The virtual memory situation depends on which counter you are using to measuring it, along with the other questions already posted.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply