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)
Categories: Database Maintenance | Surveys | Transaction Log
4/3/2009 10:40:31 AM #
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.
mj
4/3/2009 2:25:36 PM #
Wow - that's very scary - I hope you're kidding...
paul
4/3/2009 3:33:43 PM #
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
4/6/2009 1:31:45 PM #
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.
4/10/2009 9:42:30 AM #
Pingback from pythian.com Log Buffer #142: a Carnival of the Vanities for DBAs | Pythian Group Blog
pythian.com
Theme design by Nukeation based on Jelle Druyts
The opinions expressed herein are my own personal opinions and actually do represent my employer's view, as that's me!
© Copyright 2010