Activity Monitor gets a new life

LQS has its viable use case as we discussed in the Using Live Query Statistics section of this chapter—a previously identified long-running query. But what if we haven't identified an offending query yet? What if we are the database professional who got that middle-of-the-night call asking them to solve an issue with a business-critical ETL process that runs every night, but is unusually slow today?

ETL is an acronym for Extract-Transform-Load which is the name given to a process that extracts data from a data source, enacts transformations in that data such as aggregations or calculations, and loads the results into a destination such as a database. A typical example of an ETL process is a SQL Server Agent ...

Get Learn T-SQL Querying now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.