Testing T-SQL Code for Performance - Dejan Sarka

### Testing T-SQL Code for Performance

#### Description

You are writing or installing new T-SQL code. You wonder about the impact of the queries and the data modification commands on your system. How much time is needed to run a query in total, and how much CPU time? How many additional locks you get with a new trigger? How big is the additional number of disk reads and writes if you start using system-versioned (temporal) tables? What is the impact of different levels of compression? Which queries consume the most resources mentioned? Can you find potential slow code by just a quick overview of the code?
In this session, you will learn some methods for finding potentially problematic code, starting with an overview of the code, and then by using dynamic management objects and extended events.