Organiser

Chris Webb

my blog | hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Wed Jun 03, 2009 in Leeds

SQL Server Performance Troubleshooting Techniques - Sponsored by Quest Software

LiveMeeting Attendee URL This event is not available via LiveMeeting
Cost Free
Organiser UK SQL Server User Group
Address Remarc, Capitol House, Bond Court, Russell Street, Leeds, LS1 5SP
Directions to Event
Tags

Leeds Area SQL Server User Group Meeting, Leeds - Wednesday 3rd June - Sponsored by Quest Software

LiveMeeting URL:
https://www.livemeeting.com/cc/mvp/join?id=B7T73W&role=attend

End-to-End SQL Server Performance Troubleshooting – Iain Kick

When attempting to diagnose a problem in a SQL Server application, there's no right or wrong way to go about troubleshooting. However, certain techniques yield much better results when used for end-to-end troubleshooting.

This presentation will teach you the best practices for finding the root cause of a problem in a SQL Server application, correlating that root cause to a specific set of activities being performed on the server, and tuning the problem activity for maximum performance-all using the native SQL Server tools. We will then compare and contrast those techniques to Quest Software's performance management and query tuning tools. All examples and syntax are verified for Microsoft SQL Server 2005.

Specifically, after attending this presentation, you should have a good understanding of:

  • How to begin a troubleshooting project, including where to start and what to look at inside of SQL Server
  • How to use the query tuning tools and techniques available with the Microsoft tool kit, including the SQL Server Error Log, Windows Performance Monitor (PerfMon), SQL Server DMVs (and system tables in older versions of SQL Server), SQL Profiler, and SQL Server Management Studio's Graphic Explain Plan
  • How to use basic Transact-SQL statements to troubleshoot the performance of a SQL statement or Transact-SQL batch

Please note: although Iain will demonstrate how Quest has solved some of the problems within their products this session will not be a product demonstration.

 

Iain Kick
Iain Kick is SQL Server systems consultant with more than eight years of experience working with complex database environments starting with Microsoft SQL Server version 6.5. He is currently the lead consultant for Quest Software's SQL Server business in the United Kingdom and in this role is responsible for pre- and post sales support and technical guidance including understanding the business drivers of Quest's customers and delivering effective solutions and expertise, technical guidance and implementation support to address customer requirements. Prior to joining Quest in 2005, Iain was a production DBA for Framlington Group and ITouch PLC. He is involved in and supports the SQL Server community as an author and speaker, and has presented at various industry events including SQLBits, regional user groups, to Microsoft TS teams and at Quest product launches and customer events all over Europe. Iain specialises SQL Server performance, tuning and backup/recovery. He graduated from Nottingham Trent University in 1999 with a degree in computer studies.

 

Replaying Trace Files

This session will look at how to create a server side trace, and how it can be useful to regression and stress test your application. I'll look at some tools available to help you plan and analyse your traces and give tips on best practices that should be observed.

 

Martin Bell
Martin Bell has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003.  Martin organises the Leeds and Scottish Area SQL Server User Group meetings and is one of the founding members of the SQLBits organising committee.

Agenda

18:30 - 19:00 – Introduction, Networking and Food

19:00 - 19:50 – End-to-End SQL Server Performance Troubleshooting – Iain Kick

19:50 - 20:00 – Break

 

20:00 – 20:50 – Replaying Trace Files - Martin Bell

 

20:50 – 21:00 – Close

 

Location:
Remarc, Capitol House, Bond Court, Russell Street, Leeds, LS1 5SP http://www.remarc.co.uk/remarcgroup/locations.aspx

Coming Events RSS

Thu, 5 Aug in 7 days
MANCHESTER
Evening Meeting (18 registered)
Introduction to the Service Broker with Anthony Brown and Creating compelling reports with SQL Server 2008 Reporting Services R2 with Chris Testa-O'Neill
Wed, 18 Aug in 20 days
MAIDSTONE
Evening Meeting
Kent User Group - Complex Event Processing (Allan Mitchell), Replication (Neil Hambly)
Wed, 15 Sep in 48 days
LEEDS
Evening Meeting (9 registered)
Using XML data in SQL Server with Anthony Brown, and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
Thu, 16 Sep in 49 days
MANCHESTER
Evening Meeting (7 registered)
User group evening with Tony Rogerson, Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown
Thu, 23 Sep in 56 days
CARDIFF
Evening Meeting (6 registered)
Chris Testa O'Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products **Keep Checking back for further updates**
Thu, 30 Sep in 63 days
YORK
Multi Day Seminar
SQLBits 7: The Seven Wonders of SQL - September 30th to October 2nd
Thu, 7 Oct in 70 days
EDINBURGH
Evening Meeting (4 registered)
SQL Server User Group
Wed, 27 Oct in 90 days
LEEDS
Evening Meeting (3 registered)
User group evening with Allan Mitchell and SQL Server and Virtualisation with Mike Kiersey
Thu, 28 Oct in 91 days
MANCHESTER
Evening Meeting (7 registered)
SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008
Wed, 8 Dec in 132 days
LEEDS
Evening Meeting (3 registered)
User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns
Thu, 9 Dec in 133 days
MANCHESTER
Evening Meeting (6 registered)
User group evening - Agenda to be confirmed
Wed, 19 Jan in 174 days
LEEDS
Evening Meeting (3 registered)
User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O'Neill

