Hi!

I want to ask that can we calculate the memory usage of the clients (or sessions) from Session Stats?

We have a big usage in a customer, and we want to know, which client eating up the resources.

Or is row values are not equivalent with real usage?

If not, how to get information from usage?

Thanks for your help:
  dd

<< I want to ask that can we calculate the memory usage of the clients (or
sessions) from Session Stats? >>

Just use this SQL to get an approximate amount of memory consumption:

SELECT SessionID, SessionName, SUM(CurrentBufferSize) AS MemoryUsage
FROM Configuration.ServerSessionStatistics
GROUP BY SessionID

--
Tim Young
Elevate Software
www.elevatesoft.com