Session CPU Time issue.

by Jan 11, 2018

Hi,

I gets Session CPU Time alerts on my mail. its shows every thing but it did not show hostname and user name in this report.

Can you please help me what should i do to get hostname and users name in this report? Please find the report format below.

11/01/2018 8:10:32, Session CPU Time (Seconds) on Server Warning.

 

SQL Server instance Mssqlserver- Session 93 which logged in at 11/01/2018 8:05:05 has a cumulative CPU time of 796,384 seconds since login.

 

Last Command: exec [abc]

 

Session CPU Time (Seconds): CPU Time in seconds used by the SQL Server session since the last scheduled refresh.

mydatabase

N/A

N/A