dbTalk Databases Forums  

SQLIOSim

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQLIOSim in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marcy Daeffler
 
Posts: n/a

Default SQLIOSim - 02-10-2009 , 10:07 AM






All,

We need to run some performance testing on a SQL Cluster to determine the
best HBA Queue Depth. We are going to use the SQLIOSim tool. I am not
familiar with this tool. How long does it take to run for each
configuration? We want to base line at 32 then bump it to 64 then to 128 to
see what the results are. I have been reading documentation and blogs on the
subject (Microsoft document on Best practices for HBA Queue Length as well as
Kevin Kline, Jack Sack and Christian Bolton's blogs). I see where the use
the tool to do this benchmarking but cannot find any specifics on how long it
takes each instance of the test to run.

I need to be able to schedule downtime from the developers to do the test.

Any assistance would be appreciated!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.