Friday, 31 March 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Transaction Log Performance / Profiler to Extended Events | Paul Randal and Erin Stellato
Author: Grant Paisley Date Posted: 11/02/2015 12:13:00 PM
SPECIAL USERGROUP MEETING *** ONE OFF NEW VENUE ***


Paul Randal, our international superstar is back in Sydney so we have nabbed him for a quick session

YOU MUST REGISTER (or email Glyn glyn@angrykoala.com.au to RSVP) because of building security)

|| Wed 25th Feb 2015
||
|| Colonial Theatre
|| Level 20, 201 Sussex Street, Sydney (Darling Park 1)
||
|| 6:00pm for Pizza (outside building)
||
|| 6:30pm - 8:00pm Sessions



Transaction Log Performance - Paul Randal
=========================================
One of the most misunderstood parts of SQL Server is its logging mechanism. The fact that the transaction log exists and can cause problems if not managed correctly seems to confound many DBAs and developers.

Why is it possible for the transaction log to grow unbounded? How can transaction log performance be monitored and improved?

Why does it take so long for operations involving the log?

In this session Paul will discuss the performance issues that can be caused by the transaction log and what you can do to detect and alleviate them.


Making the Leap from Profiler to Extended Events - Erin Stellato
================================================================
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really.

In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.

BTW: Paul is offering Usergroup members a discount if you want to attend his course
http://www.sqlskills.com/sql-server-training/sydney-iepto2-20150223/

Grant

Venue: Colonial Theatre, Level 20, 201 Sussex Street, Sydney (Darling Park 1) | Duration 6:00pm for Pizza (outside building) 6:30pm - 8:00pm Sessions | On: Wednesday, 25 February 2015