- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Application Integration
- >
- Re: SQL Backups and VM Quiescing
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2014 10:58 AM
тАО10-06-2014 10:58 AM
IHAC with a SQL database on vmdk's. Their OS drive is now on the same datastore as their DB and logs. I noticed when a snapshot is called it quiesces the VM as well as the DB. If the OS is moved off the DB datastore as BP tells us to do, when the snapshot is called for the volume containing the datastore with the DB only, will it only quiesce the DB and the VM?
Thanks,
Bill
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2014 02:11 PM
тАО10-06-2014 02:11 PM
SolutionBill, It sounds like your OS, DB, and log volumes are all mapped to the same VMware datastore which is mapped to a single volume on the Nimble Storage Array. Then on the Nimble Storage array, you have a volume collection that is selected to have scheduled VMware integrated snapshots. If this is the case, when the snapshot occurs, the Nimble Storage array will ask VMwarefor permission to take a snapshot which in turn will use VMware tools installed on your OS to leverage VSS to quiesce the data for the snapshot. If you create a new volume on your Nimble Storage array, map it to a VMware datastore, and move your OS there, one of two things can happen. If this new volume is added to the same Nimble Storage Volume Collection, its snapshot schedule will be the same as the DB and logs volume, and the behavior will be the same as it is today. If you create a new volume collection for this OS volume and assign it a schedule, the OS and DB snapshots will be independent.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-18-2014 03:09 PM
тАО10-18-2014 03:09 PM
Re: SQL Backups and VM Quiescing
If the O\S, logs and DB are on different Datastores (Nimble Volumes) and you are using VMware integrated snapshots then regardless of the volume collection the VMware tools will invoke the VSS writers and quiesce everything that is VSS aware. That's my understanding.
For our larger SQL DB's I use in guest iSCSI volumes and disable the SQLServerWriter in VM tools and use the Nimble initiated VSS synchronization to quiesce and snap the SQL DB and Log volume pair.
Basically the VMware tools will see the all the disks and try to quiesce all the files even if you are only scheduling a snapshot of say the volume containing the O\S. Naturally the snapshot will only occur for the volume(s) in the collection.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-18-2014 03:19 PM
тАО10-18-2014 03:19 PM
Re: SQL Backups and VM Quiescing
Hi Bill,
You should consider using separate datastore(s) for logs with No Cache since there is little benefit in caching write intensive logs. The only time any serious reading of logs is required is during a restore or roll back after corruption. We are in the on-going process of migrating SQL servers from NetApp to Nimble and the DB's and logs are on the same logical drive and it has a negative impact on Cache utilization. Our DBA's are working to separate these fortunately.
Regards,
Mark.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2014 10:41 PM
тАО10-19-2014 10:41 PM
Re: SQL Backups and VM Quiescing
Perhaps I'm not quite correct about VMtools/Vcentre quiescing all disks based upon my understanding of the following extract from the Nimble VMware integration guide:- "
"vCenter communicates with the VMware VSS Services Support in VMware Tools to quiesce application
writes to LUNs that correspond to volumes associated with the volume collection. Snapshot creation is
then triggered, a VM application-consistent snapshot is created, and writes are unquiesced."
Having said that I have seen the SQL Server Writer being invoked on a VM with it's SQL DB and Logs on separate volumes (Datastores) even though those volumes were not in the Volume Collection.
Perhaps someone can give me a sanity check on this topic?