Description: SQL performance scripts, including SQL statements executed. Sql SQL currently executing SQL currently executing IO blocking query SQL statement MASTER library execute SQL cache release SQL IO utilization rate 5 statement up to the statement query the longest process of the implementation of the statement
To Search:
File list (Check if you may need any files):
SQL当前执行最多的语句MASTER库执行.sql
SQL的IO阻塞者的查询.sql
SQL缓存释放.sql
SQL中IO使用率最大的前5条语句.sql
查询耗时最长的进程执行的语句.sql
查询进程消耗的CPU时间.sql
查找当前挂起的 IO请求_可判断磁盘问题(人为不间隔查询).sql
检查死锁检查脚本(sp_who_lock)
列出当前产生锁的源头.sql
配置数据库查询最多使用CPU及查询并行度.sql
数据存储空间查询.sql
SQL当前执行的语句.sql
SQL当前执行的最多的语句.sql
Download