|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sentry-go®
3Ds (UK) Limited
© 2000-2008 |
|
|
|
|
|
|
The Sentry-go Plus! SQL Server Lock monitor allows you to monitor the locking
status of databases, tables & indexes on SQL Server databases. If locks are held
for excessive time, or processes/queries are blocked, information such as the
calling user, database & SQL can be recorded for further analysis and alerts
raised, informing the database administrator (DBA) of the problem.
Alternatively, blocking or blocked connections can automatically be terminated,
without the need for manual intervention, thus releasing resources and allowing
other SQL & processes to continue.
|
|
Facts & Features |
To implement secure concurrent access, database systems such as SQL Server
implement a complex locking mechanism. Whilst this is extremely efficient at
protecting data and ensuring changes are applied in the correct sequence etc.,
it can mean that one user or process can easily prevent another from continuing
simply because it has locked a resource the other needs.
In well designed, efficient databases, with well written SQL and good
client-side access, locking problems should be kept to a minimum. Inevitably,
some contention problems will occur from time to time but they should be so
quick that the end user wouldn't notice. However, in poorly designed,
overstretched or poorly performing systems, blocking can be an extremely
important factor and so it is important to detect issues early, before the
problem is exacerbated.
|
|
Using the Sentry-go Plus! SQL Server Locking Monitor, you can easily monitor the status of locks
within each installed instance of SQL Server on the local machine. In particular, you can record, respond automatically
to and be notified of SQL queries that are blocked by another process or
statements for more than a specified period of time.
Using this information, you can easily
detect and investigate poor database or index design, or poor performing SQL
statements (either the blocked or the blocking statement)..
When a blocked query is detected, information about both the blocked and
blocking query can be recorded to a log file. In addition, Sentry-go Plus! can take
immediate action to terminate the blocking or blocked connection, notify the DBA
etc.
|
|
|
|
|
|
|
SQL Server Lock Monitoring 
