- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Application Integration
- >
- Re: SQL/Exchange on VMDK Questions
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
тАО09-30-2014 11:12 AM
тАО09-30-2014 11:12 AM
I have a few questions for a new install. Both data and logs for SQL and Exchange will reside on vmdk's. We plan to separate the OS, data & logs onto different datastores.
- Is the Window's NPM required on the VM to take application consistent snapshots? Or is it handled by the VMWare tools?
- Is it safe to set the performance policy of the datastore of the data and logs to VMWare5? Assuming they used the default allocation size for NTFS.
- For the snapshots synchronization I assume I would set it to VMWare. Correct?
- For SQL, they are planning to setup replication via a log shipping tool. Is there anything special to take into account?
- For SQL, if I have multiple databases sharing a datastore for data & logs is there an issue with them all taking a backup at the same time?
Thank you,
Bill
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2014 05:59 AM
тАО10-01-2014 05:59 AM
SolutionHello Bill,
If you are placing your VMs on VMFS datastores then you will not need Windows NPM installed on the VMs themselves, as long as you select "vCenter" as the consistent snapshot method. This will use vCenter & VMtools to pause & synchronise the datasets before performing the snapshot. The caveat to this is you want to be conservative with the amount of VMs you are placing on the datastore; if you have 30+ VMs then all 30 will need to be paused and quieced before the snapshot can take place.
You should set the performance policy of the volume to VMware 5 if you intend to store different types of application on the same datastore. If you create a dedicated VMFS datastore JUST for SQL Logs (for example) then you can use the SQL Logs policy - the benefit here is that you're not cycling data through cache which doesn't need to be there. I would not recommend placing Logs and DB on the same datastore - create dedicated Log & DB datastores which will reduce cache burn and also optimise on block sizes at the same time.
Hope this helps!
twitter: @nick_dyer_
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2014 06:04 AM
тАО10-01-2014 06:04 AM
Re: SQL/Exchange on VMDK Questions
Thanks Nick. It was exactly what I was looking for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2014 10:49 PM
тАО10-19-2014 10:49 PM
Re: SQL/Exchange on VMDK Questions
Quote "If you are placing your VMs on VMFS datastores then you will not need Windows NPM installed on the VMs themselves, as long as you select "vCenter" as the consistent snapshot method. This will use vCenter & VMtools to pause & synchronise the datasets before performing the snapshot. The caveat to this is you want to be conservative with the amount of VMs you are placing on the datastore; if you have 30+ VMs then all 30 will need to be paused and quieced before the snapshot can take place."
Hence why I'm looking forward to VVols. One to One relationship between the VM and it's Disks/Volumes.