question

rudrapbiswas avatar image
rudrapbiswas asked

How to get unit of work

Hi, I have a requirement to collect the data from MSSQL, the way we have it in DB2. So, in DB2, there is a catalog, which provides the client_user_id, UOW_Start_time, client_app_name etc. The query is something like this: SELECT client_userid, uow_Start_time, application_handle, client_applname FROM TABLE(MON_GET_UNIT_OF_WORK(NULL,-1)) Can I achieve the same in MSSQL server. The main intention is to capture the client user id which is a unique id generated by the app side and we want to use it splunk to investigate on from which login, specific screen etc for performance analysis.
sql-server-2012performancesql server 2012performance counters
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.