Past Events RSS

20 Jul 2010
LEEDS
Evening Meeting
AGI Northern Group meeting: Using geospatial data in the Microsoft world.
14 Jul 2010
LONDON
Evening Meeting (92 registered)
SQL Server and Disk IO (File Groups/Files, SSD's, Fusion-IO, In-RAM DB's, Fragmentation) - Tony Rogerson; Physical Join Operators in SQL Server - Ami Levin; Complex Event Processing - Allan Mitchell
28 Jun 2010
EDINBURGH
Evening Meeting (14 registered)
Replication (Components, Adminstration, Performance and Troubleshooting) - Neil Hambly and SQL Server Upgrades (Notes and Best practice from the field) - Satya Jayanty
24 Jun 2010
CARDIFF
Evening Meeting (16 registered)
Alex Whittles on data warehouse design case studies and an introduction to PowerPivot with Adam Morton
23 Jun 2010
READING
Evening Meeting (31 registered)
Introduction to NoSQL (Not Only SQL) - Gavin Payne; T-SQL Gotcha's and how to avoid them - Ashwani Roy; Introduction to Recency Frequency - Tony Rogerson; Reporting Services - Tim Leung
17 Jun 2010
LONDON
Full Day Seminar
SQL Server Master Class with Kimberly Tripp and Paul Randal
27 May 2010
ONLINE
Online
Q & A Session with the UK SQL Server Product Team
20 May 2010
LONDON
Evening Meeting (30 registered)
Business Intelligence: Implementing common business calcs using DAX in PowerPivot (Chris Webb); Case Study on how to deal with Metrics on high data volumes
19 May 2010
LONDON
Evening Meeting (38 registered)
Service Broker (Intro, Terminology, Design Considerations); Monitoring and Controlling Resources in SQL Server (Resource Governor, Data Collector); BakBone NetVault: FASTRecover provides byte-level continuous data protection
7 May 2010
ONLINE
Webcast (14 registered)
"Cuppa" Corner: Database Design What is and Why is Normalisation important? Domains, Functional Dependencies, Repeating Groups, First Normal Form.
21 Apr 2010
READING
Evening Meeting (40 registered)
Service Broker (Intro + Guidance), Indexing (Selection, Usage, Fragmentation etc...), Normalisation, Surrogate Keys - Locking considerations
15 Apr 2010
LONDON
Evening Meeting (11 registered)
Social for SQL and SQL Server professionals - SQL quiz, meet your peers, ask the group Q & A
6 Apr 2010
MANCHESTER
Evening Meeting (8 registered)
Loading a datawarehouse using SQL Server Integration Services (SSIS) Chris Testa-O'Neill, Database Design: Normalisation/Denormalisation and using Surrogate Keys Tony Rogerson; Group discussion on topics brought by the audience.
30 Mar 2010
MANCHESTER
Evening Meeting (9 registered)
Introduction to Database Maintenance and Development 101.
25 Mar 2010
EDINBURGH
Evening Meeting (12 registered)
SQL Server 2008 Reporting Services Scalability and Performance

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
tonyrogerson Wed 1:32PM
Do most developers talk Oddle Poddle? #sqlfaq
glhotz Tue 9:46AM
RT @tonyrogerson: "Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
tonyrogerson Mon 2:36PM
"Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
gavinpayneuk Mon 8:09AM
Trying #oracle as a #sqlserver user for the first time, why and how in Part 1 of my new blog series http://bit.ly/a8KVbL #sqlfaq
tonyrogerson Mon 5:31AM
Celko advocating 100's of params http://bit.ly/aYvo2K when passing a "set" of values rather than CSV or TVP - he just doesn't get it #sqlfaq
tonyrogerson Fri 9:51AM
26th-28th July - Live Video of KDD-2010 Conference (data mining) Keynotes http://bit.ly/9PIA9C #sqlfaq