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
Responding to Extended Events in near real-time Gianluca Sartori
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
The video is not available to view online.
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.
Extended Events - Top Features Andreas Wolter
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the best features and possibilities of this Tracing Framework.
The video is not available to view online.
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.
We have control!-Controlling Resources in SQL Server Chris Testa-O'Neill
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore
The video is not available to view online.
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.
Identifying Performance Problems with SQL 2005 Profiler Martin Bell
How to use Perfmon, Visual Studio Team Edition, SQL Profiler, DTA, Analysing Trace Output and ClearTrace to identify poor performance areas in your system.
The video is not available to view online.
<<1>>