-
- Service Provider
- Posts: 880
- Liked: 164 times
- Joined: Aug 26, 2013 7:46 am
- Full Name: Bastiaan van Haastrecht
- Location: The Netherlands
- Contact:
Veeam SQL and memory usage
Hi,
I'm investigating an issue with SQL and memory usage on a Veeam B&R server. I got triggered by our monitoring software issued an warning for high pagefile usage on the B&R server. After investigating I found that SQL's memory was placed to the pagefile. The server has 10GB of memory which 7GB was used, so it had 3GB free to use. So why is SQL's being paged out.
Searching around on the net I've learned Windows will page out memory when it detects very low usage. The server is our main B&R with CC and a lot of jobs on it, memory usage stays on 7GB in physical, and does not change during running backup jobs. Also, the pagefile usage stays at the same level of about 70%. So during the backup you would expect SQL being more active so the pages would return to RAM, but that isn't the case, it stays at 70%.
Because our B&R is an VM, I do not like the IOPS from pagefile usage on disk while there's RAM available, and it's substantial.
Secondly, I've noticed Veeam does not set a memory limit on the SQL express instance. It's set to default "2147483647" MB, while with our lage scale setup the DB's are only at 250 and 300MB. It's best practice to set a limit not larger than the DB's. Perhaps this is the reason SQL is so low on active pages it gets paged out.
Any thoughts on this?
Regards,
Bastiaan
I'm investigating an issue with SQL and memory usage on a Veeam B&R server. I got triggered by our monitoring software issued an warning for high pagefile usage on the B&R server. After investigating I found that SQL's memory was placed to the pagefile. The server has 10GB of memory which 7GB was used, so it had 3GB free to use. So why is SQL's being paged out.
Searching around on the net I've learned Windows will page out memory when it detects very low usage. The server is our main B&R with CC and a lot of jobs on it, memory usage stays on 7GB in physical, and does not change during running backup jobs. Also, the pagefile usage stays at the same level of about 70%. So during the backup you would expect SQL being more active so the pages would return to RAM, but that isn't the case, it stays at 70%.
Because our B&R is an VM, I do not like the IOPS from pagefile usage on disk while there's RAM available, and it's substantial.
Secondly, I've noticed Veeam does not set a memory limit on the SQL express instance. It's set to default "2147483647" MB, while with our lage scale setup the DB's are only at 250 and 300MB. It's best practice to set a limit not larger than the DB's. Perhaps this is the reason SQL is so low on active pages it gets paged out.
Any thoughts on this?
Regards,
Bastiaan
======================================================
Veeam ProPartner, Service Provider and a proud Veeam Legend
Veeam ProPartner, Service Provider and a proud Veeam Legend
-
- Product Manager
- Posts: 6551
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: Veeam SQL and memory usage
Hi,
Thank you.
There was a discussion on a similar topic, please see this thread.Secondly, I've noticed Veeam does not set a memory limit on the SQL express instance<...>
Thank you.
-
- Product Manager
- Posts: 6551
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: Veeam SQL and memory usage
If setting up a new memory limit does not solve paging problem then I have a very dirty hack...
In case your B&R server is a VM which is not used for anything but backups, then you could try setting up a RAM drive and place your pagefile there...
In case your B&R server is a VM which is not used for anything but backups, then you could try setting up a RAM drive and place your pagefile there...
-
- Service Provider
- Posts: 880
- Liked: 164 times
- Joined: Aug 26, 2013 7:46 am
- Full Name: Bastiaan van Haastrecht
- Location: The Netherlands
- Contact:
Re: Veeam SQL and memory usage
Thats one way of doing it, thanks.
Found https://support.microsoft.com/en-us/kb/918483 which refers to Lock memory of a certain user account in RAM, this ensures SQL's memory is not paged out. But https://support.microsoft.com/en-us/kb/2659143 states it will not work on Express editions...
Found https://support.microsoft.com/en-us/kb/918483 which refers to Lock memory of a certain user account in RAM, this ensures SQL's memory is not paged out. But https://support.microsoft.com/en-us/kb/2659143 states it will not work on Express editions...
======================================================
Veeam ProPartner, Service Provider and a proud Veeam Legend
Veeam ProPartner, Service Provider and a proud Veeam Legend
-
- Product Manager
- Posts: 6551
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: Veeam SQL and memory usage
Hi,
Thank you for your reply!
I wanted to tell you about the Lock Memory feature, but then I thought that your blue nickname probably means that you are already aware
Thank you for your reply!
I wanted to tell you about the Lock Memory feature, but then I thought that your blue nickname probably means that you are already aware
-
- VeeaMVP
- Posts: 432
- Liked: 108 times
- Joined: Aug 02, 2011 1:06 pm
- Full Name: Joe Gremillion
- Location: Dallas, TX USA
- Contact:
Re: Veeam SQL and memory usage
I believe that SQL Express is limited to only 1 CPU and 1 GB RAM per instance. If you need any kind of performance or in a larger installation it's always best to put the Veeam Backup and Replication DB on a standard version of SQL.
https://msdn.microsoft.com/library/cc645993.aspx
https://msdn.microsoft.com/library/cc645993.aspx
Joe Gremillion
NA Core Solutions Architect - Central region
NA Core Solutions Architect - Central region
-
- Expert
- Posts: 179
- Liked: 9 times
- Joined: Mar 03, 2015 10:44 am
- Contact:
[MERGED] limit use RAM for SQL ?
I have observed that the MV where I have installed V B & R and ONE has a use of 95% ( mv has 4GB RAM) without work due to VEEAMSQL2012 process.
Can I limit the use of RAM to SQL2012 ( where installed veeam default )
Can I limit the use of RAM to SQL2012 ( where installed veeam default )
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Veeam SQL and memory usage
Adrian, please review above for some hints.
Who is online
Users browsing this forum: Bing [Bot], Majestic-12 [Bot] and 96 guests