|
|
Sentry-go®
3Ds (UK) Limited
© 2000-2010 |
|
 |
|
|
|
 |
Monitoring Database & SQL Connections |
|
|
|
|
Many critical systems hold their information in local or external databases,
which makes them of paramount importance to the successful operation of many
businesses. Monitoring database & SQL connections, as well as SQL queries is an
ideal way of ensuring these database are delivering data efficiently and without
error.
|
|
|
 |
Today, databases such as SQL Server form the backbone of many systems,
holding literally 100s of 1000s of megabytes of information.
Windows applications typically use ODBC or OLE/DB behind the scenes to access
their data. Ensuring database access is available is therefore
crucial to the successful monitoring of these systems, both for end users as well
as background applications. |
|
|
Although a SQL Server, or other databases may appear to be running fine - i.e. the service is
running, the ultimate way of checking connectivity is to attempt a connection
yourself using the same or a similar method to your clients.
With Sentry-go, monitoring database & SQL connections - connectivity to databases such as SQL Server,
Oracle, access, or any other ODBC defined database automatically is easy.
You can,
for example ...
- Check that connectivity is available on given connections
- Check that tables can be accessed & SQL queries run successfully
- Check that SQL queries return the expected number of rows returned or updated
- Check that SQL queries return the expected data
- Take automatic action if required
- Notify System Administrator(s) of errors or failures
Examples where database & SQL connection & query monitoring would be of benefit include ...
|
|
|
- Any database-driven business application
- Dynamic web sites that rely on back-end data
- Integrated systems such as Mircosoft Biztalk or Sharepoint that utilise a
back-end SQL datastore
|
|
|
|
|