PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/23/2016 3:53 PM by  Josh B
How to improve SQL Server performance and thus HelpMaster's too.
 3 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Dennis Odri
HelpMaster tech support
Helpdesk leader
Helpdesk leader
Posts:45
Points:81


--
05/20/2014 2:56 PM

    I recently helped one of our many valued clients with an issue where his HelpMaster services were just stopping periodically due to SQL Server timeouts and Exchange mailbox access timeouts. I discovered that they had only allocated 2GB RAM and a single CPU to their HelpMaster server which is a Virtual Machine which also hosts their HelpMaster database under SQL Server 2012 Express.

    It seems that SQL Server 2012 requires a minimum of 4GB of RAM on the host. I also recommended that he enables another virtual CPU as HelpMaster uses multiple threads. We also set the SQL "Minimum server memory (in MB):" to 2048MB or 2GB from the SQL instance properties, on the "Memory" page.

    After doing the above he monitored his services for a week and not one single failure occurred! SUCCESS!!

    As I work from home via a relatively slow VPN/Internet connection, I decided to try increasing our own HelpMaster server's "Minimum server memory (in MB):" to 2048MB from 0MB also. I can now notice a real improvement in responsiveness from our system also, so I thought I would share this little nugget with all of our clients. Hope it helps you too.

    Josh B
    Helpdesker
    Helpdesker
    Posts:15
    Points:21


    --
    11/23/2016 3:03 PM
    One of the things that can really impact perceived performance is any screen that lists jobs or similar entities (Data grid views) in concert with User settings in the Field Chooser.

    The data grid views are everywhere - the job explorer, job history, search results etc.

    In my field chooser for Jobs entities I have: Job #, Date Logged, Priority, Job status, Summary, Client ID, Full name, {a field on the custom tab}, Job Type, Logged By, Assigned to, Actioned By - Last Action, Actioned Date - Last Action, Age clock running Age (Business time) and Closed by. Searching a client's job history takes about 3 seconds to finish rendering.

    If the field chooser is set to only display job number, those data grid views are very responsive <500ms.
    Rod Weir
    HelpMaster development team
    Helpdesk expert
    Helpdesk expert
    Posts:531
    Points:947


    --
    11/23/2016 3:14 PM
    You're right - the Field Chooser plays a big part in the speed of HelpMaster.

    The more fields = the bigger the database query = the bigger the network traffic etc...

    Some fields are more "expensive" than others. In particular, any of the "Business time" calculations, and the "Last actioned by" are fields that require additional database work.

    Customizing the Field Chooser (User menu) is a balance between getting the data you want, and the speed it takes to get it.

    In some cases also, database maintenance, indexing and optimization can also play a big role in speed and performance.
    HelpMaster development team
    Check out the HelpMaster roadmap
    Josh B
    Helpdesker
    Helpdesker
    Posts:15
    Points:21


    --
    11/23/2016 3:53 PM
    Thanks for the tip about business time. Makes total sense.

    Can you elaborate on anything we can do in terms of database maintenance, indexing or optimisations? I'm not a DBA but it would be really handy to have a forum post or something to refer our infrastructure people to.
    You are not authorized to post a reply.


    November 2018 release now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release contains lots of fixes, performance tweaks, improved workflow capabilities, improved ...

    Quick Re-assign from an "Unassigned" skillgroup queue by Rod Weir in Using HelpMaster with 0 replies The upcoming November release of HelpMaster contains a small, but very handy new feature. When a job is assigned to the "Unassigned" queu...

    Job Templates get a new config option for web-based jobs by Rod Weir in Web interface, client self-service and remote access with 1 replies For the up-coming November release of HelpMaster, we've updated the Job Templates so that they can be configured as "Web Forms".  ...

    Maintenance release of HelpMaster, v17.22.5 is now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release delivers some exciting new workflow improvements, along with improved staff web porta...

    New employee on-boarding workflow using new workflow objects by Rod Weir in Using HelpMaster with 0 replies As the workflow capabilities of HelpMaster continue to improve, one of the things that we've been seeing from users of HelpMaster is building proc...

    RE: Job Templates get a new config option for web-based jobs by Rod Weir in Web interface, client self-service and remote access Just further to this topic....if using workflow to log a new job from a job that already contains control sets, and you are using the option to transf...

    November 2018 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release contains lots of fixes, performance tweaks, improved workflow capabilities, improved ...

    Quick Re-assign from an "Unassigned" skillgroup queue by Rod Weir in Using HelpMaster The upcoming November release of HelpMaster contains a small, but very handy new feature. When a job is assigned to the "Unassigned" queu...

    Job Templates get a new config option for web-based jobs by Rod Weir in Web interface, client self-service and remote access For the up-coming November release of HelpMaster, we've updated the Job Templates so that they can be configured as "Web Forms".  ...

    Maintenance release of HelpMaster, v17.22.5 is now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release delivers some exciting new workflow improvements, along with improved staff web porta...

    New employee on-boarding workflow using new workflow objects by Rod Weir in Using HelpMaster As the workflow capabilities of HelpMaster continue to improve, one of the things that we've been seeing from users of HelpMaster is building proc...

    Maintenance release of HelpMaster, v17.20.14 is now available by Rod Weir in Announcements A new release for v17 is now available.   This release fixes a number of issues for version 17 as well as new and enhanced features. &...

    Video settings on 4K monitors and/or high DPI settings by Rod Weir in Bugs!!! We've recently been getting bug reports of not being able to select items from drop-down boxes on the job screen (and others) when using high-res ...

    Faster entity search screens coming by Rod Weir in Using HelpMaster Next release of HelpMaster will feature faster entity search screens (clients, sites, assets, all templates etc).  We've re-factored a lot of...

    RE: Email Manager and Priority Manager services by Rod Weir in Bugs!!! Hi Josh, Thanks for reporting this and for assisting the dev team off-line to diagnose this issue. We've been working on the code and have foun...