Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: dbcc SQLPERF(Logspace)


Message #1 by "Michael A. A. Schall" <michaelaaschall@s...> on Thu, 12 Dec 2002 23:59:09
I would like to use dbcc SQLPERF(Logspace) to track the growth of my log 
over a period of time.

I need help with the following:

1) How do I store the results either in a table or a file, so I can review 
the results for particular time intervals (e.g. INSERT INTO MYTable dbcc 
SQLPERF(Logspace) -- obviously this will not work, but you get the idea)?

2) Is there anyway to use SQL Profiler to get this information or am I 
required to use a DTS package to get this information?

Thanks!
Michael 

  Return to Index