The most recent content from our members.
I want to list all MSSQL Indexes which are unused from the last system restart and compile them for a cleanup. Could you please suggest if we could query DPA database to get the details.
Description This alert will determine if any SQL had a plan change that resulted in a higher amount of wait time. Plan changes are not necessarily bad, but if the wait times go up, that is a good indication the new plan is not as good as the previous. Alert Definition To create the alert, click on Alerts > Manage Alerts…
Description This procedure will return the top index advice for the number of days back specified. It ranks the list by the amount of wait time saved. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored…
From customer : ..would like the ability to sign in as the table owner since they are not running the sql out of the DBO account. I know we allow this for Oracle explain plans
Introduction This script will create a stored procedure on your SQL Server Ignite Repository and can be used to query against SQL plans stored in the Ignite Repo looking for Clustered Index Scans, Table Scans and any other physical operator you with to search for in the plans. It is a good way to set a date range and see…
DESCRIPTION This custom report will list the Top N SQL statements in your instance for a specified SQL plan hash value. To use this report, run it from SQL*Plus while connected to the Ignite repository database. SQL*PLUS SCRIPT select id, name from cond order by name; prompt Which Database ID accept DBID prompt Enter Start…
Description Provides a list of SQL statements that have experienced an execution plan change within the last hour or whatever the execution interval is defined as. Alert Definition To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return.…
Description This alert will look for a plan change for the top 50 SQL statements (for the last 14 days). If there are plan changes detected, one email will be sent with all SQLs that experienced plan changes. This alert will work for Ignite 8.2 and higher for SQL Server instances. Alert Definition To create the alert,…
It looks like you're new here. Sign in or register to get started.