FrameFlow - Database Monitoring
Monitor Your SQL Server, MySQL, Oracle and ODBC Databases
FrameFlow includes robust database monitoring abilities to help you ensure your SQL Server, MySQL, Oracle and ODBC databases are online and functional.
One of the worst things that can happen to database is to run out of storage space so FrameFlow includes options to watch the size of your databases and alert you based on thresholds that you define. It also builds graphs that help you to spot long term patterns and assist with your storage planning.
Transaction Log Monitoring
For SQL Server databases FrameFlow can also monitor transaction log sizes and alert based on percentage full or absolute size. It's another great way to stay on top of database operations and get notified early about potential problems.
Run Test Queries and Stored Procedures
Our database event monitors even let you run SQL queries or stored procedures and check the results that are returned.
For example, to check the number of rows in a table you can run "select * from tablename" and use the event monitor option to warn if more than X records have been returned.
Or you could look for specific conditions by selecting a text field with a query like "select statusText from tablename where eventtype='critical' order by eventdate desc" and use the event monitor option to look for specified text in the returned rows.
Custom Stored Procedures for Advanced Checks
Many of our customers ask their database admins to write a stored procedure which runs a set of system sanity checks and either returns "Success" or "Error" along with some descriptive text. That way you can set the event monitor to run "proc_systemCheck" or whichever name the stored procedure was given and warn you if the first column in the first row contains "Error". Combine that with option to show the first returned row and you'll also get the status message returned from the stored procedure.
Graphs and Historical Data
Every time one of our database event monitors runs it records the data that it collected and builds graphs. So, for example, you can see the size of each database and watch how it grows over time. You can see the sizes of transaction logs in exactly the same way. And you can see the time that it took to connect to the database and to run the queries that you defined.