October 3, 2012 at 10:46 am
I am new to troubleshooting memory. We are on SQL Server 2008 R2, 50Gb database on a VM. Currently there is 10GB memory for the entire server. 8.5 allocated to SQL server. We have purchased SQL monitor and we get memory alerts all day long of course when a back up job or SQL job is running. then the alerts goes away once the job is done.
Are there requirements anywhere to show a baseline on what to add or use on a 50GB database?
Thanks
October 3, 2012 at 5:48 pm
D-SQL (10/3/2012)
Are there requirements anywhere to show a baseline on what to add or use on a 50GB database?Thanks
There are so many variables to consider in memory usage problems. If you're just running out of memory frequently and paging to disk a lot, and are running an application and have support from its vendor, consider asking them for recommendations on sizing and performance expectations.
What virtualization technology are your VMs running on? There are special considerations for VMs, due to the nature of how they work. We use Microsoft Hyper-V here so if you're on that I can give some further pointers.
October 3, 2012 at 5:51 pm
By the way, SQL Server consuming all its available memory isn't unusual. In fact, it's usually a good thing when configured right and the OS has room to breathe. I had to tone down the memory warnings in SQL Monitor as it often was alerting me to things which really aren't problems. When you have 50Gb of data and 8.5Gb of memory, you're almost guaranteed to use it all.
October 4, 2012 at 2:31 am
In activity monitor Resource waits Order by Cumulative Wait Time desc in the 1st or 2nd BUFFER I/O is there
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply