sql_language thread: dbcc SQLPERF(Logspace)
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
|





