SQLServer通过DMV实现低影响的自动监控和历史场景追溯 - 数据库编程

update#Temp

setSQLBuffer =#Temp1.eventinfo

from#Temp,#Temp1

where#Temp1.id =@id

and#Temp.spid =@spid

select@spid=min(spid) from#Tempwherespid >@spid

end

insertintodc_block_info(batch_id,spid,status,SQLBuffer,hostname,BlkBy,BlockedSQLBuffer,LoginName,DBName,
CPUTime,DiskIO,LastBatch,program_name,Command)

SELECT@batch_id,convert(char(5),spid) SPID,CASElower(status) When'sleeping'Thenlower(status) Elseupper(status) ENDStatus

,SQLBuffer

, CASEhostname WhenNull Then' .'When' 'Then' .'Elsehostname ENDHostName

,CASEisnul

SQLServer通过DMV实现低影响的自动监控和历史场景追溯 (三)