Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
SQL Query Time Execute Check
WhatsApp
Ashish Srivastava
9y
5
k
0
0
25
Blog
SELECT
qs.total_elapsed_time / qs.execution_count / 1000000.0
AS
average_seconds,
qs.total_elapsed_time / 1000000.0
AS
total_seconds,
qs.execution_count,
SUBSTRING
(qt.text,qs.statement_start_offset/2,
(
CASE
WHEN
qs.statement_end_offset = -1
THEN
LEN(
CONVERT
(NVARCHAR(
MAX
), qt.text)) * 2
ELSE
qs.statement_end_offset
END
- qs.statement_start_offset)/2)
AS
individual_query,
o.
name
AS
object_name,
DB_NAME(qt.dbid)
AS
database_name
FROM
sys.dm_exec_query_stats qs
CROSS
APPLY sys.dm_exec_sql_text(qs.sql_handle)
as
qt
LEFT
OUTER
JOIN
sys.objects o
ON
qt.objectid = o.object_id
WHERE
qt.dbid = DB_ID()
ORDER
BY
average_seconds
DESC
;
Working Preview:
SQL query time
execute check
SQL Server
Up Next
Get Latest Executed Queries In SQL Server
Ebook Download
View all
Basics of SQL Server
Read by 1.6k people
Download Now!
Learn
View all
Membership not found