Sessions & Content

Search
Content Type
Conference
Tags
Kicking & Screaming: Replacing Profiler with Extended Events Erin Stellato
Extended Events was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Simplifying XEvents Management with dbatools Chrissy LeMaire
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Easy Performance Tuning: an Intro to Wait Statistics Brent Ozar
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
From SQL Traces to Extended Events. The next big switch Mladen Prajdic
This session will give you insight into both of the current tracing technologies in SQL Server. Old SQL Trace has served us well but new times call for new technology. The new Extended Events are a new lightweight tracing mechanism built into SQLOS.
Extended Events and the new Profiler in SQL Server 2012 Bob Beauchemin
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
Working with Server Side Traces Christina E. Leo
Learn to create and customise TSQL scripts for capturing SQL Profiler data in a server side trace. Examine methods for stopping, starting and storing these traces, and finally look at free tools available for analysing the captured data.
How DBAs can use PowerPivot for Performance Tuning / Troubleshooting Andre Kamman
PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
LINQ for DBAs and SQL Developers Atul Thakor
An introduction to LINQ covering what it is, why people choose to use it, and how you can help your developers when troubleshooting and performance tuning as you previously did through stored procedures.
Using Perfmon and Profiler Brent Ozar
Got a slow application or server, and not sure where to start? Brent will explain how to use the two most popular free tools and how to read their results.
Performance Tuning your TSQL Simon Sabin
A indepth insight into performance tuning database applications.
<<1>>