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 Click here to join Meeting
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

Wed, 17 Mar in 5 days
LONDON
Evening Meeting (125 registered)
SQL 2008 Data Warehousing Features (Vincent Rainardi); Index Views and Computed Columns (Neil Hambly); Business Intelligence in Office 2010 - Excel,PowerPivot,SharePoint (Duncan Sutcliffe); finishing with a Q & A on BI with the panel
Sat, 27 Mar in 15 days
MANCHESTER
Evening Meeting (3 registered)
Introduction to Business Intellence in the SQL Server Stack - ***Date to be confirmed*** - register your interest
Sat, 27 Mar in 15 days
MANCHESTER
Evening Meeting (5 registered)
Introduction to Database Maintenance and Development 101 - ***Date to be confirmed*** - register your interest
Wed, 21 Apr in 40 days
READING
Evening Meeting (18 registered)
Developer and DBA Focus
Fri, 7 May in 56 days
ONLINE
Webcast (2 registered)
Database Design Part 1 - Why is Normalisation important? What is Normalisation, a look at First Normal Form (1NF) and Boyce Codd (BCNF) Normal Form
Wed, 19 May in 68 days
LONDON
Evening Meeting (17 registered)
Developer and DBA focus
Wed, 23 Jun in 103 days
READING
Evening Meeting (4 registered)
Business Intelligence focus
Wed, 14 Jul in 124 days
LONDON
Evening Meeting (7 registered)
Generic session on SQL Server

Past Events RSS

25 Feb 2010
EDINBURGH
Evening Meeting (19 registered)
** Prize Draw **, An evening of performance troubleshooting with Iain Kick , Learning SQL Server with Alistair Board
25 Feb 2010
CARDIFF
Evening Meeting (16 registered)
**Change to Agenda** BI Fundamentals: Building an Enterprise ETL Framework in SSIS, Data Warehouse Design
20 Jan 2010
DUNDEE
Evening Meeting (7 registered)
Allan Mitchell - Intro to SQL Server Integration Services 2008; Tony Rogerson - Intro to SQL Server tools both flavours - DBA and Developer. Usual Nuggets, Usual SQL LiveLock; Q & A; Advice etc..
17 Dec 2009
MANCHESTER
Evening Meeting (9 registered)
Manchester SQL Server User group - Round the table talks, SQL Nuggets, Informal talk and out for a drink and a chance to win a Copy of Windows 7 and SQL Server 2008
10 Dec 2009
LEEDS
Evening Meeting (9 registered)
An evening of Service Broker and Powershell
26 Nov 2009
EDINBURGH
Evening Meeting (8 registered)
** Cancelled ** SQL Server Nuggets and a look into the Newsgroups
26 Nov 2009
LONDON
Evening Meeting (57 registered)
SQL Server internals and best practice for Absolute Beginners (Tony Rogerson); Nuggest from Dave Ballantyne on Ranking, UDF's; MS Business Intelligence Project Boosters (Siddharth Mehta) - an Introduction to the Power of Policies (Martin Cairney), BakBone product demonstration and the first LiveLock Discussion
18 Nov 2009
LONDON
Evening Meeting
SQL Azure and what is new in SQL Server 2008 R2
11 Nov 2009
READING
Evening Meeting (36 registered)
High Availability (Partitioning, File Groups (use of, backup/restore)) and an Introduction to SQL Server architecture - Tony Rogerson; Virtualising SQL Server (why, design, how, issues, solutions, troubleshooting) - Justin Langford
29 Oct 2009
LONDON
Evening Meeting (42 registered)
Deploying SSRS reports using msbuild (Jamie Thomson); BI 2.0 (Andrew Sadler); Data Warehouse Development Workbench for SQL Server (Steve Hitchman)
28 Oct 2009
DUNDEE
Evening Meeting
SQL Injection Attacks and Tips on How to Prevent Them
15 Oct 2009
MANCHESTER
Evening Meeting (17 registered)
Reporting Services evening. Hosted by Chris Testa-O'Neill
14 Oct 2009
READING
Evening Meeting (33 registered)
Focus: Developer/DBA; Tony Rogerson on TSQL Hints and Tips (CTE Recursion,Case,Partitioning,Sub-Queries,Normalisation/DeNormalisation) and Colin Leversuch-Roberts "How are my servers Today?" - real time monitoring dashboards
8 Oct 2009
CARDIFF
Evening Meeting (18 registered)
South Wales User Group first meeting - Ensuring Business Continuity (Backups, Mirroring and Monitoring) - Tony Rogerson; SQL 2008 Integration Services - some of the things that make it better - Allan Mitchell.
8 Oct 2009
EDINBURGH
Evening Meeting (11 registered)
SQL Server Performance Analysis Tools and Powershell

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
Jennifer Stirrup Wed 6:49PM
Is anyone hiring at the moment? Looking for a London-based BI focused role
tonyrogerson Wed 12:46PM
@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq
tonyrogerson Sun 10:14AM
Time for a brew - am reading on the SQL Server Modelling stuff and "M" - don't see where it fits to be honest #sqlfaq
tonyrogerson Fri 8:13PM
@Plip Should have used DAS and disk replication - commodity simple kit always the best approach (usually) #sqlfaq
tonyrogerson Fri 4:52PM
Ashwani Roy and Chris Testa-O'Neill are doing a 30 minute Q&A panel at the 17th March UG even - cool #sqlfaq
tonyrogerson Fri 3:13PM
Posted a blog http://bit.ly/afepEy that describes what Granularity is #sqlfaq
tonyrogerson Fri 12:24PM
7th May 1pm - 1.45pm http://bit.ly/c4UmAP I'm going to do a webcast on Normalisation - vender neutral #sqlfaq
tonyrogerson Fri 12:02PM
Just helped a friend take her first steps in SQL Server #sqlfaq over LiveMeeting; dam "namespace error" on SSRS on the install though :(
tonyrogerson Fri 10:32AM
Thinking about my Denormalisation/RElational Theory talk for SQLBits #sqlfaq; so much to cover - so little time.
mladenprajdic Fri 10:22AM
@tonyrogerson i don't know how useful the #sqlfaq is but there is #sqlhelp that is used and has quite some traffic.
tonyrogerson Fri 10:17AM
Whats the point using DISTINCT (tuples will b unique-I get that), but still keyless - what have you achieved in "relational" terms? #sqlfaq
tonyrogerson Fri 10:09AM
In CJ Date's book SQL and Relational Theory he talks about having DISTINCT on every query - that would be interesting #sqlfaq #infooverload
tonyrogerson Fri 7:39AM
17th March Business Intelligence event is now full - we've over 100 registered now, there is a reserve list in operation #sqlfaq