SQL Server GDB Performance Tuning Day 2

Service Description

he following is the Day 2 agenda for this 2-Day course: Day 2: • Use either ArcGIS Pro or ArcGIS ArcMap Projects • Convert ArcGIS Pro Projects to ArcMap Projects • Use Esri MXDPerfstat tool to generate sql • Use SQL Server Trace to collect sql trace files • Run SQL Server trace files through SQL Server Optimizer • Implement SQL Server Optimizer Execution Plan Requirements: • Attendees will be asked to bring their issues to the class • Attendees will need admin access to both their workstation and database servers that will be used • Attendees will host their environment to work through these issues and be responsible for host control • Attendees will need to download and install the tools that will be emailed prior to the beginning of the course