The most recent content from our members.
Hello Thwack members, Have anyone tried an automation for disk space removal using SolarWinds..? We have a power shell script which will be executed using an external action. But upon execution, it clears the file space on own SolarWinds polling engine instead of doing it remotely. Have anyone achieved this disk space…
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 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 This custom report will list the Top N SQL statements in your instance by number of disk reads. 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 Date…
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 procedure, when executed, will return all SQL statements for the given date range ordered by average execution time. Some have called this the "Log Running Query" report. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the…
Description This procedure, when executed, will return all SQL statements for the given date range ordered by the Logical I/O per execution. 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 Procedure IF…
It looks like you're new here. Sign in or register to get started.