SQL Server lock monitoring

SQL Server lock monitoring

Windows applications often use SQL Server as their database of choice, a relational database like many others, holding its data in a series of tables, with indexes & keys helping to provide fast, efficient access. To help maintain secure & concurrent access, SQL Server employs 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 one needs. In well designed, efficient database systems, 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 less well designed, overstretched or poorly performing systems blocking can become a crucial factor, in terms of speed & data delivery for all connected users. Locking errors can also cause other secondary errors, such as the transaction log file to grow excessively and even fill up, so it is extremely important to detect issues early, before any problem in this area gets out of hand.  

SQL Server blocking

Sentry-go's SQL Server lock monitoring keeps a check on the database's locking system and reacts or reports when issues between processes arise.

Features

  • Continually monitor the status of the SQL Server locking system 
  • Check for "blocked" locks that last for a configured amount of time
  • Record details of blocked connections & the associated SQL queries for later analysis by the DBA
  • Optionally resolve blocking errors if they arise by terminating the blocking or blocked connection 
  • Help detect & resolve poor database or index design
  • Help resolve poor performing SQL statements
  • Provide real-time database activity & monitoring via the web

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.

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.

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.

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.

 


 

   

  • See Sentry-go for yourself
  • See Sentry-go in action for yourself
     
    The best way to see how Sentry-go can help you is to try it for yourself. Evaluate the full product, free for 21 days!
     
    Software and additional components can also be purchased on-line, through your reseller, or using a Purchase Order. Alternatively if you have any questions, please contact us. We'll be happy discuss them.
     
    More Download free evaluation now!   More  Buy Now

    Add item to backet  Add item to your cart ...

    You are about to add the Sentry-go SQL Server Locking Component v6.x to your shopping cart.
    Cost per licence: £60

    How many licences would you like ?

    Site licence

    Would you like to run unlimited copies at your current site ?
    You can purchase a site licence £845

    Cookies help us provide our on-line purchasing services. By continuing, you agree to our use of cookies. 

     Close window

       More Ask a question