Monitoring SQL Server Locking

from $75 per server
Volume discounts

To implement secure concurrent access, database systems such as SQL Server implement a complex locking mechanism. Monitoring SQL Server locks for blocking can be critical to efficient use of databases. If not checked & resolved quickly, "blocking" as it's known can be very serious & can soon bring any system relying on the underlying data to it's knees.

Features

Monitoring

SQL Server lock monitoring & block monitoring are easy with Sentry-go. Key features & benefits include ...

Monitor the status of the SQL Server locking system
Check for blocked locks lasting for a configured time
Record details of blocked connections & SQL queries
Optionally resolve blocking errors if they arise by terminating the blocking or blocked connection
Determine & investigate poor database or index design
Monitor for help resolve poor performing SQL statements
Web reports provide for real-time database activity & monitoring

Sentry-go allows you to monitor the locking system from any instances on the local SQL Server. Speficially you can check for blocked locks that exceed the time specified.

Monitoring for block SQL
connections & queries

The integrated web server provides a number of additional reports which link directly to the SQL Server in real-time. This includes the status of all SQL Server databases on the machine.

View the status of SQL database

This report shows the current SQL activity. From here you can list all connections/queries and highlight any blocked/blocking queries. You can also terminate them from here.

Monitoring for block SQL
connections & queries

This report shows the SQL Server transaction log for each database, its current % used and details of it's oldest transaction, all from your own desktop web browser.

Monitoring the SQL Server
transaction log

	Watch
	How to configure SQL Server lock monitoring
	More on-line demonstrations & walkthroughs
	Documentation
	Monitoring SQL Server locking
	How to monitor SQL Server locking
	Introducing Sentry-go
	The Sentry-go Getting Started Guide
	Product documentation & how to guides

	More
	Other Sentry-go Plus! monitoring components
	The Sentry-go Quick Monitor range
	Alerting features
	Web reporting features
	Sentry-go Client Tools
	The Sentry-go Enterprise Option
	Getting answers with Sentry-go Solutions

3Ds (UK) Limited,
69, Esher Road,
East Molesey,
Surrey, UK.
KT8 0AQ

Tel. (+44) (0)
20 8144 4141

Fax. (+44) (0)
1932 225349

Sales & Info:
Sales
@Sentry-go.com

Technical Support:
Support
@Sentry-go.com

Our Privacy Policy

Got a question
or need help ?
Just ask!

Download a free trial now!
Get a software quotation.
Buy Sentry-go securely on-line.