Last executed queries for a specific database

by

This works for me to find queries on any database in the instance. I’m sysadmin on the instance (check your privileges):

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.dbid = DB_ID('msdb')
ORDER BY deqs.last_execution_time DESC

This is the same answer that Aaron Bertrand provided but it wasn’t placed in an answer.

More Related Contents:

  1. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  2. LocalDB deployment on client PC
  3. How to check if a column exists in a SQL Server table
  4. Auto increment primary key in SQL Server Management Studio 2012
  5. XML Server XML performance optimization
  6. Adding a query hint when calling Table-Valued Function
  7. How to enable bulk permission in SQL Server
  8. Sequence as default value for a column
  9. Why the SQL Server ignore the empty space at the end automatically?
  10. Avg of float inconsistency
  11. Dynamically assign filename to excel connection string
  12. SQL Server Configuration Manager cannot be found
  13. Joining multiple tables returns NULL value
  14. Is it possible to use user defined aggregates (clr) with window functions (over)?
  15. How to pivot unknown number of columns & no aggregate in SQL Server?
  16. “No backupset selected to be restored” SQL Server 2012
  17. Restore a SQL Server 2000 backup on SQL Server 2012
  18. Floor a date in SQL server
  19. SSRS 2014 report deploy issue
  20. Set start value for column with autoincrement
  21. SqlDataAdapter.Fill method slow
  22. syntax for single row MERGE / upsert in SQL Server
  23. What happens to the primary key Id when it goes over the limit?
  24. Making an Entity Framework Model span multiple databases
  25. SQL Server 2008 Row Insert and Update timestamps
  26. “Prevent saving changes that require the table to be re-created” negative effects
  27. How to change column datatype in SQL Server database without losing data?
  28. Convert UTC Milliseconds to DATETIME in SQL server
  29. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  30. Tool for Scripting Table Data

Leave a Comment