Ad Widget

Collapse

SQL Longest Query Monitoring

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • g.prabhu@live.com
    Junior Member
    • Apr 2014
    • 4

    #1

    SQL Longest Query Monitoring

    Hi,

    I am indeed of monitoring the Longest Query by MSSQL... I have the vbs script for the same, The output has 10 lines and 6 column. When resulting the output to zabbix, it is sending all in a single line and I could not able to analysis the result. Can you please help me...

    I use userparameter as below and attached the script. EDIT the script file in the below line with the appropriate details.

    Server=SERVERIP;User ID=USERNAME;Password=PASSWORD;Database=DATABASENAM E;"

    UserParameter = get.longquerry,%systemroot%\system32\cscript.exe /nologo "C:\zabbix_agents_2.2.1.win\longquerry.vbs"
    Attached Files
    Last edited by [email protected]; 16-04-2014, 08:23. Reason: Attachment Included
  • g.prabhu@live.com
    Junior Member
    • Apr 2014
    • 4

    #2
    Can anyone help ????

    Comment

    Working...