华为云SQL Server RDS慢日志查询脚本

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

#从生成的慢日志文件中提取对应的慢SQL数据，蓝色字体部分根据实际情况替换

select textdata, loginname,duration,starttime,reads,writes,cpu,rowcounts from ::fn_trace_gettable('D:\SQLTrace\audit\SQLTrace.trc', default) where textdata like '%INSERT INTO T_HR_ATS_AttendanceLogEntry (FID, FPersonID, FAttendDate, FExcepMsg, FGroupID) VALUES%' ;

#CPU降序排序TOP 30的慢日志

select top 30 TextData,BinaryData,LoginName,StartTime,Reads,Writes,CPU,DatabaseName,RowCounts,EventSequence from ::fn_trace_gettable('D:\SQLTrace\audit\SQLTrace_9.trc', default) where DatabaseName like 'AIS_SHR%' order by CPU desc