Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More

Using QVX to get windows performance stats

markodonovan
Valued Contributor

Using QVX to get windows performance stats

This zip file contains a qvx app that can be used to get windows performance stats into your qlikview document.

An example loadscript would be:

CUSTOM CONNECT TO "Provider=QvWindowsPerf.exe;server=COMPUTER_HOSTNAME;XUserId=eJUNXCC;XPassword=AaUOOdB;";

testperf:

LOAD category,

    counter,

    counter_value,

    machine;

SQL SELECT *

FROM WindowsPerfList;

Thanks

Mark

http://practical-qlikview.com

https://twitter.com/PracticalQlik

Attachments
Comments
Not applicable

Could you maybe for the rookies like me, tell how i load this App? Or what do to?

0 Likes
markodonovan
Valued Contributor

Hi thomas,

To start of if you are new to qvx it is worth having a look at the following document:

QVX SDK Instructions

Quick details to use the current executable.

  • Extract the zip file then find the file QvWindowsPerf.exe in the folder GetWindowsPerformanceStats\QvEventLogConnectorSimple\bin\Debug.

  • Copy the file QvWindowsPerf.exe to the following folder:

    C:\Program Files\QlikView

  • In your load script select the QvWindowsPerf.exe option from the Database dropdownlist.

  • Click the CONNECT, then OK for the dialog box.
  • Then click the SELECT button and OK to read in all the fields.
  • Your loadscript should look like something like the following:

CUSTOM CONNECT TO "Provider=QvWindowsPerf.exe;folder_to_process=C:\myfolder;server=computer_hostname;XUserId=IfCXMfA;XPassword=WbXMedC;";

LOAD category,

    counter,

    counter_value,

    machine;

SQL SELECT *

FROM WindowsPerfList;

(Ignore the folder_to_process parameter)

  • You can change the server parameter to look at the performance parameters for different machines.
  • I use Visual Studio Express 2012 for Windows Desktop to develop the qvx app.

Hope this helps.

Thanks

Mark

http://practical-qlik.com

http://practical-sql.com

https://twitter.com/PracticalQlik

0 Likes
Not applicable

when i try to connect to the connector in the database i get an error:

The selected connector has stopped running and has therefore been disabled.

QvWindowsPerf.exe (64) QV EventLog Connector

0 Likes
Not applicable

These error:

Problem signature:

  Problem Event Name: APPCRASH

  Application Name: QvWindowsPerf.exe

  Application Version: 1.0.0.0

  Application Timestamp: 51bb21c9

  Fault Module Name: KERNELBASE.dll

  Fault Module Version: 6.1.7601.18015

  Fault Module Timestamp: 50b8479b

  Exception Code: e0434352

  Exception Offset: 0000000000009e5d

  OS Version: 6.1.7601.2.1.0.274.10

  Locale ID: 1030

  Additional Information 1: 2413

  Additional Information 2: 2413de213f38e5efe700010a55469627

  Additional Information 3: 9938

  Additional Information 4: 993800cba71bf954ab5d21350b198459

Read our privacy statement online:

  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

And this is when i copy the exe file into programfiles\qlikview

0 Likes
markodonovan
Valued Contributor

Hi Thomas,

If might be worth rebuilding the executable on your computer.

Are you using a 32bit version of windows ?

Mark

0 Likes
Not applicable

IVe tried on windows 8.1 enterprise , and i tried on windows server 2008 r2 both 64bit

0 Likes
markodonovan
Valued Contributor

Hi Thomas,

This might have something to do with the dialog box (see screeshot).

I'll see if I can update the file without the custom dialog box.

If you are ok with rebuilding the qvx file yourself you could try removing the following code from the QvGetPerfServer.cs file yourself.

var login = CreateLoginWindowHelper();

            login.ShowDialog();

private Login CreateLoginWindowHelper()

        {

            // Since the owner of the loginWindow is a Win32 process we need to

            // use WindowInteropHelper to make it modal to its owner.

            var login = new Login();

            var wih = new WindowInteropHelper(login);

            wih.Owner = MParentWindow;

            return login;

        }

0 Likes
Not applicable

i dont have tools to edit the sln. Could you prove with new?

0 Likes
markodonovan
Valued Contributor

Hi Thomas,

No problem.

When you run it on your desktop do you get any errors in the following folder:

C:\ProgramData\QlikTech\Custom Data\QvWindowsPerf\Log\

Thanks

Mark

0 Likes
Not applicable

hi I dont have that folder - and nothing happens when i run it at desktop.

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-09-24 10:25 AM
Updated by: