- Community Home
- >
- Storage
- >
- Midrange and Enterprise Storage
- >
- StoreVirtual Storage
- >
- HP Lefthand SAN and use for SQL 2012 cluster
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2013 08:00 PM
07-15-2013 08:00 PM
HP Lefthand SAN and use for SQL 2012 cluster
Hello all,
Just if someone can advice me regarding my SQLIO results i have run from one of my WMware virtual test SQL servers to my ISCSI 64K formatted drive on the same network 10 raided Lefthand SAN. Are these results consisted with my 1GB ISCSI SAN and is it enough to support a busy SQL cluster? Thanks
C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s1200 -o8 -frandom -b8 -BH -LS I:\Te
stFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads writing for 1200 secs to file I:\TestFile.dat
using 8KB random IOs
enabling multiple I/Os per thread with 8 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 2208.76
MBs/sec: 17.25
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 28
Max_Latency(ms): 820
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 61 7 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30
C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s1200 -o8 -frandom -b8 -BH -LS I:\Te
stFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads reading for 1200 secs from file I:\TestFile.dat
using 8KB random IOs
enabling multiple I/Os per thread with 8 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 6732.05
MBs/sec: 52.59
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 9
Max_Latency(ms): 937
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 1 1 2 5 10 13 13 12 9 7 5 4 3 3 2 2 1 1 1 1 1 0 0 0 3
C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s1200 -o8 -fsequential -b64 -BH -LS
I:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads writing for 1200 secs to file I:\TestFile.dat
using 64KB sequential IOs
enabling multiple I/Os per thread with 8 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 511.87
MBs/sec: 31.99
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 124
Max_Latency(ms): 1580
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 0 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 76
C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s1200 -o8 -fsequential -b64 -BH -LS
I:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 14318180 counts per second
8 threads reading for 1200 secs from file I:\TestFile.dat
using 64KB sequential IOs
enabling multiple I/Os per thread with 8 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 24576 MB for file: I:\TestFile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 1197.95
MBs/sec: 74.87
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 52
Max_Latency(ms): 1070
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 1 3 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 70
- Tags:
- SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2013 03:59 AM
07-24-2013 03:59 AM
Re: HP Lefthand SAN and use for SQL 2012 cluster
Hi
there is not sufficient information provided to answer your query related to performance. However, I have attached a basic Performance guide for understanding of the environment and requirements.
Regards
Ravi