March 1, 2010 at 10:46 am
Hi,
We are using Spotlight to monitor SQL Server 2005 EE x64 with SP3 instance and we are gettting the below alert:
LowMemory - Percentage Free Virtual Memory Alarm2/15/2010 2:46:14 PMFree virtual memory is down to 23.51 percent.
Here are the details of process:
Process Name sqlservr
Process ID 4860
Mem Usage (MB) 12,683.75 MB
VM Size (MB) 12,747.93 MB
Processor 0.08%
CPU Kernal mode 0.11%
User -
Processor affinity All CPUs
Service MSSQLSERVER
Elapsed time 17d 21:39:20
Handles 1074
Threads 57
Prority 8
Page Faults / sec 2.29
Reads/Sec 0.47
Writes/Sec 2.34
IO/sec 3.44
Regarding Virtual Address space,
A process is limited to 2GB of address space no matter how much free RAM may be available.
But in our case, we can see 12 GB of Virtual Address space. Please advice me
March 1, 2010 at 10:51 am
There some good information on Christian Bolt's blog post about memory issues.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 1, 2010 at 11:04 am
Why would a process be limited to 2GB of memory on a 64 bit machine? I would look at what processes are consuming the memory. You can do this with Windows Task Manager, just make sure to check "Show processes from all users". Other general things to check - how much memory is allocated to SQL Server and how much is currently in the buffer cache and procedure cache. Also, has the account that runs SQL Server been granted the privilege to lock pages in memory?
Regards,
Toby
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply