- Community Home
- >
- Storage
- >
- HPE Nimble Storage
- >
- Application Integration
- >
- Re: SQL/Exchange on VMDK Questions
-
-
Forums
- Products
- Servers and Operating Systems
- Storage
- Software
- Services
- HPE GreenLake
- Company
- Events
- Webinars
- Partner Solutions and Certifications
- Local Language
- China - 简体中文
- Japan - 日本語
- Korea - 한국어
- Taiwan - 繁體中文
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Latin America
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Blog, Poland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Forums
-
Blogs
-
Information
-
English
- 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.
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2022 Hewlett Packard Enterprise Development LP