Does anybody have any documentation on SQLIOSim? I'm looking to interpret the
results of SQLIOSim on some different storage that we have.
Thanks!

We are having performance problems with the new behaviour in SQL Server 2000
SP4 and later.
http://support.microsoft.com/kb/899976
The "workaround" is to run SQL Server with -T9059 flag. I just wonder if

I've posted this to the SQL wish center (Connect/sqlserver/feedback) as a
suggested new feature.
(https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281531).
Would appreciate your comments and thoughts towards feasibility and

The Environment:
I am running SQL2005 Enterprise on a DELL PE1900 with an PERC 5/i RAID
controler with latest driver and firmware.
Operating System is Windows Server 2003 R2 64bit Standard, the server is

I'm using an SSIS package to load 80 millions of rows in a table.
to load this I have a big query with 7 joins  to get my surrogate keys and
then load the fact table into my data warehouse.
The loading starts correctly, the speed is good (around 70 000 rows / sec)