The most recent content from our members.
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
Hi, I have alerts set up on some Oracle databases that are checking for Long Running Transactions, but I'm only seeing time values as being parameters to set. I would like to be able to say, "and owner not equal to <some schema>", etc. The problem is I have Streams set up one of these databases, and of course, I'm…
DESCRIPTION This alert is for Oracle instances only and will tell you when SQL statements have executed more than a defined amount of time. This example uses a 300 second threshold, meaning any SQL statements that have been executing for longer than 300 seconds (5 minutes) will be alerted. The alert query executes against…
This script will allow you to monitor the existence of a specific process on a remote machine, rather than a service. Processes are much more difficult to Monitor than Services. The state of a Service may be determined, even if it is not running (stopped or disabled, for example). In a situation where it is necessary to…
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 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…
Hello I may be being very stupid but how do I get to backup running config on a say HP2510 or a HP2810 I have set this to telnet added the username and password and if i don't put anything in the VTY Promt then i get an error Did not receiv VTY entry promt after CR, so i put an a there When i run it again i get the error…
This script will allow you to monitor the number of Handles/Threads/Processes on a remote machine, without using SNMP and Microsoft 's Performance Monitoring SNMP Extensions. The sample script returns the following: * 1 if the number of handles/threads/processes matches or is below the threshold * 0 if the number of…
It looks like you're new here. Sign in or register to get started.