This event has ended

SQLSaturday #258 Pre-Con: Performance Analysis & Tuning Techniques

PASS Turkey Chapter

Friday, 4 October 2013 from 09:00 to 18:00 (EEST)

Istanbul, Turkey

SQLSaturday #258 Pre-Con: Performance Analysis & Tuning...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Pre-Con Attendee (Early Bird) Ended $110.00 $0.00
Pre-Con Attendee (Regular Price) Ended $160.00 $0.00

Share SQLSaturday #258 Pre-Con: Performance Analysis & Tuning Techniques

Event Details

Performance Analysis & Tuning Techniques

Be ready for a full day of diving into SQL Server Performance Analysis. This session is focussed on tools and techniques and how to resolve common problems. We will start on Operating System level using Perfmon and advance into SQL Server Wait Stats analysis for identifying bottlenecks. We will use different tools like SQL Trace&Profiler and the successor: Extended Events for detailed analysis and see what other tools are available from codeplex. We will examine the Plan cache and Indexing using DMVs and finally get into locking & concurrency problems. Expect lots of demos and a deep dive into core concepts of SQL Server.


Andreas Wolter, with over a decade of experience with SQL Server, is a Microsoft Certified Master SQL Server 2008 as well as MCT, MCITP:DD/DA/BID, MCDBA, and MCSA. Being an active member of the PASS he is also a speaker at various international conferences. With his Germany-based company, Sarpedon Quality Lab (www.SarpedonQualityLab.com), he specializes in development and optimization of database and data warehouse systems, with a focus on scalable, performing and secure deployments.


Course Objectives

  • Performance Monitor for Server-Level Performance Analysis
  • Wait-Stats Methology
  • SQL Trace & Profiler to Extended Events for Workload & Query-Analysis
  • Tempdb Performance Optimization
  • Plan-Cache Analysis
  • Index & Statistics, Analysis & Tuning
  • Locking & Blocking Analysis / Concurrency problems


 

 

FAQs


Where can I contact the organiser with any questions?
Please contact yigit.aktan@sqlserveronculeri.com with any enquiries.

What is the language of session?
English

Is my registration/ticket transferrable?
You may substitute a delegate at any time prior to the event starting, by amending the registration details online. Any special requirements, including changes in dietary requirements notified less than 7 days before the event will be accommodated at the venue's discretion.

Do I have to bring my printed ticket to the event?
It will help the Registration process if you would print out your ticket and bring it with you. Thank you for your help in this matter.

Substitutions
You may substitute a delegate at any time prior to the event starting, by amending the registration details online. Any special requirements, including changes in dietary requirements notified less than 7 days before the event will be accommodated at the venue's discretion.

Do you have questions about SQLSaturday #258 Pre-Con: Performance Analysis & Tuning Techniques? Contact PASS Turkey Chapter

When & Where


Microsoft Istanbul
Bellevue Residences, Levent Mahallesi
Aydin Sokak No:7, Levent
Istanbul, Istanbul 34340
Turkey

Friday, 4 October 2013 from 09:00 to 18:00 (EEST)


  Add to my calendar

Organiser

PASS Turkey Chapter

SQL Server Onculeri (www.sqlserveronculeri.com)

yigit.aktan@sqlserveronculeri.com

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.