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

MSDE, transaction logs and partitions

Hi

We have an application that runs on Windows 2008 servers. It requires a DB so we'll also have MSDE installed on the same box.

I understand that it's generally better to have transaction logs on RAID 1 and the database on RAID 5.

We could have the transaction logs on the same RAID group as the C drive in that case.

C: OS and transaction logs
D: Application and MSDE database

However, is there any issue with having two write intensive 'applications' (the OS and the transaction logs) on the same partition?

Also, I guess there is a higher risk placing them on the C drive in case the logs fill up the C drive and knock the server over?

What are people's recommendations?
0
Joe_Budden
Asked:
Joe_Budden
  • 5
  • 3
1 Solution
 
HumpdyCommented:
you should never place the T-Logs on the OS Drive, never!!
Ideally you would place your datafiles on one physical volume, and your T-Logs on another separate volume.
Ideally you would separate out again your tempdb to a disignated disk for the data file and one for the log file.
Depending on the amount of CPUs your server has as well, you should create multiple datafiles for your tempdb.
0
 
HumpdyCommented:
also, for write intensive applications you should look at RAID 10 instead of RAID 5
0
 
Joe_BuddenAuthor Commented:
Thanks! Out of interest, what's the reason for never placing transaction logs on the C drive?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
HumpdyCommented:
it's bad practice,
t-logs should be placed on their own spindle, outside of the OS.
Also, for fault tolerance, you want them on a separate disk in the case of a disaster happening.
Performance gains when placed outside of OS drive.
0
 
Joe_BuddenAuthor Commented:
Thanks..

As regards to placing t logs on their own drive, does this include when circular logging is enabled?
0
 
HumpdyCommented:
the actual t-logs is circular logging anyway, but still, should always be placed separately to data fils.
0
 
Joe_BuddenAuthor Commented:
Ah ok.... I thought t logs were only flushed with a full backup ?
0
 
HumpdyCommented:
by ciruclar log, it's not automatic.....
yes, you need to truncate the log essentially for it to wrap around.
Doing a transaction log backup within SQL will do this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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