S5 Corpway - шаблон joomla Joomla
New Event

 new SQL banner




The SQL Server 2012: Performance Tuning - Design, Internals, & Architecture 4 day course provides an in-depth look into the aspects of SQL Server that affect application performance. Learn about the internals of the SQL Server engine such as the memory manager and task scheduler, table and index structures, locking and concurrency, query optimization and programming efficiency.


Through lecture, demo and hands-on labs students will discover the new performance-related features of SQL Server 2012, understand Dynamic Management Views (DMVs) and Extended Events, optimize queries, examine memory management and process scheduling, troubleshooting locking and blocking, and improve programming efficiency.

Technical Highlights:

After attending this workshop, students will be able to:


  • Analyze performance bottlenecks
  • Design an effective index strategy
  • Diagnose and avoid blocking and deadlocks
  • Analyze execution plans
  • Develop efficient queries and stored procedures


Target Audience

To ensure the high-quality knowledge-transfer expected by attendees of this 4-day workshop, class size is limited to a maximum of 16 students who meet the following criteria:

  • Minimum of 2-3 years’ experience with SQL Server (any version)
  • Job titles such as
    • Database Administrators
    • Database Developers
    • Database Support Engineers
    • Database Architects
    • ISV developers


This workshop runs a FULL 4 days. Students should anticipate consistent start and end times for each day. Early departure on any day is not recommended.

Lesson 1: Architecture This lesson provides an overview of SQL Server engine internals such as memory management, I/O basics, process scheduling and synchronization with particular focus on performance tuning.

Lesson 2: Table & Index Structure This lesson takes an in- depth look into the underlying structure of database files, tables and indexes and how they affect performance. Students will come away with the knowledge they need to design databases and implement efficient indexing strategies.

Lesson 3: Locking & Concurrency This lesson looks into how SQL Server handles concurrency behind-the-scenes. Students will learn the basic concepts of locking, the various isolation levels of SQL Server, how different isolation levels affect concurrency, and the effects of concurrency issues – as well as how to identify and resolve them.

Lesson 4: Query Optimization This lesson provides in-depth information for understanding the end results of query optimization and execution plan creation in SQL Server 2012. Students will learn how to understand query plans and identify queries that are not being executed efficiently. Factors and techniques for increasing query efficiency will also be covered.

Lesson 5: Programming Efficiency This lesson provides an overview of Stored Procedure development, calling ad hoc queries and the proper use of cursors, temporary tables and .NET objects. Students should come away with actionable methods and skills to detect improper cache usage and some corrective actions to lessen those issues.


Hardware Requirements

To participate in the course, students need to have access to a workstation that meets or exceeds the minimum hardware requirements below. If you are attending an open enrollment workshop, the hardware will be provided for you. If you are coordinating a closed delivery (dedicated delivery for your organization) and require hardware or are interested in having the virtual environment hosted in the cloud, then please contact your TAM for more information.

  • Cloud Hosted labs only require internet connectivity
  • Windows 7 or later with Virtual PC
  • Pentium IV 2.4 gigahertz (GHz)
  • 4 gigabytes (GB) of RAM
  • 40-GB hard disk, 7200 RPM
  • 16-megabyte (MB) video adapter (32 MB recommended)
  • Super VGA (SVGA) monitor (17 inch)

Instructor Profile 

Ashar Abbas is a technology enthusiast and an independent database consultant. Along with 15 years of hands on experience he holds a Masters degree of Computer Sciences and a number of database certifications. During his career working as a team lead optimized and tuned hundreds of databases for different multinational companies like Mercedes Benz, Rogers mobile, Nisan, Hyundai, Dawn news Group, Agha Khan University and hospital and much more. Conducted several Workshops on SQL Server for different universities like Mohammad Ali jinnah University, FAST, Indus and many more. Provided corporate training like Get'z Pharma, CDC, AKU, NetSol, Folio3 and much more.


I promise, it really doesn’t matter whether you’re 60 or 16, absolutely ANYONE will love this course and take away life-changing skills that can help you change career or make some extra cash on the side. The only limit? Your imagination.