When was my database last used??? | SansSQL

Friday, October 10, 2008

When was my database last used???


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:

Anonymous said...

I get an error message Incorrect syntax near 'max'.

Sandesh Segu said...

Where are you using this Query???
Is it in SQL 2000 or SQL 2005???

It works in SQL 2005...

Huongkvb said...

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

Anonymous said...

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

Ads