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
Click the image to become a SQLskills Insider!
The opinions expressed herein are my own personal opinions and actually do represent my employer's view, as that's me!
© Copyright 2012