November 11, 2003 at 1:22 pm
Hi
We have a SQL Server 2000 Database there are numerous jobs that are performed on this database. One of the processes creates a large transaction log file. We run transaction log file backups every 30 minutes and a full database backup every 24 hours.
Question:
Could you please let me know if there is a way of fiding out the growth history of the transaction log file?
Thanks
Dinesh
November 11, 2003 at 3:09 pm
I'm sure there's a way, but offhand I can't remember what it is.
this might help a little:http://www.sqlfe.com/default.asp (haven't used it)
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 12, 2003 at 1:22 am
Profiler has a 'Log File Auto Grow' event in the 'Database' class.
For this event, the integer data column tells you by how many pages the log file has been extended, and would therefore give you the growth history.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply