The most recent content from our members.
It could be helpful to have an option to add a "Wait" in the process in Service Requests. Adding a Wait (x amount of seconds or minutes) before next task or process could be helpful in some scenarios.
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…
The "three-legged stool" of performance is made up of memory, CPU, and disk I/O. Combining two of them can hide significant information.
We upgraded our database server this past weekend. It wasn't a shabby box prior to the upgrade. It was an HP DL360 with dual Intel Xeon E5-2660 @ 2.2GHZ for a total of 40 cores and 256GB RAM. We were also running a 4x800TB SSD array. All of this to support an environment with 17 additional polling engines and about 13,000…
Is there a report that displays instance wait time like the 'Instances with highest Wait Time' bar graph on the main page? Preferably with all instances for a longer period of time than what is displayed on the main page?
Description This procedure will return a list of stored procedures for the given date range ordered by wait time. 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 (SELECT COUNT(*) FROM…
DESCRIPTION This alert is very similar to a red wait time bar on the Ignite Home page, i.e. it will warn when the wait time so far today is above it's normal behavior. For example, if it's currently 9am, this alert will determine the normal wait time as of 9am and then compare today's time against that.It will return a…
DESCRIPTION This custom report will list the Top N Objects (tables/indexes) for a specified wait event. This will only work for wait events that have objects associated with them in the P1/P2 values, e.g. db file sequential read, etc. To use this report, run it from SQL*Plus while connected to the Ignite repository…
Description This alert will look for time waiting on any of the SQL Server lock wait type (starts with LCK) in the Ignite repository and return the total time waited. This is executed against the Ignite repository while others listed here execute against the monitored instance. Alert Definition To create the alert, click…
It looks like you're new here. Sign in or register to get started.