How do you check the session cal usage over the time

[#1]

Dear all,

We are looking for a way to check the session cals usage over the time from days to minutes.

We already used Qlikview Server performance application but it seems that the number of session cals given by this application is different than the number gave by Qlikview Server administration console.

I don't think it is is important but we are running 8.5 Enterprise version.

Maybe the application is right, but in this case why it is different than the Number of users specified in the Server control panel ?

Thanks in advance for your help and regards,

Sébastien

[#2]

I'm sure, you know, but to remind, is it a data refresh/reload issue ? Server performance app is fetching info mainly from the logs... Do a random chek on the logs also.

-Arun

[rwunderlich · Accepted solution]

spastor wrote:
We already used Qlikview Server performance application but it seems that the number of session cals given by this application is different than the number gave by Qlikview Server administration console.

The concurrent session cal calculation of the QT supplied V8 app is incorrect (in my opinion). It just counts the number of sessions per hour. It does not cross hour boundries or keep track of how many sessions are in use at the same moment. I haven't checked to see if this was improved in V9.

Attached is a QVS log processor load that calculates concurrent session the way I think they should -- to the resolution of a second. That is, if two sessions share the same second in time they are concurrent. The script in the "Concurrent Sessions" script tab.

-Rob

[#4]

Hi Rob,

Thanks for your document, values really seems to be more realistics.

You're a genius !

Thanks a lot.

Regards,

Sébastien

[#5]

Great Rob! You are rally adding valu to the community.

-Arun

[#6]

Hi Rob,

I could reload the file. but, where can i find the QVD?

It's not in the default location.

Thanks

[rwunderlich]

The QVDs should be in the "QVD" directory below the document.

-Rob

[andrespa]

Very useful app. Just one minor comment on it. This evaluates all the concurrent users but it doesn't take in consideration if they're the same user in different machines for example. To solve this you just need to create a unique key:

[Authenticated user]&'-'&[Client machine identification]&'-'&[Client Type] AS Key

And then instead of make the count by [Start Date] make it distinct by key:

count(DISTINCT Key) as StartCount

And now you have a more realistic count of the concurrent users.

Good piece of work though, helped me a lot.

Best regards,

Andrés