This article explains how to enable, verify, and disable performance monitoring for SQL Server on Azure Virtual Machines (VMs), and how to view and query the data that it collects. Performance ...

SQL Server performance tuning is a complex topic due to how layered it is. While performance problems can often be traced back to data storage issues, the performance tuning process is a "holistic ...

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...

Before changing the SQL Server edition, collect baseline performance data from the current environment. Baseline data is invaluable when comparing performance before and after the edition change. For ...

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

Microsoft's Azure SQL Database is getting an expanded range of performance tiers, upping the Standard tier maximum DTUs to ...

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...