Every report in SQL Diagnostic Manager contains filters to allow you to select the information that you want included in your reports. If you want to return to the default filters after making some choices, click Reset Filters at the top of the report. Use the Show Filters/Hide Filters toggle depending on your preference.
The following list includes all of the filters available, though each report contains different options.
Check whether you want SQL Diagnostic Manager to ignore query case for the report results.
Select the type of chart you want to convey your report results.
Optional. Select a SQL Server instance and period of time to compare statistics with your main selected Server and Period.
Compare with same server
Check whether you want to compare the same monitored SQL Server instance using a different metric or period.
Database, Database Name
Select or type the name of one or more databases on which you want to report.
Forecast Type, Forecast Units
Select the type of forecast and number of units to use for projecting future growth trends based on your expected growth rate and sample size.
Select the drive within the monitored SQL Server instance on which you want to report.
Select or type the end time of the range from which you want to report trends. SQL Diagnostic Manager includes trends through to the most recent collection time.
Include Batches/SQL Statements/Stored Procedures/System Databases
Check whether you want to include batches, SQL statements, stored procedures, or system databases in your report results.
Select the metric you want to include in your report.
Select or type the minimum duration of the queries to display in your report.
Select or type the minimum number or size of CPU, executions, reads, or writes for the queries you want to display in your report.
Min. Bytes Read/Bytes Written/Data Size/Growth/Transactions
Select or type the minimum number or size of bytes read or written per second, data size, growth, or transactions for the databases you want to display in your report.
Number of Applications
Select or type the number of database applications that you want included in your report.
Number of Databases/Servers
Select or type the number of databases or monitored SQL Server instances you want included in your report.
Number of Queries
Select or type the number of queries that you want returned in the report results.
Select an action type on which you want to report.
Select a repository user by whom you want to filter your report.
Select a workstation on which you want to report.
Select a workstation user account used to access the workstation on which you want to report.
Select the time range on which you want to report. Choose Custom Range to select the sample months, days, hours, or minutes on which you want to report. The sample choices depend on the type of report selected.
Displays the period of time selected for your report.
Select the period of time between data points on the graphs that appear in your report. This selection also represents the most current information as of that particular point.
Search Item and Search Value
Select up to four different items and their values to search for in your server inventory, and then type the value you want to search to find. Use a percent (%) character as a wildcard when specifying a Search Value.
Select the monitored SQL Server instance or instances on which you want to report.
Show Problems Only
Check whether you want to include only problems in your report results.
Check whether you want to group similar queries in your report results.
Start Time, Start Hour
Select or type the start time for the range from which you want to report trends. SQL Diagnostic Manager includes trends through to the most recent collection time.
Select a sample group for the report based on thethat you assigned to those monitored SQL Server instances.