Custom Reports Library - SQL Server
Custom reports built to use the Ignite PI Performance Data Warehouse. These reports are developed by Confio DBAs to solve real customer performance problems. Execute the scripts to create stored procedures in the Ignite schema in the repository database. Each script is documented with the required parameters to enter when running the procedure. Also, an example of how to execute the procedure is listed in the comments.
 | SQL statements ranked by disk I/O per second for a specified interval. |  |  | Ignite provides drilldown into the top SQL statements for a program, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the every second data kept in the repository. To check how many days are kept, choose 'Options' > 'Advanced Options' for the 'CLEAN_DAYS_OF_DETAIL' parameter. |  |  | Provides the total number of SQL executions for a specified timeframe if it's available for the monitored database. This number combines all executions of SELECT, UPDATE, DELETE, INSERT and a few others and divides by the number of seconds in the given timeframe |  |  | Top SQL statements ranked by total number of executions. |  |  | Top SQL statements that have executed since the provided date, but not executed before. For example, which SQL statements are new since we applied that patch on June 1st. |  |  | Ignite provides drilldown into the top SQL statements for an O/S User, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the Options > Advanced
Options screen - the 'CLEAN_DAYS_OF_DETAIL' parameter. |  |  | Ignite provides drilldown into the top SQL statements for a database user, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the Options > Advanced Options screen. |  |  | Top SQL statements for a specified date range that executed between a specific timeslice. For example, what are my top SQL statements this week between 8:00 am and 5:00 pm? |  |  | Oracle objects ranked by wait time for a specified wait event. For example, I have high wait times on "db file sequential read" and want to know what objects are being read. |  |  | Provides execution, disk reads, buffer gets, row counts, sort and parse data for a specified SQL statement
|  |  | Gives a list of top SQL statements that contain the specified string. For example, I want to know all the SQL statements that contain the view named "ALL_CUSTOMERS". |  |  | Shows the Top SQL statements waiting on a specified file |  |  | Shows the Top Waits for a specified file. |  |  | Show the top SQL statements across all Instances being monitored. |  |  | Shows the top SQLs ranked by average execution for a given time period. This report will not work for a time period of less than an hour |  |  | Ignite provides drilldown into the top SQL statements for an Oracle historical plan, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the Options > Advanced Options screen. |  |  | Provides the daily average wait for SQL executions in a specified SQL Server or Sybase database, for a specific timeframe. |  |  | Provides the Top SQL statements for a specified SQL Server database. |  |  | Gives a list of top SQL statements that contain the specified string. For example, I want to know all the SQL statements that have "Select TOP" string in them. |  |  | Summarizes all sql statements that contain a specified string. For example, I want to know how many executions and how much time all of the SQL statements which contain 'select TOP' takes. |  |  | Shows the top SQL statements by hour for a specific Sybase or Sql Server database. |  |  | Provides a raw data / tabular view of the Top Programs report provided by Ignite. |  |  | This report lists all sql statements sorted by Database User in a particular Sql Server or Sybase Database for a specific time period. |  |  | Reports all sql statements for a specific session (spid or sid) during a specified time frame. |  |  | This stored procedure will list hourly averages for a specific Resource Metric for a specified date range. Requires Database Instance, Specific Metric and date range values. |  |  | This report will provide a space used report broken down by each monitored database. |  |  | How to add custom report procedures to the Drop-down list on 'Database Query Tool' screen. This will allow you to easily choose and run the custom reports while in Ignite. |  |
|