LabTech Support Forums

Round 1 - Performance Tuning and Scalability

Moderators: edejose.connectwise, chale.connectwise, ahodge.connectwise

Round 1 - Performance Tuning and Scalability

Postby edejose.connectwise » Tue Jul 05, 2016 4:07 pm

Performance Tuning and Scalability
DAY 1 TUESDAY, JUNE 21ROOM: COLLIER/COLUMBIA
Round 1 9:15 AM - 10:30 AM
LEVEL: 101, 201, 301
ROLE: OPS MANAGER
Speaker: Curtis Forsyth, Aldridge

This session will cover lessons learned and strategies used along the way in scaling LabTech and access to the Control Center. Topics will include strategies and configurations to improve performance and stability along with how to identify and reduce unnecessary traffic and database usage. We’ll also be exploring high-level group and script configuration and organization in order to streamline the monitoring and management processes alongside the integration of ConnectWise.

Watch this session here: https://youtu.be/zusBHrNDc0M
Attachments
Round 1 - Performance and Scalability.7z
(558.02 KiB) Downloaded 166 times
edejose.connectwise
Administrator
Administrator
 
Posts: 137
Joined: Mon Jan 24, 2011 1:22 pm

Re: Round 1 - Performance Tuning and Scalability

Postby robb.ccr1 » Mon Jul 18, 2016 10:12 am

Looking for the followup notes that Curtis was going to post after the conference.
Any news on when they will be available
robb.ccr1
Newbie
Newbie
 
Posts: 1
Joined: Tue Dec 09, 2014 8:43 am

Re: Round 1 - Performance Tuning and Scalability

Postby bneste.startech-comp » Wed Jul 20, 2016 1:09 pm

I'd also like to see the slides (as you can't see many of them in the video) as well as the SQL queries he mentions for monitoring DB health...
bneste.startech-comp
Newbie
Newbie
 
Posts: 4
Joined: Wed Nov 11, 2015 7:11 pm

Re: Round 1 - Performance Tuning and Scalability

Postby derek.iannelli-smith.canteytech » Sat Sep 24, 2016 9:16 am

Ditto :))
derek.iannelli-smith.canteytech
Newbie
Newbie
 
Posts: 2
Joined: Tue Jul 05, 2016 8:34 am

Re: Round 1 - Performance Tuning and Scalability

Postby cmatheson.aldridge » Fri Oct 07, 2016 10:27 pm

Hello Everybody,

Chris Matheson from Aldridge here. I have to apologize for the delay as posting these was my responsibility. :oops:

Here are the maintenance scripts we run to help keep our database lean. They are all pretty simple but have helped keep us below a 40GB Database with 8k + agents

https://manage.corporate.aldridge.com/labtech/updates/LTMaintenance.7z

As Curtis mentioned during his presentation we can not take responsibility for coming up with these. Most of these were gathered from suggestions and posts from LT Geek members and the labtech community as a whole.

References:
http://www.labtechgeek.com/forum/viewtopic.php?f=7&t=241&p=16404&hilit=database+cleanup#p16404
http://www.labtechgeek.com/forum/viewtopic.php?f=7&t=672

One Additional Script I included(Pending Script Counts.xml) emails myself every hour to give me the count of all pending and running scripts as well as a csv of everything in the running scripts table. I mostly use this to help me to determine when scripts are scheduled and making sure we aren't overloading the script engine at any give time. Also, works as an indicator of script engine problems if I don't get it or its delayed.

Please let me know if you have any questions.

Thanks,
Christopher Matheson
cmatheson.aldridge
Newbie
Newbie
 
Posts: 3
Joined: Mon Feb 24, 2014 12:44 am


Return to Automation Nation 2016 Sessions

Who is online

Users browsing this forum: No registered users and 1 guest