SQL Sentry Review
The blocking and deadlock report feature is very convenient to use


Primary Use Case

The primary use case of this solution is for troubleshooting performance issues, blocking issues, and deadlock issues.

Improvements to My Organization

This solution has identified: 

  • Blocking
  • Deadlock
  • Memory pressure
  • High CPU consumption issues.

Valuable Features

The blocking and deadlock report feature is very convenient to use in pinpointing which query is causing something and what other queries are waiting for it.

Room for Improvement

If we can get details on wait types from system views, it will help identify a more detailed root cause.

Use of Solution

One to three years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.

Add a Comment

Guest
Why do you like it?

Sign Up with Email