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 |
|
Duran
Starting Member
9 Posts |
 Posted - 2009-07-07 : 06:41:50
|
| Hello out there,I am trying to work out what kind of growth rate/level the transaction logs reach on a database I recently inherited. I'm sure I read about an SP_ that you can use to see what the recent growth activity was for a particular database so one can set the growth restriction to point where it will allow the logs to grow without giving more than is needed, but I cannot find anything on this anywhere, but I am convinced it exists.Does anyone know of this?Thank you for any help given.Kind regards,D. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-07-07 : 19:07:46
|
| There is: exec master..xp_fixeddrivesIt doesn't give trend analysis, just an instantaneous snapshot of the drives. You can use it over time to see how your drive space is getting allocated. If the log file is on its own disk drive, this is tantamount to monitoring the log file size over time.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-09 : 09:29:51
|
quote:
Originally posted by Duran
Hello out there,I am trying to work out what kind of growth rate/level the transaction logs reach on a database I recently inherited. I'm sure I read about an SP_ that you can use to see what the recent growth activity was for a particular database so one can set the growth restriction to point where it will allow the logs to grow without giving more than is needed, but I cannot find anything on this anywhere, but I am convinced it exists.Does anyone know of this?Thank you for any help given.Kind regards,D.
you can use dbcc sqlperf('logspace') to get the log space detailsu can then have an sp scheduled to give you the growth rate |
|
|
|
|
|
|
Transaction Log Growth History.