bjhogan
SSC Eights!
Points: 820
More actions
November 26, 2010 at 9:39 am
#231603
Does anyone have a query that shows how much TLOG space is being used by spid? It looks like all the information may be there through fn_dblog and a few DMVs, but I cannot find anything related to space.
Grant Fritchey
SSC Guru
Points: 397721
November 27, 2010 at 6:47 am
#1255967
There are several queries in this MSDN entry that might help you figure out exactly what you need.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply