In this week's survey, I'm interested in how *you* manage the size of your transaction log. I'll report on the results around 4/10/2009.
Thanks!
(No comments please… wait till the results post next week)
Paul S. Randal
In Recovery...
Paul S. Randal
In this week's survey, I'm interested in how *you* manage the size of your transaction log. I'll report on the results around 4/10/2009.
Thanks!
(No comments please… wait till the results post next week)
5 Responses to Weekly survey: transaction log size management
In order to maximize performance and disk space, I’ve created a RAM Disk that I place the TX logs on. This improves performance for big maintenance jobs and I can easily free up space by rebooting the server.
Wow – that’s very scary – I hope you’re kidding…
I voted, but I’d like to put in a request for check boxes (multiple options) rather than radio buttons (single option) for this one.
Pam – unfortunately the free survey service I use doesn’t have that option – and I was near the 10 options limit so I couldn’t add in any combos. Thanks for voting though.
[...] week's survey was on how *you* manage the size of your transaction log (see here for the survey). Here are the results as of 4/10/2009 – the most popular survey [...]