October 14, 2011 at 8:53 am
Hi, Does anyone know what system tables \ dmv's the standard report "Disk Usage" gets its data from?
Specifically the "Data/Log files Autogrow/AutoShrink Events" section.
The report is accessed via SSMS bu right clicking on the DB.
MCITP SQL 2005, MCSA SQL 2012
October 18, 2011 at 10:16 am
The specific 'Data/Log files Autogrow/AutoShrink Events' seem to be gathered from the default trace.
REF:
and
http://www.mssqltips.com/sqlservertip/1111/default-trace-in-sql-server-2005/
Hope that helps.
October 18, 2011 at 11:35 am
You can usually find the exact query used by using Profiler while running those reports.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply