June 4, 2009 at 3:00 pm
HI everyone,
Can you please provide me the information regarding how u r managing the RAID levels at your job?
I mean to ask Where you will save the log files? n y ur saving on that RAID level? What happens when we save on some other RAID level?
data files?
Do you use all the RAID levels in your office ? In what way?
Please provide this information so that i can learn the information related to RAID LEVELS.
thanks in advanced.
Sam.
June 4, 2009 at 4:26 pm
There are lots of best practice papers scattered around the 'net that advocate RAID1 or RAID10 for log files.
One of my favourites is this top 10 storage practices:
You will see here that it doesn't talk about RAID levels until tip 5. Tip 1 and 3 are especially relevant for any discussion like this: you should know how SQL Server works, how your application is going to drive your databases and choose the simplest configuration that meets your requirements.
The RAID1/10 mantra is not necessary in a lot of cases. Your users aren't going to notice a difference of a few milliseconds in the response time of any OLTP application: it's only when you start to get a significant amount of I/O that you start to get writes queueing and so a noticeable degradation for your users.
As with nearly everything to do with IT, the answer is "It depends". There's a large number of factors in any database system/storage design: the most important are usually what type of queries are being thrown at the database, the number of concurrent queries and, perhaps most importantly of all, how well have the queries and the database been optimised for each other.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply