The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
174 views

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 ...
0
votes
1answer
335 views

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 ...
0
votes
3answers
1k views

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 ...
1
vote
4answers
547 views

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. ...
1
vote
1answer
429 views

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 ...