Members, I would like to create a TSQL similar to
SELECT SPID, [Last Command], user, [Login Time], [Last Batch]
FROM [SomeHIstoryTable with crazy joins]
ORDER BY [Login Time]
Anyone have a tools box of DM TSQL queries they could share.
On a particular server I highly recommend to look at Adam Machanics sp_whoisactive (http://whoisactive.com/)
If you want to pull the data out of the DM repository, I guess the data is binary encoded in the SessionList field of the ServerActivity table. But I have no idea how to decode that data.
There is a report available but it can't be used external to DM currently and appears not to be decoding all sessions data. We have an item in our maintenance queue to provide a utility to decode the data and insert it into a standard table for reporting purposes.
I was looking for the report, but couldn't find one in 10.4 displaying the session data. Can you please guide me to the report you're mentioning?
Hi, same need here.. did anyone manage to decode sessionlist from serveractivity?
Powered by IDERA