Get in touch 01006613113

Microsoft SQL Server 2022 Performance Tuning and Management

About Course

Course Objectives:
After completing this course, participants will be able to:

  • Generate, interpret, and save execution plans.

  • Compare different types of execution plans and understand why query plans are generated.

  • Utilize the Query Store to monitor and analyze query performance.

  • Investigate reports and data within the Query Store for optimization.

  • Identify performance bottlenecks related to memory, disk, blocking, and locking.

Course Outlines:

  • Optimize Query Performance in Azure SQL – Introduction and performance tuning process.

  • SQL Server Performance Killers – Identify common causes of poor performance.

  • Query Plans – Understand, generate, and interpret estimated and actual execution plans.

  • Dynamic Management Views and Functions – Explore system views for performance insights.

  • Query Store – Explore Query Store, identify problematic queries, and use reports.

  • Memory and Disk Performance Analysis – Analyze resource usage for optimization.

  • Blocking and Locking – Describe, identify, and resolve issues with blocking/locking.

  • Exercises and Knowledge Checks – Hands-on practice identifying and resolving performance issues.

 

World Food Programme (WFP)

Our work with the World Food Programme (WFP) focused on enabling the effective adoption of digital field technologies and essential digital literacy capabilities. Participants utilized mobile-based data collection platforms within operational contexts, enhancing accuracy, consistency, and confidence in digital data handling. The engagement strengthened WFP’s ability to rely on digital tools to support field operations and humanitarian programs.

Raya

For Raya, we delivered technology enablement focused on automation-driven operations and scalable application development. Participants gained hands-on experience with automation technologies and modern front-end development frameworks, supporting more efficient processes and the delivery of flexible, high-performance digital solutions aligned with business growth objectives.

EgyptAir

Our engagement with EgyptAir focused on enabling the effective use of application development technologies alongside the adoption of cybersecurity and secure computing practices within operational environments. Participants worked with Microsoft-based development platforms and programming technologies while gaining practical exposure to secure application usage, access control mechanisms, and threat-aware system interaction. This integrated technology enablement supported more secure digital operations, improved system reliability, and reinforced cyber resilience across aviation technology environments.

Banque Misr

We collaborated with Banque Misr to enable integrated enterprise technology capabilities across multiple domains. The engagement supported effective utilization of IT infrastructure environments, data analytics platforms, and professional capability development frameworks, allowing teams to operate confidently within complex enterprise systems. Our delivery approach focused on practical technology adoption, operational alignment, and building sustainable competencies that support reliable banking services and informed, data-driven decision-making.

Course Booking Form