The most recent content from our members.
One of the sleeper features of our free Plan Explorer is its ability to open and view SQL Server deadlocks. The view is designed to clearly present all of the details you need to troubleshoot a deadlock, without overwhelming you with less helpful elements like owner IDs and transaction descriptors. The deadlock diagram is…
Last month we released the new, all-free, Plan Explorer 3.0, and now seemed the right time to follow that up with the 3rd version of the demo kit, too. Please consider earlier versions of the demo kit deprecated; I won't remove them, but I will add a note to those pages soon. Now, you might ask, "What is a demo kit?" We…
When @jason.hall mentioned a new version, I will admit, I had some goosebumps. I knew that a new module that we had been working on for many months was finally going to see some daylight. Nothing is more exciting than once again blowing the doors off the native tools and providing you with another feature that helps you…
Occasionally, you may need to connect the SQL Sentry Client to a SQL Sentry database in another domain. If you don't have a SQL authentication login for that server, you will need Windows Authentication, using a remote domain account. But without a trust, you won't be able to use the credentials from your local…
We're thrilled to unveil the latest release of Plan Explorer, packed with new features and enhancements to streamline your SQL Server performance analysis. Plan Explorer is a query optimization tool for SQL Server with index analysis, query performance profiling, playback, plan recosting, and plan diagrams. It’s completely…
In SQL Sentry Plan Explorer 3.0 Demo Kit , I touched briefly on a simple deadlock scenario, where we have two stored procedures that take the same locks, on the same tables, but in the opposite order. This is a classic deadlock scenario: one procedure has taken a lock on A and is waiting on the other procedure before it…
My team at the office gently reminded me that it has been some time since I wrote a technical blog post and, as we all know, muscles that aren't exercised tend to become atrophied. I felt this was a good opportunity to showcase one of my favorite use cases for Plan Explorer! Entity Framework, just like other ORMs, takes…
It looks like you're new here. Sign in or register to get started.