August 8, 2013 at 9:11 pm
Is SQLIOsim an older tool? Is SQLIOStress a newer tool? I want to stress test a SQL 2012 environment which is a VM environment.
Also, other than HammerDB, is there another TPC-C tool which is a freeware?
Any other ideas/tools for SQL Server bench mark testing?
I am trying to test one of our environment which is pre-production and is a clustered environment and hooked up to SAN which is RAID-DP.
The following are the statements I am trying to run and it errors out saying there is not enough space on the drive even though it has about a TB free.
This is what I have in params.txt
L:\sqlIO\testfile.dat 2 0x0 100
This is what I have in the batch file which contains the sqlio command
sqlio -kW -t16 -s180 -dl -o8 -frandom -b16 -BH -LS Testfile.dat
Error is:
do_ovlp_io: WriteFileEx: There is not enough space on disk.
file offset high: 0x00000493 low: 0x3a54c000
As you can see even though I say 100MB file, it creates a test file for 3.5 GB or something and finally fails saying there is not enough disk space when the L drive contains about 935GB free.
Any ideas?
August 9, 2013 at 5:51 am
SQLIO (and IOMeter) just test the raw capabilities of the IO subsystem
SQLIOSim tests SQL Server IO patterns and requirements
For benchmarking, try this: http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-dvdstore/. I also think Joe Chang has some benchmarking stuff you can download on http://www.qdpma.com/
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply