sql
weixin_汪汪
有起点无终点
展开
-
查询所有的存储过程
查询所有的存储过程 SELECT name, definition FROM sys.sql_modules AS m INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id WHERE o.[type] = 'P' and name like '%供货商明细查询%'原创 2020-11-12 15:41:30 · 260 阅读 · 0 评论 -
数据库资源耗用查询
数据库资源耗用查询 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 [最后一次执行时间],max_worker_time /1000 AS [最大执行时间(ms)], SUBSTRING(q原创 2020-11-12 15:38:01 · 207 阅读 · 0 评论