USE [msdb]

GO

/****** Object: StoredProcedure [MS_PerfDashboard].[usp_Main_GetSessionInfo] Script Date: 08/24/2009 13:51:06 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [MS_PerfDashboard].[usp_Main_GetSessionInfo]

as

begin

select count(*) as num_sessions,

sum(convert(bigint, s.total_elapsed_time)) as total_elapsed_time,

sum(convert(bigint, s.cpu_time)) as cpu_time,

sum(convert(bigint, s.total_elapsed_time)) - sum(convert(bigint, s.cpu_time)) as wait_time,

sum(convert(bigint, CAST ( DATEDIFF ( minute, login_time, getdate()) AS BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute,DATEDIFF ( minute, login_time, getdate() ), login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

case when sum(s.logical_reads) > 0 then (sum(s.logical_reads) - isnull(sum(s.reads), 0)) / convert(float, sum(s.logical_reads)) else NULL end as cache_hit_ratio

from sys.dm_exec_sessions s

where s.is_user_process = 0x1

end