Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine how full Transaction Log is

Status
Not open for further replies.

SimonTheSponge

Programmer
Feb 12, 2001
74
GB
Hi,

Is there a stored proc, or somewhere in EM that I can find out how much/percentage of a log file (or database file for that matter) is being used

Thanks
 
In EM click on the DB then go to View - Taskpad - this shows the %age of both the data and log file used/free.

[bandito] [blue]DBomrrsm[/blue] [bandito]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
 
Thanks dbomrrsm, I thought I'd seen this view somewhere, but couldn't for the life of me remember where :)
 
Your Welcome :)

[bandito] [blue]DBomrrsm[/blue] [bandito]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top