Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How do you check the session cal usage over the time

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

1 Solution

Accepted Solutions

How do you check the session cal usage over the time


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

7 Replies
Not applicable

How do you check the session cal usage over the time

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

How do you check the session cal usage over the time


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

Not applicable

How do you check the session cal usage over the time

Hi Rob,

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

You're a genius !

Thanks a lot.

Regards,

Sébastien

Not applicable

How do you check the session cal usage over the time

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

-Arun

Not applicable

How do you check the session cal usage over the time

Hi Rob,

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

It's not in the default location.

Thanks

How do you check the session cal usage over the time

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

-Rob

andrespa
Valued Contributor

Re: How do you check the session cal usage over the time

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