Search Results | SQL Server Performance Forums

SQLIO testing

Post by: arkitek, Jun 1, 2007 in forum: Performance Tuning for Hardware Configurations

Dual 3.0Ghz Xeon Dual 4GB FC HBAs Hitachi Tagmastore USP600 SAN [SQLIO PARAM] e: estfile.dat 2 0x0 8192 SQLIO 8k sectorIOs/secMBs/sec Read -...

SQLIO testing

Post by: arkitek, Jun 1, 2007 in forum: Performance Tuning for Hardware Configurations

Dual 3.0Ghz Xeon Dual 2GB FC HBAs IBM DS4300 SAN RAID 10 with 10 74GB 15K [SQLIO PARAM] e: estfile.dat 2 0x0 8192 SQLIO 8k sectorIOs/secMBs/sec...

SQLIO testing

Post by: arkitek, Jun 1, 2007 in forum: Performance Tuning for Hardware Configurations

SQLIO 8k sectorIOs/secMBs/sec Read - Random2096.1516.38 Read - Sequential3651.3628.53 Write - Random 1985.0815.51 Write - Sequential1914.6814.96...

Need super duper fast I/O solution

Post by: arkitek, May 11, 2006 in forum: Performance Tuning for Hardware Configurations

Thanks Joe. I just read your article "System and Storage Configuration for SQL Server". Great article as I got some good info from it to start with....

Need super duper fast I/O solution

Post by: arkitek, May 10, 2006 in forum: Performance Tuning for Hardware Configurations

We want PERFORMANCE. I'm surprised with your opinion actually but saving $$$ is always good. Ultimately, we need a SAN also to take advantages of...

Need super duper fast I/O solution

Thread by: arkitek, May 10, 2006, 5 replies, in forum: Performance Tuning for Hardware Configurations

If cost is NOT an issue, what would be the best solution out there that will provide the fastest disk I/O performance that one can get? Don't laugh....

Newbie SAN performance question

Post by: arkitek, May 25, 2005 in forum: Performance Tuning for Hardware Configurations

I haven't come accross any vendors that publish IO numbers let alone from SQLIO. SQLIO is rather new from Microsoft specifically written to...

Newbie SAN performance question

Post by: arkitek, May 24, 2005 in forum: Performance Tuning for Hardware Configurations

Kilka, I'm calling it segment size since the SAN SW calls it that. It's the same as block size I believe. I'm in the same line of thought as you in...

Newbie SAN performance question

Post by: arkitek, May 17, 2005 in forum: Performance Tuning for Hardware Configurations

Having tried a dual HBA setup on a host, here are some performance stats: Baseline - Single HBA, SQLIO tests 1 LUN at a time Test1 - Single HBA,...

Newbie SAN performance question

Post by: arkitek, May 9, 2005 in forum: Performance Tuning for Hardware Configurations

Thanks again everyone. Cannonphoder, we do have the Turbo version. I will have to verify bios/firmware version. It's up-to-date I believe. All...

Newbie SAN performance question

Post by: arkitek, May 6, 2005 in forum: Performance Tuning for Hardware Configurations

Sorry I should clarify.... All these RAID arrays have their own dedicated drives from which a single logical drive is created. I just run the...

Newbie SAN performance question

Post by: arkitek, May 5, 2005 in forum: Performance Tuning for Hardware Configurations

Thank you very much gentlemen. I'm learning a great deal here. In doing some further SQLIO benchmarks, we do get some interesting numbers. I'm hope...

Newbie SAN performance question

Post by: arkitek, May 2, 2005 in forum: Performance Tuning for Hardware Configurations

Thanks Joe. I guess I'm falling into the same trap with anyone moving to SAN expecting much better results. All indications so far shows our SAN to...

Newbie SAN performance question

Thread by: arkitek, May 2, 2005, 24 replies, in forum: Performance Tuning for Hardware Configurations

Greetings, I'm rather new to the SAN environment so please bare with my newbie questions. We just got an IBM DS4300 in our environment and we're in...