Skip to content

Instantly share code, notes, and snippets.

@matejskubic

matejskubic/tsql-log-analysis.sql

Last active May 14, 2020 10:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matejskubic/a49d35b2cd69c61417c29b63a9b8ab8d to your computer and use it in GitHub Desktop.
Save matejskubic/a49d35b2cd69c61417c29b63a9b8ab8d to your computer and use it in GitHub Desktop.
Download ZIP
inspect / analyse sql transaction log
Raw
tsql-log-analysis.sql
SELECT
--TOP 100
AllocUnitName,
Operation,
COUNT(*) c,
SUM([Log Record Length]) l
FROM sys.fn_dblog(NULL,NULL)
GROUP BY
AllocUnitName,
Operation
ORDER BY COUNT(*) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment