SQL调优和性能监控工具SQL Monitor.docx
免费下载
SQL
调优和性能监控工具
SQL Monitor
中引入的新的动态性能视图
1
、确认参数
!"#$
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
!"&'
(
!"#$
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
()&*+ &', $&*
这两个参数为前提：
必须设置为
!"&'
或者
'(
设置为
)&* &', $&*
2
、确认要监控的
SQL ID
执行的
会记录在
视图中，加
-.,.-
强制监控
数据量大并行（
-.,/012.-
）执行的
也会记录在视图中
-.,.-304/.25(4633
!'+$ /.2
%%%%%%%%%%%%
7)
8)
8
8
9
':
;8
8<
"=
7
>?
@>0@A5@@A(BC(CB
&)
%%%%%%%%%%%%%
;
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
D9@1(64@E9
-.,.-304/.25(4633
3
、查看
SQL
生成的报告
可 以 通 过
>6@4?@
指 定 多 种 形 式 生 成 报 告
（
;
、
F
、
' &#
、
;
）
DDDDDD
4(GDDDDD
GDDD
GD
H
5>6(H
@?A
>6@4?@/@>IBD9@1(64@E9B0 3IB ; B0
IBB25>4
8
A
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
-.,.-304/.25(4633
*6&5
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
4J)+/8+=2
&&)J
of 5
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论