SQL Queries

Yasir150199

hi everyone 

am asking is there any option to monitor most expensive queries in  MSSQLSERVER for more than one hour 

mesverrum

I made this swql query that you could use in a custom query to define any span of time you like 

SELECT
a.Node.Caption as Node
, a.node.DetailsUrl as [_linkfor_Node]
, a.Name as Application
, a.DetailsUrl as [_linkfor_Application]
, db.Name as Database
, db.DetailsUrl as [_linkfor_Database]
, q.QueryText
, q.LastExecutionTime
, q.ExecutionCount
, q.CpuTime
, q.PhysicalReadCount
, q.LogicalReadCount
, q.LogicalWriteCount
, q.AvgDuration
, q.Login
, q.Host
, q.TimeStamp

FROM Orion.APM.SqlQuery q
join orion.apm.SqlDatabase db on db.DatabaseID=q.SqlDatabaseID
join orion.apm.Application a on a.ApplicationID=q.ApplicationID
where q.timestamp > ADDHOUR(-1,GETDATE())