Server CPU Last der Applikationen ermitteln

Modified on 20/09/2012 17:22 by CPARAS Categorized as SQL

((([image| |http://www.cp-austria.at/website/DesktopModules/Wiki/images/Home.gif|MainPage] » [MainPage|Startseite] » [netFramePlattform|netFrame als Plattform Menü] » [TippsundTricks|Tipps und Tricks] » Server CPU Last | {searchbox} [Search.aspx?FullText=1|Erweiterte Suche])))
{BR}
<code sql>
SELECT      A.Session_ID SPID,
            ISNULL(B.cpu_time, A.cpu_time) CPUTime,
			DB_NAME(B.Database_ID) DBName,
	        D.text SQLStatement,
            ISNULL(B.status,A.status) Status,
            A.login_name Login, A.host_name HostName,
            C.BlkBy,  
            B.command, 
            ISNULL((B.reads + B.writes),(A.reads + A.writes)) DiskIO,
            A.last_request_start_time LastBatch, A.program_name
            FROM    sys.dm_exec_sessions A   
            LEFT JOIN    sys.dm_exec_requests B   
            ON A.session_id = B.session_id  
            LEFT JOIN     
             (SELECT  A.request_session_id SPID,
                          B.blocking_session_id BlkBy          
                          FROM sys.dm_tran_locks as A            
                          INNER JOIN sys.dm_os_waiting_tasks as B           
                          ON A.lock_owner_address = B.resource_address        ) C   
                          ON A.Session_ID = C.SPID   OUTER APPLY sys.dm_exec_sql_text(sql_handle) D
ORDER BY CPUTime DESC
</code>

CP Wiki

Navigation¶

Server CPU Last der Applikationen ermitteln