Questions tagged [sqlio]
5 questions
1
vote
1 answer
SQLIO IOPS Explanation
OK. We have a few PowerEdge Rack servers that we use for MSSQL. I have one server that has 3 raid arrays of RAID 1 that are SATA. I can run SQLIO and get close to 6,000 IOPS. How is this even remotely possible?
C:\Program Files…
philfry
- 11
- 1
1
vote
4 answers
Does SQLIO lie when run from a Hyper-V guest on a VHD?
SQLIO seems like a useful tool. I thought it would be interesting to try to measure the speed difference between a physical disk and a VHD. So I ran SQLIO on the Hyper-V host on the physical drive. Results seemed reasonable. Then I ran it from…
ScottStonehouse
- 979
- 4
- 16
- 25
1
vote
1 answer
SQLIO Performance testing question
I am running into an issue performance tuning a SAN. I am testing 24 mount points that are RAID - 5 on an EMC DMX with SQLIO. The host I am testing on has 256GB of RAM and 32 cores.
I am using a Param file in my command line which looks like…
Craig Lucas
- 11
- 1
0
votes
1 answer
SQL IO and SAN troubles
We are running two servers with identical software setup but different hardware.
The first one is a VM on VMWare on a normal tower server with dual core xeons, 16 GB RAM and a 7200 RPM drive.
The second one is a VM on XenServer on a powerful brand…
James
- 1
0
votes
3 answers
Interpreting SQLIO test results
I've been running a series of load tests on a dedicated DB SAN from a pre-production cluster (Dell R710 connecting to a dedicated RAID10 SAN over 2 gigabit ethernet connections), and I'm not sure if I'm correctly interpreting the data.
For…
Scott Hawkins
- 101
- 5