I’ll be speaking at Live! 360 Orlando, December 2-7. Surrounded by your fellow industry professionals, Live! 360 provides you with immediately usable training and education that will keep you relevant in the workforce. I will personally speaking on database topics.
On Tuesday, December 4th I will present on the topic of:
SQT10 Parameterization and Performance in SQL Server.
T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues. Have you experienced a query that always ran fast, but suddenly (and for “no reason”) become slow? And with nothing changing? Yep! If this is a new topic to you, you’ll leave this session with takeaways galore.
You will learn:
About how the plan cache deals with queries that are (and are not) parameterized
What parameter sniffing is and how it’s handled in the older and newest versions of SQL
About the problem of mismatched data types and implicit conversions — and how that ties in with ORM-generated code
Value list handling from applications, and how to use a table valued parameter as an input instead.
Then right after this presentation I will be down the hall talking about ways to diagnose application issues:
SQT13 Reading Between the Lines: Using XEvents to Diagnose Application Issues
In this session, three different approaches to using Extended Events will be covered, culminating in a non-traditional approach of using them to determine what’s MISSING — thus the application/network portion of a user experience. We will explain how to use XEvents to do the following:
1. The long running query
2. The thousand paper cuts — de-parameterization and aggregation
3. Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server)
Each approach will detail the following: Creating an extended events session to capture the information you need for each scenario and how to analyze and make sense of the captured data. Lots of demos and take-away scripts!
You will learn:
-How to use XEvents from scripting
-Use XEvents to detect basic performance issues
-Acquire a new and creative technique for diagnosing application issues by using a SQL tool
SPECIAL OFFER: As a speaker, I can extend $500 savings on the 5-day package. Register here: http://bit.ly/OSPK20Reg
All roads lead to Live! 360: the ultimate education destination! Bring the issues that keep you up at night and prepare to leave this event with the answers, guidance and training you need. Register now: http://bit.ly/OSPK20Reg
