mibuso.com

Microsoft Business Solutions online community
It is currently Mon Apr 21, 2014 4:01 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 34 posts ]  Go to page Previous  1, 2, 3
Author Message
 Post subject: Re: SQL 2005 64bit- Nav 5sp1 SLOW
PostPosted: Thu Nov 26, 2009 2:40 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 640
Location: Nürnberg
Country: Germany (de)
Hi!

Well, the problem with RAID5 is writing the "Parity Value". This is additional workload, taking more time.
As RAID10 performs a "pure" striping the writing is much faster. Ther is not much difference in reading data.
See also: http://weblogs.sqlteam.com/billg/archive/2007/06/18/RAID-10-vs.-RAID-5-Performance.aspx

RAID5 is often "sold"/used because it's cheaper: RAID5 requires just 3 HDD, RAID10 needs 4 HDD minimum.

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2005 64bit- Nav 5sp1 SLOW
PostPosted: Wed Mar 24, 2010 10:56 am 
Offline

Joined: Wed Mar 24, 2010 10:53 am
Posts: 2
Country: Finland (fi)
How about performance difference when using SAN disks and like HP EVA is calling them Vraid-5 (virtual raid)?


Top
 Profile E-mail  
 
 Post subject: Re: SQL 2005 64bit- Nav 5sp1 SLOW
PostPosted: Wed Mar 24, 2010 12:04 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 640
Location: Nürnberg
Country: Germany (de)
Stanos wrote:
How about performance difference when using SAN disks and like HP EVA is calling them Vraid-5 (virtual raid)?


Well, with SAN it's different - and have in mind that not everything which pretends to be a SAN really IS a SAN ...

The problem with RAID10 is, that it is quite expensive, as you have to use the half amout of disks just for the mirroring. RAID5 does not mirror the data, but create Parity Sums (to restore the data if one disk is damaged). The writing of the Parity Sums is degrading the performance of write-transactions, thus not really recommended.

Real SAN (!) are using 20 spindles and more. It would cost a fortune if half of them would be just "wasted" for mirroring. Thus, SAN are usually running RAID5 variants (mostly RAID5DP or RAID6 or vRAID5):
The data is striped over e.g. 18 spindles, and 2 disks are used to write the double Parity Sums.
BUT: with real SAN this is NOT degrading performance, as all physical write transactions are perfromed asynchronously! The Fibre Channel headers provide a large piece of cache - NVRAM - usually 2GB and up. The SAN commits the write-transactions as soon as the data is in the cache - the SQL Server is virtually communicating with a sort of RAM disk. THEN the SAN is asynchronously transferring the data from the cache to the spindles (physical write), but writing the parities does not matter here.

So the short story is: with SAN - real SAN! - RAID levels using parity are not degrading perfromance, as a RAM cache is buffereing the data.
This also means, that Independent Power Supply and proper battery buffers are mandatory!

Many "wannabe SAN" just provide multiple spindles, but no or insufficient cache. With those storag systems a RAID5 & Co. will degrade performance of write-transactions.
As far as I know HP EVA is a "real SAN" :wink:

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: SQL 2005 64bit- Nav 5sp1 SLOW
PostPosted: Wed Mar 24, 2010 2:49 pm 
Offline

Joined: Wed Mar 24, 2010 10:53 am
Posts: 2
Country: Finland (fi)
Thanks. I found some similar information from HP forums so this more or less confirms it..


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 34 posts ]  Go to page Previous  1, 2, 3

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: