Learn how to find expensive SQL Server queries using Query Store. Identify high CPU, long-running queries, logical reads and resource-intensive SQL statements using practical T-SQL examples.
Learn how to analyze SQL Server Query Store across multiple databases, identify problematic databases, detect query regressions, and simplify performance troubleshooting with a centralized dashboard.
Learn how SQL Server transaction log backups work, how to inspect TRN files, understand log backup chains, restore log backups, and analyze supported transaction log activity with DBLense Log Reader.
Learn how to read SQL Server LDF files, investigate INSERT/UPDATE/DELETE activity, understand fn_dblog limitations, and analyze transaction logs with DBLense Log Reader.
Investigate DELETE operations, narrow the incident window, review auditing options, and use transaction log analysis to identify affected rows and prepare recovery scripts for review.