Tag Archives: Whats causing my tempdb to grow – SQL Server 2005

SQL Script to Track which Transact-SQL statements are top consumers of tempdb

Whats causing my tempdb to grow – SQL Server 2005 ? Being a DBA, and when your tempdb size is growing extra ordinary then a DBA has to check, which Transact-SQL statements are top consumers of tempdb. Here is script, which will help you to figure out, which adhoc TSQL statements are consuming tempdb. SELECT [...]