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

#从生成的慢日志文件中提取对应的慢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