Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-02-08 : 10:47:36
|
| How do I know the how much transaction log has been growth for each date?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 11:12:29
|
| You can set up an alert for SQL Server to send when the Log has a certain amount of activity or hits a certain size/growth. Books Online will detail how to create an alert. You'll need to play with some of the available counters to find the exact one to fit (look under Perfomance conditions, MSSQL$MAIN:Databases). |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-08 : 11:13:00
|
| Just monitor the size of the log files... If you want to find out what percentage of space is currently being used within those logfiles, run DBCC SQLPERF (LOGSPACE) |
|
|
|
vicki
Posting Yak Master
117 Posts |
Posted - 2002-02-08 : 11:45:10
|
| Can you more specific pleaseI open book onlibe then type Perfomance conditions or MSSQL$MAIN:Databases and I can't find anything related to alertThanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-08 : 11:54:41
|
| Actually, Ilya's suggestion is much easier. You can set up DBCC SQLPERF (LOGSPACE) to run as a scheduled job (once a day, once an hour, etc.) and output the results into a table for later review. An alert wouldn't do that for you. |
|
|
|
vicki
Posting Yak Master
117 Posts |
Posted - 2002-02-08 : 13:12:59
|
| How do I set up?thanks |
|
|
|
|
|
|
Transaction Log growth