Sessions & Content

Search
Content Type
Conference
Tags
High Scale OLTP - LL From SQLCAT Performance Labs Ewan Fairweather
In this session, I will talk about the lessons we have learned and the methodology we follow when diagnosing and resolving issues with real customer workloads running on 64 and 128 logical cores
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.
Mixing virtualisation with SQL Server - a checklist for success Gavin Payne
Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.
The video is not available to view online.
Monitoring SQL Server Central’s Server Performance Red Gate
Brad McGehee, Red Gate's Director of DBA Education, will share his experience of monitoring SQLServerCentral's DB performance what he found, how he did it using SQL Monitor, and how they were fixed. Following that Brian Harris will demo SQL Monitor.
The video is not available to view online.
Notes from the field: Cross-team Performance Troubleshooting Justin Langford
This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.
Parallel Plans Lubor Kollar
The talk will go back to SQL Server 7.0 when we have introduced “parallel query” in SQL Server for the first time. Lubor will share our initial “parallelism” challenges and how this feature has been developing through the subsequent releases
Performance Tuning Large Analysis Services Cubes Duncan Sutcliffe
Cube tuning is a key part of any BI project and it gets more so as cubes get bigger. Here are a series of tuning procedures to follow for cubes large and small.
Real Time and Historical Performance Troubleshooting SentryOne
In this session Aaron Bertrand and Steve Wright of SQL Sentry, will illustrate how SQL Sentry provides unparalleled insight, awareness and control over the true source of performance issues in SQL Server.
SQL Server 2008 Database Internals Klaus Aschenbrenner
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file.
SQL Server and Solid State Storage - SQL/SSD Jon Reade
Jon Reade examines the performance benefits of SSDs in a SQL Server environment.
SSIS Custom Components Dave Ballantyne
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
SSIS Dataflow Performance tuning Jamie Thomson
Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.
The Dark Arts-a.k.a Performance Tuning, indexing and query plans David Morrison
This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things
The day in the life of the DBA just got a little easier... Idera
Dan Cardno, Idera's Senior Sales Engineer, will focus on the suite of SQL Performance solutions offered by Idera and how they can help anyone tasked with the responsibility of administering SQL server databases.
Tips for handling large data volumes Simon Sabin
Ever tried deleting 100 million records. If you have you will know your transaction log will likely blow up, you will block access and it will generally be painful. In this session we will look techniques I use to help me these situation
The video is not available to view online.
Update Queries-Deep Dive Conor Cunningham
Ever wanted to know exactly what is happening underneath the covers in your queries. Let me show you.
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.
Where did I put my keys? Ami Levin
If you want to see DBAs fight - ask them what is better: using IDs or native keys? This old debate has been troubling database designers since the days of Dr. Codd and Chris Date. Are you ready to hear the "truth"?
The video is not available to view online.
Why are we Waiting.. Neil Hambly
Not to be confused with the Rugby / Football ditties, but actually an in-depth look @ "Waits" Side of the well-known "Waits & Queues" methodology With focus in this session on interpreting the information in the (DMV) sys.dm_os_wait_stats
<<1>>