December 11, 2008 at 10:13 am
hi
We are using Spot light for monitoring sql server.Its showing Virtual memory alarum.
We have 16gb RAM. In that its showing 15gb physical memory is used and vertual memory used is 15.5 out of 18gb.
What we need to do to reduce usage of vertual memory?
December 13, 2008 at 5:21 pm
Is sql server 32 bit or 64 bit? Whats the min and max server memory parameters setting?
MJ
December 13, 2008 at 6:30 pm
Its a SQL Server 2005 EE 64 bit. The memory settings are set to default values. We did not change the default values
thanks
December 14, 2008 at 5:07 am
ensure you set the min and max memory to the required settings for the RAM you are using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply