SQL Server 206 - How to find the user id details in Database

Occasional Visitor

Dear All,

 

First of All Wishing Everyone a Happy, Healthy & A Prosperous New Year 2022.

 

This is first  my post in this community.
I have a query regarding MSSQL Database running in windows platform SQL Server 2016 . We are running SAP on top of it. We need to find out the User who is executing large query and its respective utilization.
Though I could check/see the query based on performance report, but I am not able to fetch SAP User details.

Could anyone help / suggest how to obtain the User who is utilizing more CPU/Memory.

Thanks & Regards,

Mithran

0 Replies