Parent, SQL Exec Stats, Copyright © 2006-2018 Elemental Inc. All rights reserved.
Read Me, Intro, Main, General, Databases, File IO, Tables, Indexes, ExecStats, StoredProcs, DistStats, IxOpStats, Appendix

Data Distribution Statistics Header

Includes date that the column or index statistic was updated.


Dist

Dist

 

Run Time Information

A text file name in the format: Server_Instance_YYYYMMDD_hhmm.txt contains runtime information, including some of the queries sent.

Directory2
For Stored procedures, the plan file name has the stored procedure name as well.

Directory2

 

Excel File

Much of the data collected is saved to an Excel file name format: Server_Instance_YYYYMMDD_hhmm.xls.

 

XML Plan files

I don't remember when this was so. XML plans are saved
XML plan files are not saved by default. Click the “Save XML Plans” button after running the data collection. Plans are saved in a directory starting with server and instance name followed by a date time code.

sql plan
sql plan
sql plan
sql plan

Click the Clear button to start a new sequence

 

Prev        Next