SQL Server DDL触发器记录表结构修改
创建 DatabaseLog 表和 DLL 触发器 DDL_DatabaseLog，记录修改表结构操作USE mjkq;
GO
IF EXISTS (SELECT * FROM sys.tables WHERE name = 'DatabaseLog')
BEGIN
DROP TABLE [dbo].[DatabaseLog];
END;
GO
CREATE TABLE [dbo]...
SqlServer 高耗时排查
SELECT TOP 20
total_worker_time/1000 AS [总消耗CPU 时间(ms)],
execution_count [运行次数],
qs.total_worker_time/qs.execution_count/1000 AS [平均消耗CPU 时间(ms)],
last_execution_time AS [最后一次执行时间]...