March 16, 2009 at 1:45 pm
I understand the principal database ldf and mdf should be on seperate disks for performance reasons but am not sure if it makes sense to do so on the mirrored database. Would it help with performance? I would appreciate opinions on this.
Thanks
March 16, 2009 at 2:25 pm
Would you want the same level of performance if you had to fail over to the mirror?
How long do you expect to be running on the mirror in a failover situation?
Answer those questions, and I think you will have the answer to your question.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 23, 2009 at 11:54 pm
Another thing to note is if you are running in "High safety mode" then the information gets written to the T-Log on Mirrored, confirmed, then committed on principal. So I would recommend keeping same .. but answering those other questions by Jeff are also a good idea ;-).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply