October 17, 2007 at 11:54 am
I'm trying to get the best performance out of SQL2005 on our cluster. I have EMC Symetrix attached storage (via fiber). I want to set the disk with an offset but the documentation is confusing. First I want to have extended logical disk partitions. I also want to have Allocation Units of 64k. I'm told that for best performance I need to set (or align) the disks. Diskpart.exe can do this but only on MBR disk and not extended. So how (using diskpart.exe) do I set the 4096 byte offset or 64kb and 64kb allocation unit on an extended logical disk?
October 17, 2007 at 1:42 pm
Before getting to that point you should really need to Identify "IF" the I/O rate you have can not be reduced with proper index/design . This path is to be followed only if you can't reduce the load with better design and proper indexing.
Just my $0.02
* Noel
October 18, 2007 at 9:46 am
The IF is already answered based on montiroing so here is the big question or looking for the best recommendation: I have EMC Symetrex storage backend (2TB total) presented in LUNS of 136GB 8-way metas. What is the best to do for performance?
Servers are DL580 using MSCS and running Active/Active SQL instances
Opinion?
1) Disk type: Basic VS GPT (need hot fix: 284134)?
2) Allocation Unit size: 64K
3) Offset=1
October 19, 2007 at 2:33 am
You need to get together with your storage administrator. If you know nothing about how data is laid out in a SAN and the SA knows nothing abuot databases, the first 2 weeks will be a mutual learning curve. After that you should both know enough to get the best SQL performance out of the SAN.
If you are not able to discuss these issues with your SA, your work is likely to be as successful as apple bobbing.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
October 31, 2007 at 12:21 pm
it's in the windows 2003 documentation, but something like this
cmd
diskpart
select disk #
create partition primary offset = 64
than give it a drive letter and format with 64k alloction units
it won't really reduce the amount of data going though the fiber, but it is supposed to reduce the amount of seeks the hard drive does
November 2, 2007 at 1:11 am
Hey,
This should provide some background to help you and your SAN admin.
http://russia.emc.com/techlib/pdf/H2203_MS_SQL_Svr_Symm_ldv.pdf
Thanks,
Phillip Cox
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply