sqlserver如何查询sql语句占用内存多少
来源:互联网 发布:软件tv版是什么意思 编辑:程序博客网 时间:2024/05/01 14:40
SELECT s2.dbid,
s1.sql_handle,
(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,
( (CASE WHEN statement_end_offset = -1
THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)
ELSE statement_end_offset END) - statement_start_offset) / 2+1)) AS sql_statement,
execution_count,
plan_generation_num,
last_execution_time,
total_worker_time,
last_worker_time,
min_worker_time,
max_worker_time,
total_physical_reads,
last_physical_reads,
min_physical_reads,
max_physical_reads,
total_logical_writes,
last_logical_writes,
min_logical_writes,
max_logical_writes
FROM sys.dm_exec_query_stats AS s1
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2
WHERE s2.objectid is null
ORDER BY s1.sql_handle, s1.statement_start_offset, s1.statement_end_offset;
s1.sql_handle,
(SELECT TOP 1 SUBSTRING(s2.text,statement_start_offset / 2+1 ,
( (CASE WHEN statement_end_offset = -1
THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)
ELSE statement_end_offset END) - statement_start_offset) / 2+1)) AS sql_statement,
execution_count,
plan_generation_num,
last_execution_time,
total_worker_time,
last_worker_time,
min_worker_time,
max_worker_time,
total_physical_reads,
last_physical_reads,
min_physical_reads,
max_physical_reads,
total_logical_writes,
last_logical_writes,
min_logical_writes,
max_logical_writes
FROM sys.dm_exec_query_stats AS s1
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2
WHERE s2.objectid is null
ORDER BY s1.sql_handle, s1.statement_start_offset, s1.statement_end_offset;
0 0
- sqlserver如何查询sql语句占用内存多少
- sql语句占用内存查询
- sqlserver 选出占用cpu的sql语句
- 查询库中有多少表的SQL语句
- linux如何查询进程占用的内存
- oracle,sqlserver分页查询sql语句
- Sqlserver 动态sql查询语句的编写
- sqlserver查询分析器执行sql语句顺序
- sqlserver通用分页sql语句 关联查询
- 查看SQLServer占用内存
- sqlserver 性能查询CPU占用高的sql
- 如何利用SQL查询语句从SQLSERVER数据库中导入导出EXCEL表格
- 如何利用SQL查询语句从SQLSERVER数据库中导入导出EXCEL表格
- 如何利用SQL查询语句从SQLSERVER数据库中导入导出EXCEL表格
- 如何控制sql server 2000占用内存
- 如何修改SQL Server占用内存
- 如何查看 SQL Server 占用内存
- 如何查看 SQL Server 占用内存
- Android利用canvas画各种图形(点、直线、弧、圆、椭圆、文字、矩形、多边形、曲线、圆角矩形)
- 总结_2010暑期集训选拔赛感想
- java按照map的value排序
- Windows C 程序设计入门与提高
- Spring中的AOP——在Advice方法中获取目标方法的参数
- sqlserver如何查询sql语句占用内存多少
- 轻松搞定面试中的链表题目
- PKU OJ 1050 DP(To the max)
- Syntax error near "£"
- SWIFT下的融云,极光,消息推送设置
- 总结_PKU OJ 三天20题
- HDU 1710 树的遍历
- priority_queue用法
- 总结_六天专题:栈和队列,树,并查集,KMP匹配算法