March 2009 - Posts

FREE one-day seminar on Optimising SQL Server Performance
08 March 09 01:54 PM | Christian | with no comments

I’m going to be joining Quest Software on 24th March for a seminar on Optimising SQL Server Performance at the Quest offices in Maidenhead, Berkshire.  Attendance is FREE and you’ll get a chance to try out Quest’s product range with hands-on-labs:

BOOK YOUR PLACE HERE: http://www.quest-software.co.uk/ExpertsDay-Performance-032409-Coeo

A Day with the Experts Seminar: Optimising SQL Server Performance

As a database administrator you must be able to proactively diagnose and resolve bottlenecks and scalability issues that threaten productivity. Since production database environments constantly change, DBAs have a lot of to keep track of:

  • Establish benchmarks to understand the load and throughput their database systems can handle
  • Collect metrics and monitor activity around the clock
  • Perform real-time and historical analysis to detect issues and determine proper action plans
  • Maintain operational integrity and end-user satisfaction, while avoiding costly production slowdowns

Join Quest Software for a full-day seminar and lab featuring SQL Server MVP Christian Bolton, and SQL Server expert Iain Kick as they explore many of the challenges around SQL Server performance optimisation. They will offer tips, tricks and methodologies for improving and maintaining performance in your environment.

When -  24th March
Where -  Quest Software, Ascot House, Maidenhead Office Park, Maidenhead, Berks, SL6 3QQ

Time -  09:00- 16:00

Agenda:

  • 08:30- 09:00 Registration & Coffee
  • 09:00- 10:00 Got Performance Headaches? Get Permanent Relief: Detect, Diagnose and Resolve the Pain
  • 10:00- 11:00 What are you Waiting For?
  • 11:00- 12:00 Ensuring the Health of your SQL Server Environment
  • 12:00- 13:00 Complimentary Lunch
  • 13:00- 16:00 Hands on LAB with our technical experts

*Afternoon drinks & refreshments provided.

Got Performance Headaches? Get Permanent Relief: Detect, Diagnose and Resolve the Pain
Presented by Iain Kick, Quest Software

This session will focus on techniques and tools for detecting, diagnosing and resolving performance issues in SQL Server. It can often take years of on-the-job experience as a DBA to learn how to understand when a problem is occurring, diagnose its root-cause, and then resolve it using manual techniques.

Iain will show you:

  • How to use native tools such as PerfMon and SQL Profiler to find issues
  • How to use Graphic Explain Plan, Transact-SQL Showplan, DMVs for SQL Server 2005 and 2008
  • When to use Trace Flags

We will then present a methodology using Quest tools to automate the process of detecting, diagnosing and resolving performance issues in SQL Server.


What are you Waiting For?
Presented by Christian Bolton, Coeo Ltd

Think about what happens when you issue a query to update a row:

  • The optimizer creates an execution plan
  • The query is executed
  • The row will be read from disk into memory
  • The update will be written to the transaction log
  • The row will be changed in memory
  • Confirmation will be sent back to the client

Imagine if you could measure the amount of time that was spent waiting for things within each of these stages. It probably won’t surprise you to hear that you can and not only is monitoring waits possible, but it can actually form a very effective part of a performance tuning strategy. Wait time is effectively dead time, and if you can reduce the amount of time you spend waiting, you’ll be able to achieve better overall performance. This session covers how SQL Server waits work, what types there are, and how to view and track them directly through DMV’s. It also covers common scenarios and their associated wait types.


Ensuring the Health of your SQL Server Environment
How are all your SQL Servers doing?


It seems like the answer should be simple. But in reality, this is one of the most painful questions to which you must respond. Because if you have more than a couple servers, you could easily spend a full day or more gathering information due to the massive number of metrics you need to examine.

Guess what? You don’t have to dig into data to check the system health for all your SQL Servers. During this session we will present a solution for you to gain visibility across your entire environment and check its health at any given time. You can use this methodology in your own environment to ensure ongoing performance of your databases.

Regards,

 

Christian Bolton  - MCA: SQL Server 2005, MCM: SQL Server 2005, MVP
Database Architect
http://coeo.com - SQL Server Consultants & Remote DBA Services