|
by tkejser via Microsoft SQL Server Development Customer Advisory Team on 12/14/2009 1:58:36 PM
Author: Thomas Kejser Reviewers: Peter Byrne, Sunil Agarwal, Prem Mehra, Peter Scharlock, Lindsey Allen, Mark Souza As part of your database monitoring, you may be keeping track of the free space in the transaction log. One reason to do this, is to detect a rogue query consuming too much transaction log space. If you have such monitoring set up, you need to be a bit careful about tempdb. Recall that unused space in the transaction log in a FULL and BULK LOGGED recovery mode database is rec
... [ read more ]
|
|
