Home > IT Answers > DataCenter > SQL Server Data Files
Rick Martinez
585 pts.
 SQL Server Data Files
Production Servers, RAID 5, SQL, SQL Server, SQL Server 2008, SQL Server Data Storage
I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

Software/Hardware used:
sql server 2008 enterprise, server 2008 r2
ASKED: May 5, 2011  7:55 PM
UPDATED: May 7, 2011  12:07 AM
RELATED QUESTIONS
Answer Wiki:
Depending on the load that might be ok. As the load increases you'll want to move to a RAID 10 array. If the load of the logs for one database starts getting really high you'll want to move it to it's own RAID 10 array. All writes to the transaction log file are sequential so you'll get better disk performance if each one is on its own array. However if you can't afford that sharing an array is OK as long as the disk array can keep up.
Last Wiki Answer Submitted:  May 6, 2011  7:57 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

do you mean c2 audit log files?

jinteik
 15,485 pts.
 

*.LDF files. (sql server transaction log files)

Rick Martinez
 585 pts.
 

What metrics do I look at to see if I have a high load on sql server? What is considered a high load?

Rick Martinez
 585 pts.