Wednesday, March 28, 2012

How much space Transaction Log is used ?

We have a Transaction Log of size 10GB and we would like
to know how much size of it is actually used. This is
because we would like to shrink the TL size.
ThanksThere's more than one way to find this out. One technique is to use dbcc
sqlperf(logspace)
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a38801c3eb8c$53b33c70$a001280a@.phx.gbl...
> We have a Transaction Log of size 10GB and we would like
> to know how much size of it is actually used. This is
> because we would like to shrink the TL size.
> Thanks

No comments:

Post a Comment