The first step is to understand the nature of performance monitoring software.
The question leads to an even more important question: do your users care?
While NoSQL has taken over many of the duties that the relational database engine used to do, relying only on NoSQL could lead to some issues.
Here's how to spot when new indexes are needed to improve performance.
Here's what you need to know about distributed transaction and when you should use one.
Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features.
Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server.
Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error.
More Tech Library