Subscribe to:
Post Comments (Atom)
Labels
About Me
Best Practices
Career
Data Mining
Documentation
Feature Requests
Humor
MagicPASS
Meme Monday
Mirroring
Parameter Sniffing
PASS
Performance
PowerShell
Presentations
Query Tuning
Recognition
Replication
Scripts
Security
SQL Power Doc
SQL Server 2005
SQL Server 2008
SQLH2
SQLRally
SQLSaturday
SYDI
T-SQL Tuesday
Tips
Troubleshooting
Updates
VirtualBox
Windows
XML
What I'm Saying On Twitter
Copyright © 2015 Kendal Van Dyke. All rights reserved.
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, & debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS, the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
[About Kendal]
(http://lh3.googleusercontent.com/-wrW1fk8IiFE/Vr36w9dtRxI/AAAAAAAADCw/tVa4vTgLWIw/w139-h140-p/IMG_3503.JPG)
11 comments
Nice review. Thank you.
Excellent, is very interesting. Good job.
Very interesting info - and I assume its also fairly accurate. BUT I don't see the point of the PHYSICAL test that you performed. If the point to compare a single RAID 10 disk to 2 RAID 1 disks, you have to find a way to do just that.
Testing a single RAID 1 disk and doubling the performance (or using a data file that is half the size) doesn't prove anything.
Again - I think you conclusions are correct, but I don't see the point in running the physical test when you are "calculating" your results anyway.
Wow, great benchmarks you got there. I would like to know, if you had 6 disks, setup as 3 RAID1 sets (2 disks each) to divide data, log, and tempdb, would you choose that one over a RAID 10?
To previous anonymous post -
The one factor that would need to be compared is the concurrency of reads/writes. If you're going to have the data/log/tempdb on a single set of synchronized spindles, they will be forced to serialize access to the whole unit.
On the other hand, f you had three logical units in a RAID1 configuration, you will be able to have up to three concurrent accesses.
This does disregard the transfer and access rate differences between a single RAID1 and a RAID10, so it's possible it would come out a wash.
In a worst case, you could have SQL code selecting from tempdb, inserting into a data file, and logging for the inserts flowing into the transaction log. And this could all take place in a single SQL command.
So which would you rather have in this scenario? Concurrent access to 3 RAID1's or a single wide RAID10? I'm betting on the former.
BTW - Great blog Kendal!
-Graham Tapscott
BANDAR JUDI SLOT PALING LENGKAP DENGAN 1 USERID BISA MEMAINKAN SEMUA PERMAINAN
WELCOME BONUS UNTUK PERMAINAN SLOT 50% MAKSIMAL 1.000.000 IDR
DEPOSIT BANK LOCAL :
BCA - MANDIRI - BNI - BRI - DANAMON - JENIUS BTPN DLL
DEPOSIT E-CASH :
OVO - DANA - LINKAJA - GOPAY - SAKUKU - DOKU
DEPOSIT PULSA (DEPOSIT NON RATE/ALIAS TANPA POTONGAN)
-> TELKOMSEL
-> XL / AXIS
Demo SLOT
Slot 888 Dragon
Slot Joker Jewel
Slot Aztec Gem
https://timue87.blogspot.com/
LINK AKSES :
Agen Togel Hongkong
Agen Judi Via Pulsa
Museumbola Livecasino
Link Alternatif museumbola
Agen Judi Slot Terpercaya menyediakan deposit via pulsa tanpa potongan.
Agen Slot Pulsa
Slot Via Pulsa
Agen Judi Slot Deposit Via Pulsa
https://linkslotpulsa .blogspot.com/
Silahkan hubungi WA berikut ini :
WA : +62812-2222-995
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Bandar poker Terpercaya
Dewacintaqq
Daftar Dewacintaqq
Link Dewacintaqq
SITUS TOGEL ONLINE
Situs Togel Hongkong
Situs Togel Singapore
agen poker idn terpercaya
cunpoker
Bandar poker terpercaya
Daftar Dominohalo
Dominohalo
Daftar Dominohalo
Link Dominohalo
http://45.76.123.180/?ref=Nisa93
Bandar poker terpercaya
Daftar Papadomino
papadomino
daftar papadomino
link papadomino
http://45.32.190.103/?ref=vivi293
Bandar poker terpercaya
Daftar Delimapoker
Delimapoker
Daftar Delimapoker
Link Delimapoker
http://45.76.112.124/?ref=nisa2122
Bandar poker terpercaya
Daftar twinpoker88
Twinpoker88
Daftar Twinpoker88
Link Twinpoker88
http://149.28.170.64/?ref=twinpoker21
Poker Indonesia
Poker Online Indonesia
Agen Ceme Online
Daftar Situs Poker
Poker Online Terpercaya
Judi Poker
Poker Online Uang Asli
Poker Uang Asli
Situs Poker Online
Agen Poker
Capsa Susun Online
DewacintaQQ Situs Poker Online Indonesia
Agen Judi Online seperti Poker Online
Situs Judi Online Terpercaya
bandar poker
situs judi
poker online
ceme online
bandar ceme
situs poker
bandar judi
poker idn
judi poker
judi online
agen judi
bandar judi
poker idn
agen poker
idn poker
Situs Judi Poker Online
DominoQQ IDN POKER
bandarqq dan dominoqq terpercaya
Agen judi kartu deposit uang asli pkv games
Agen Poker Online Indonesia Terpercaya
Alasan Kenapa Kamu Harus Bermain Judi Di Museumbola
* Permainan Lengkap dari A sampai Z
* Opsi Deposit Banyak Seperti Bank, E-Cash , PULSA
* Semua Rekening Bank termasuk Bank Daerah Bisa Di Daftarkan
* Bonus Banyak
* Deposit 2 Menit
* Withdraw 5 Menit Paling Lama
* Cs Professional 24 Jam Online
Daftar Museumbola
Link Alternatif Museumbola
Judi Bola Online
Slot pulsa tanpa potongan
Demo Slot Habanero
Alasan Kenapa Kamu Harus Bermain Judi Di Museumbola
* Permainan Lengkap dari A sampai Z
* Opsi Deposit Banyak Seperti Bank, E-Cash , PULSA
* Semua Rekening Bank termasuk Bank Daerah Bisa Di Daftarkan
* Bonus Banyak
* Deposit 2 Menit
* Withdraw 5 Menit Paling Lama
* Cs Professional 24 Jam Online
Daftar Museumbola
Link Alternatif Museumbola
Judi Bola Online
Slot pulsa tanpa potongan
Demo Slot Habanero
Nagaqq Yang Merupakan Agen Bandarq terbaik , Domino 99, Dan Bandar Poker Online Terpercaya di asia hadir untuk anda semua dengan permainan permainan menarik dan bonus menarik untuk anda semua
Bonus yang diberikan NagaQQ :
* Bonus rollingan 0.5%,setiap senin di bagikannya
* Bonus Refferal 10% + 10%,seumur hidup
* Bonus Jackpot, yang dapat anda dapatkan dengan mudah
* Minimal Depo 15.000
* Minimal WD 20.000
* Deposit via Pulsa TELKOMSEL
* 6 JENIS BANK ( BCA , BNI, BRI , MANDIRI , CIMB , DANAMON )
Memegang Gelar atau title sebagai AGEN POKER ONLINE Terbaik di masanya
11 Games Yang di Hadirkan NagaQQ :
* Poker Online
* BandarQ
* Domino99
* Bandar Poker
* Bandar66
* Sakong
* Capsa Susun
* AduQ
* Perang Bacarrat
* Perang Dadu
* BD QQ (New Game)
Info Lebih lanjut Kunjungi :
Website : NAGAQQ
Facebook : NagaQQ official
WHATSAPP : +62 87833350051
Line : Cs_nagaQQ
TELEGRAM :+855967014811
Post a Comment