如何监测谁用了SQL Server的Tempdb空间(四)
usage' , 'U') IS NOT NULL
DROP TABLE tb_task_space_usage
GO
CREATE TABLE tb_task_space_usage
(
id INT IDENTITY(1 , 1)PRIMARY KEY ,
session_id INT ,
internal_object_space_MB DECIMAL(18 , 4) ,
internal_object_dealloc_space_MB DECIMAL(18 , 4) ,
text VARCHAR(MAX) ,
statement_text VARCHAR(MAX) ,
query_plan XML
)