Software Directory
Our Network
Top Download Titles
|
|
|
|
SiteScope Database Monitor
|
The SiteScope Database Monitor checks that a database is working correctly by connecting to it and performing a query. Optionally, it can check the results of a database query for expected content.
Each time the Database Monitor runs, it returns a status, the time it takes to perform the query, the number of rows in the query result, and the first two fields in the first row of the result and writes them in the monitoring log file.
If your database application is not working properly, the user may not be able to access Web content and forms that depend on the database. Most importantly, the user will not be able to complete e-commerce transactions that are supported by databases. The other reason to monitor database queries is so you can find performance bottlenecks. If the database interaction time and the associated user URL retrieval times are both increasing at about the same amount, the database is probably the bottleneck. If not, the bottleneck is probably somewhere else in the network.
Usually the most important thing to monitor in databases are the queries used by your most frequently used and most important Web applications. If more than one database is used, you will want to monitor each of the databases.
You may also choose to monitor internal database statistics. The statistics provided by each database are different but may include items such as database free space, transaction log free space, transactions/second, and average transaction duration.
You may want to monitor your most critical and most common queries frequently, every 2-5 minutes. Database statistics that change less frequently can be monitored every 30 or 60 minutes.
|
|
|
|
