SQL Saturday 446–Slow Query, Bring It On


The next two weeks is going to be a whirlwind and it all starts with the SQL Saturday at Portland. There is a plethora of Data Platform subject matter experts who will be descending on the city to mingle with the SQL Family. What’s more a number of them will be surfacing a week later at the SQL PASS Summit as well.

I have always been a big proponent of sharing the knowledge with the community and SQL Saturday is prime way to do that.

The day will get kick started with a keynote session from James Phillips, Microsoft Corporate Vice President of the Business Analytics Product Group. He will present an overview of Microsoft’s Data Platform and Cloud Strategy.

There are multiple tracks which will be running on the same day. It’s going to a be a difficult pick building your schedule but it will also give you a taste of what schedule building for PASS would be like.

  • Admin
  • Architecture
  • Business Intelligence
  • Development
  • Features
  • PowerShell
  • Professional Development
  • Reporting Services
  • Tuning

There are a number of sessions from various known community subject matter experts on various subjects on the tracks listed above. I am really looking forward to this event! This will be an awesome prelude to PASS!

I will be presenting a session on query performance troubleshooting under the Tuning tracks this Saturday which will feature Live Query Statistics and Query Data Store along with a guest appearance from the Query Plan Comparison feature in the latest SQL Server Management Studio.

There is also a SQL Server Clinic at the event. So if you want to chat about questions about SQL Server in your environment or anything data related, then bring them to the experts at the Clinic.

Session name: Slow Query: Bring It On

Duration: 60 minutes

Date: 24th Oct, 2015

Venue Mittleman Community Center

Timing: 10.30am – 11.30am

Session Abstract

Troubleshooting slow performance issues is hindered by lack of available repro or even at times lack of available statistics. This puts the chief troubleshooter in a Catch-22 situation. Without identifying the problem, the issue could resurface again and create another critical business problem. SQL Server 2016 introduces two new features to troubleshoot query performance issues in a reactive and proactive manner namely, Live Query Statistics and Query Data Store. In this session, you will learn about:

1. Using Live Query Statistics to perform live troubleshooting while it is running

2. Using Query Data Store and becoming a SQL superhero by answering questions about query performance with a click of a few buttons

As always, I will update this post with the session deck and any Q&A that comes my way during the event.

The slide deck that I used at the event is available below.

Advertisements

SQL Saturday 76: The WiFi gods were happy


 

I just concluded my presentation on “Debugging the Deadlock for the Scheduler” at SQL Saturday 76 over a Lync meeting. The WiFi and Lync gods decided to be benevolent today and let me present without an untoward incident! As always it was fun to demonstrate the use of a debugger…Winking smileThe attempt of the presentation was to demonstrate what can be done proactively and reactively when dealing with a deadlocked schedulers condition.

A special thank you is due to all the sponsors without whom the event today wouldn’t have been possible: Microsoft New Zealand, RedGate, SQL Pass, New Zealand MS Communities and SQL Services!

The slide deck used for presentation today is available on Slide Share and is embedded below:

The demo files used are available at SkyDrive in the file SQLSat76_Demo.zip The walkthrough for the debugging that I explained along with the use of the Powershell script to automatically collect DMV outputs based on messages in the Windows Application event log are available using the posts available under the walkthroughs link below as well as the zip file mentioned above.

And last but not the least, a big Thank You to Dave [Twitter | Blog] for helping arrange all the logistics so that I could present and also for giving me this opportunity!

Resources:

Whitepaper: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
http://msdn.microsoft.com/en-us/library/cc917684.aspx

Walkthroughs
https://troubleshootingsql.com/tag/deadlocked-schedulers/

WinDBG
http://msdn.microsoft.com/en-us/windows/hardware/gg463009

Microsoft Public Symbol Server
http://msdl.microsoft.com/download/symbols

KB: New concurrency and scheduling diagnostics have been added to SQL Server
http://support.microsoft.com/kb/319892/en-us

Cheers!

SQL Saturday #76: Gearing up for the fun remotely


imageI am quite excited about this Saturday (January 28th, 2012) which will witness SQL Saturday #76 being organized at Auckland. This time around I will not be physically present for the event but will be presenting via Live Meeting on “Debugging the deadlock for the scheduler”. It would have been awesome to be there in person but I shall make the most of the remote opportunity! As they say… If wishes were horses, even beggars would ride! I am going to show you some cool stuff that you can do when you encounter a Deadlocked Schedulers scenario in SQL Server including a demo on debugging a SQL dump!

There are a bunch of other interesting sessions on a whole gamut of topics for you to pick and choose from! Space is limited so if you want to attend and be part of the fun and learning, then get yourself registered here pronto. The list of sessions that for the day are available here.

Venue: Microsoft New Zealand, Level 5, 22 Viaduct Harbour Ave, Auckland CBD
Date: January 28th, 2012
Time: Registration opens at 8.30AM NZ time | Event will conclude around 5PM NZ time

Looking forward to another fun-filled Saturday! Winking smile