- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- StoreVirtual Storage
- >
- Re: HP SAN P4000. Disk alignment for SQL Database ...
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
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
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
05-16-2012 04:21 PM
05-16-2012 04:21 PM
HP SAN P4000. Disk alignment for SQL Database VM on VMware version 4.1
Hi,
I've been asked by my boss to prepare a new Windows 2003 SP2 to run a SQL 2005 database. According to the specs from the software developers which will be using this server the VM will need to have a boot partition, 2 separate drives for each MDF file and one drive for the log files of the two databases.
My question is what, if any, special configuration is required for the database partitions (both log and database). Do I need to use diskpart and align the drives or does the P4000 get around those issues? If so, what alignment should I give it?
I have not done disk partition in quite some time but I thought these steps explained it well enough:
The databases themselves aren't that big but I want to ensure we're giving it maximum performance.
Thanks!
-JLF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-17-2012 03:59 AM
05-17-2012 03:59 AM
Re: HP SAN P4000. Disk alignment for SQL Database VM on VMware version 4.1
Yes you do for Windows 2003. (Feel sorry for ya, 2008 is much nicer and doesn't require disk aligning!)
Check out these docs:
Best Practices for Enabling Microsoft SQL Server with SANiQ
(used to be a bunch of Best Practice documents on the HP site for various applications, but can't seem to find those now...)