0

SQLServer查询执行过的SQL记录

 1 year ago
source link: https://abcdxyzk.github.io/blog/2023/02/23/sqlserver-log/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

SQLServer查询执行过的SQL记录

2023-02-23 15:05:00

https://blog.csdn.net/zbc415766331/article/details/113924487

说明：仅支持sql server2008及以上版本

通过下面的SQL语句可以查看Sqlserver执行的SQL记录，常用于SQL优化及辅助查找数据更新相关功能bug。

SELECT TOP 1000
	ST.text AS '执行的SQL语句',
	QS.execution_count AS '执行次数',
	QS.total_elapsed_time AS '耗时',
	QS.total_logical_reads AS '逻辑读取次数',
	QS.total_logical_writes AS '逻辑写入次数',
	QS.total_physical_reads AS '物理读取次数',
	QS.creation_time AS '执行时间' ,  
	QS.*
FROM sys.dm_exec_query_stats QS
	CROSS APPLY
sys.dm_exec_sql_text(QS.sql_handle) ST
WHERE  QS.creation_time >'2020-08-18'
ORDER BY
	QS.total_elapsed_time DESC

关键SQL信息查询测试

SELECT TOP 1000
	ST.text AS '执行的SQL语句',
	QS.total_elapsed_time AS '耗时',
	QS.creation_time AS '执行时间' 
FROM sys.dm_exec_query_stats QS
	CROSS APPLY
sys.dm_exec_sql_text(QS.sql_handle) ST
WHERE QS.creation_time >'2021-02-18 15:00' AND QS.creation_time <'2021-02-18 23:00'
ORDER BY
	QS.total_elapsed_time DESC

Posted by kk

2023-02-23 15:05:00tools, sqlserver

« sp_addlinkedserver 远程数据库链接 mysql general_log 记录执行记录 »

wx_ok.pngali_ok.png

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK