Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Assigned To: Brandon Moore
Created By: Brandon Moore
Created Date/Time: 2/23/2022 2:49 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
Priority: 0
 
Time Id: 8780
Template/Type: Brandon Time
Title/Caption: Server meeting
Start Date/Time: 3/22/2022 10:00 am
End Date/Time: 3/22/2022 11:15 am
Main Status: Active

Sorry, no photos available for this element of time.


Uploaded Media/Content & Other Files (1)
Media Name   File Type Date Description
wayne_going_over_combo_db_indexes.mp4   Video 3/28/2022 Small video showing Wayne and Brandon playing with custom and multi column indexes to help optimize database queries. Small work session. 30 minute session.


Notes:

Cory, Wayne, John, Steve, and I on a weekly server meeting. Wayne has been watching slow queries and doing some indexing on some of the database tables. We went over a number of current projects and touch points dealing with servers. We talked about follow-ups on the sales tax aggregate project. Wayne made a change and has been lightly monitoring that project.

Steve had some questions for Wayne and wanted to know which servers may need a spring cleaning. Wayne responded that data 20, data 3, data 4, and data 0 all need some loving and a good database clean-up. As part of that scheduled clean-up process, we really need to make sure and check with our clients and make sure that good communication will be passed on, if scheduled maintenance and downtime will be involved. Both cory and Steve were chiming in tons on the communication stuff. That is awesome!

Wayne and John will continue to keep watching for slow pages and other possible database indexes that could be done. Along those lines, Wayne and I did a small session on how he looks up the queries and then tries making different indexes. I recorded that portion of the meeting. See attached. Good stuff and lots of learning all around the board.