Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Hi Rob,
Thanks for your document, values really seems to be more realistics.
You're a genius !
Thanks a lot.
Regards,
Sébastien
Great Rob! You are rally adding valu to the community.
-Arun
Hi Rob,
I could reload the file. but, where can i find the QVD?
It's not in the default location.
Thanks
The QVDs should be in the "QVD" directory below the document.
-Rob
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