Return to Answer

Fixed typographical error

Source Link

edited Oct 1, 2018 at 14:41

18.3k
14
54
115

So you ran diskspd tool with the following parameters:

Discussing Parameters

- b8K   :  8 kB block size                                  (default: 64K)
- d60   : 60 seconds duration                               (default: 10s)
- o32   : 32 outstanding I/O reqeusts per-target per-thread (default: 2  )
- t8    :  8 threads per target
- h     :    disable software and hardware caching          (deprecated: Use -Sh instead)
- r     :    random I/O alignment                           (would require a value)
- w0    :  0 write percentage of reads
- L     :    measure latency statistics
- c200G : 200 GB file size

So even though there are some defaults, you have decided to use different values. Question: Do you get different results when using the default values? I'm asking because SQL Server Read-Ahead varies from 64 kB right up to 1024 kB.

Further questions to Consider

I know what you're going through but your aren't giving us much to go with.

How is the storage attached? (2 GBit / 4 GBit / 8 GBit / 16 GBit)
What kinds of disk are in the SAN? (SSD / HDD / Hybrid / ...)
.... and possible other questions.

Yes, you stated you have no interaction with the server team, but any information you provide is a step in the right direction. Otherwise, it's just a best guess.

Answering Your Question(s).

So my question is, for a SAN in a not so small IT shop, is that a good number?

Possibly, but then again possibly not, that depends on your requirements and how your storage is configured. On an old IBM storage, we were constantly seeing ononly 210 MB/s throughput over a SVC with dual 2 GBit/s SFPs attached to the server hardware. We should have being seeing figures around 420 MB/s. After reconfiguring the switch ports we were nearer the second number, than the previous 210 MB/s.

Should we be aiming for more?

That depends on your requirements, your hardware and your configuration. Too may unknowns to give a definite answer.

What is an average IOPS figure for an entry level and high end SAN's

Anywhere between 2'000 (entry level) and 25'000 (high-end; in 2015). IOPS don't seem to be the number to look at any longer according to some articles.

^{Reference: Do IOPS Matter? – Simple Answer, No ()}

So you ran diskspd tool with the following parameters:

Discussing Parameters

- b8K   :  8 kB block size                                  (default: 64K)
- d60   : 60 seconds duration                               (default: 10s)
- o32   : 32 outstanding I/O reqeusts per-target per-thread (default: 2  )
- t8    :  8 threads per target
- h     :    disable software and hardware caching          (deprecated: Use -Sh instead)
- r     :    random I/O alignment                           (would require a value)
- w0    :  0 write percentage of reads
- L     :    measure latency statistics
- c200G : 200 GB file size

Further questions to Consider

I know what you're going through but your aren't giving us much to go with.

How is the storage attached? (2 GBit / 4 GBit / 8 GBit / 16 GBit)
What kinds of disk are in the SAN? (SSD / HDD / Hybrid / ...)
.... and possible other questions.

Yes, you stated you have no interaction with the server team, but any information you provide is a step in the right direction. Otherwise, it's just a best guess.

Answering Your Question(s).

So my question is, for a SAN in a not so small IT shop, is that a good number?

Possibly, but then again possibly not, that depends on your requirements and how your storage is configured. On an old IBM storage, we were constantly seeing on 210 MB/s throughput over a SVC with dual 2 GBit/s SFPs attached to the server hardware. We should have being seeing figures around 420 MB/s. After reconfiguring the switch ports we were nearer the second number, than the previous 210 MB/s.

Should we be aiming for more?

That depends on your requirements, your hardware and your configuration. Too may unknowns to give a definite answer.

What is an average IOPS figure for an entry level and high end SAN's

Anywhere between 2'000 (entry level) and 25'000 (high-end; in 2015). IOPS don't seem to be the number to look at any longer according to some articles.

^{Reference: Do IOPS Matter? – Simple Answer, No ()}

So you ran diskspd tool with the following parameters:

Discussing Parameters

- b8K   :  8 kB block size                                  (default: 64K)
- d60   : 60 seconds duration                               (default: 10s)
- o32   : 32 outstanding I/O reqeusts per-target per-thread (default: 2  )
- t8    :  8 threads per target
- h     :    disable software and hardware caching          (deprecated: Use -Sh instead)
- r     :    random I/O alignment                           (would require a value)
- w0    :  0 write percentage of reads
- L     :    measure latency statistics
- c200G : 200 GB file size

Further questions to Consider

I know what you're going through but your aren't giving us much to go with.

How is the storage attached? (2 GBit / 4 GBit / 8 GBit / 16 GBit)
What kinds of disk are in the SAN? (SSD / HDD / Hybrid / ...)
.... and possible other questions.

Yes, you stated you have no interaction with the server team, but any information you provide is a step in the right direction. Otherwise, it's just a best guess.

Answering Your Question(s).

So my question is, for a SAN in a not so small IT shop, is that a good number?

Possibly, but then again possibly not, that depends on your requirements and how your storage is configured. On an old IBM storage, we were constantly seeing only 210 MB/s throughput over a SVC with dual 2 GBit/s SFPs attached to the server hardware. We should have being seeing figures around 420 MB/s. After reconfiguring the switch ports we were nearer the second number, than the previous 210 MB/s.

Should we be aiming for more?

That depends on your requirements, your hardware and your configuration. Too may unknowns to give a definite answer.

What is an average IOPS figure for an entry level and high end SAN's

Anywhere between 2'000 (entry level) and 25'000 (high-end; in 2015). IOPS don't seem to be the number to look at any longer according to some articles.

^{Reference: Do IOPS Matter? – Simple Answer, No ()}

Source Link

created Oct 1, 2018 at 14:03

John K. N.

18.3k
14
54
115

So you ran diskspd tool with the following parameters:

Discussing Parameters

- b8K   :  8 kB block size                                  (default: 64K)
- d60   : 60 seconds duration                               (default: 10s)
- o32   : 32 outstanding I/O reqeusts per-target per-thread (default: 2  )
- t8    :  8 threads per target
- h     :    disable software and hardware caching          (deprecated: Use -Sh instead)
- r     :    random I/O alignment                           (would require a value)
- w0    :  0 write percentage of reads
- L     :    measure latency statistics
- c200G : 200 GB file size

Further questions to Consider

I know what you're going through but your aren't giving us much to go with.

How is the storage attached? (2 GBit / 4 GBit / 8 GBit / 16 GBit)
What kinds of disk are in the SAN? (SSD / HDD / Hybrid / ...)
.... and possible other questions.

Yes, you stated you have no interaction with the server team, but any information you provide is a step in the right direction. Otherwise, it's just a best guess.

Answering Your Question(s).

So my question is, for a SAN in a not so small IT shop, is that a good number?

Should we be aiming for more?

That depends on your requirements, your hardware and your configuration. Too may unknowns to give a definite answer.

What is an average IOPS figure for an entry level and high end SAN's

Anywhere between 2'000 (entry level) and 25'000 (high-end; in 2015). IOPS don't seem to be the number to look at any longer according to some articles.

^{Reference: Do IOPS Matter? – Simple Answer, No ()}