• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

SQL Server Performance

In the article, "6 GiB/s (600 MiB/s)  when 6 GiB/s SAS drives are attached"

Does it mean 6 GiB/s link can deliver 600 MiB/s of data ?

Tks
0
AXISHK
Asked:
AXISHK
  • 2
  • 2
1 Solution
 
Gerald ConnollyCommented:
We have been using the 1Gbit/sec = 100MBytes/sec conversion factor for 15 years or so now. NB "B" = Bytes and "b" = bits

So a 6Gb/s link = 600MB/s (nominally)

Now will a 6Gb/s link actually deliver 600MB/s? well thats a difficult one, unlikely, but given enough disks on the bus its possible to get quite close.

You just have to realise that a single disk that has a 6Gb SAS interface will only do 200MB/s sustained speed
0
 
Gerald ConnollyCommented:
Typo in HP documentation SAS is currently 6Gbits/sec, which is 600MB/sec.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now