Use <DatabaseName>
GO
SELECT DB_NAME() as DatabaseName,
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
4 comments:
I get an error message Incorrect syntax near 'max'.
Where are you using this Query???
Is it in SQL 2000 or SQL 2005???
It works in SQL 2005...
Aivivu chuyên vé máy bay, tham khảo
ve may bay di my gia re
chuyến bay từ mỹ về vn
lịch bay từ canada về việt nam
vé máy bay từ nhật về việt nam bao nhiêu tiền
Chuyến bay từ Hàn Quốc về Việt Nam
Vé máy bay từ Đài Loan về Việt Nam
Chi phí cho chuyên gia nước ngoài
You provide the best informative information related to database in detail. Thank you for sharing interesting post with us. Furthermore, The AC Repair and Maintenance Services Denver provide the outstanding work.
Post a Comment