Thanks,
I take it provides you a .dat file which you can test the I/O on the channels accordingly. I think SQLIOStress provided the docs on how to use the command but never a .dat file to actually send the data over. Thanks for the info, Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 2:24 PM To: NT System Admin Issues Subject: RE: Question on Defragging and SQL 2005 I like SQLIOSIM. It can tell you a LOT. Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Ziots, Edward [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 2:09 PM To: NT System Admin Issues Subject: RE: Question on Defragging and SQL 2005 I ma reading some of the SQL whitepapers, and for SAN based storage write aligning at 64K is recommended and since SQL takes pages in extents of 8 X 8 Pages I am looking to go with 64K. Although recommended sizes for the format can be up to 256K, and low at 4K. It depends on your read and writes and whether they are sequential or random. Logs are separate ( ON SAN (EMC DMX 1000)) from the Data Array both are RAID-5 on a 5+1 disk structure with 32GB of On Board cache on the SAN backend. Michael: Do you also use SQLIOStress or SQLIOSIM to test your disk I/O accordingly to see if you are getting the bandwidth you are expecting. ( HBA/SAN Switch/SAN backend cache, disk speed and throughput?) Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Michael B. Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 1:56 PM To: NT System Admin Issues Subject: RE: Question on Defragging and SQL 2005 If your log volumes and data volumes are separate, then defrag provides no benefit. Win 2008 automatically partitions at 1,024 K. On earlier OSes, I'm going at 128K for SQL and 64K for Exchange. Here is an (Exchange oriented) small article I wrote on the topic: http://theessentialexchange.com/blogs/michael/archive/2008/03/07/Exchang e-2007-Disk-Performance-Partition-Alignment-.aspx Regards, Michael B. Smith MCSE/Exchange MVP http://TheEssentialExchange.com From: Ziots, Edward [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 1:40 PM To: NT System Admin Issues Subject: Question on Defragging and SQL 2005 Does anyone use 3rd party defrag utilities with there SQL 2000/SQL 2005 instances. Also when you are setting up your disks, for clustering are you using write-alignment with your SAN at 64K and also parititioning at 64K? Z Edward E. Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
