patternsqlMinor
Database IO comparison
Viewed 0 times
databasecomparisonstackoverflow
Problem
We're running sql server on vmware. Our san is pretty new but still I think I/O is pretty crappy even though I'm supposed to be on separate spindels. Server speeds are:
My client machine:
Is our san slow? Can I get some comparative values from other users? If so please let me know if you're on a vm or a physical machine. It looks like it's doing pretty ok writing but reading is really terrible...
My client machine:
Is our san slow? Can I get some comparative values from other users? If so please let me know if you're on a vm or a physical machine. It looks like it's doing pretty ok writing but reading is really terrible...
Solution
The performance numbers that someone else gets from their array compared to the numbers that you get are totally meaningless. I could have 1000 disks in my array backed with 512 Gigs of cache or I could have 2 7200 RPM disks in a RAID 10.
Without knowning the exact configuration that your array is configured in the numbers are just numbers.
Another thing to note is that 4k IO are a worthless measure as are 512k IO. SQL Server will be doing almost all of it's IO in 64k IO.
Without knowning the exact configuration that your array is configured in the numbers are just numbers.
Another thing to note is that 4k IO are a worthless measure as are 512k IO. SQL Server will be doing almost all of it's IO in 64k IO.
Context
StackExchange Database Administrators Q#28713, answer score: 6
Revisions (0)
No revisions yet.