News

Getting The Most out of SQL Server Profiler

(released 22/09/2009)

The October meeting of the Newcastle Coders Group is just over two weeks away. This month I’m very pleased to announce that our presenter will be Brad McGehee from Red Gate software who will show you how to get the most out of SQL Server Profiler.

Brad is based in Hawaii and is stopping off in Newcastle to give one of only a few presentations he will make around Australia. Please RSVP if you plan to attend as we will need to ensure the venue can cope with the numbers. 

When: 6.00pm Wednesday 7th October 2009
Where: Forsythes IT and Training Rooms - 9 Denison Street, Newcastle West
Cost: FREE!

Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors’ degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 14 years’ SQL Server experience, over 6 years’ training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 14 years’ cumulative knowledge. Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics.

How to Get the Most Out of the SQL Server 2005/2008 Profiler

While many Database Developers may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important tool. In this session, you will learn many advanced techniques you can use to troubleshoot both SQL Server problems and performance issues, including: How to Identify and Analyse Slowly Performing Queries; How to Identify Deadlocking Issues; How to Identify Blocked Processes; How to Identify Memory Warnings, How to Identify Excessive SP Compilations; How to Identify Issues with SP Cache Activity; and How to Correlate Profiler and System Monitor Data. Given the limited time available, not every possible use of Profiler can be discussed. But by learning these specific examples, you will begin to have a fuller appreciation of what Profiler can do for you.

Red Gate Software makes tools for Microsoft technology professionals working with SQL Server, .NET, and Exchange Server. The company’s product line includes must-have tools for .NET developers who program in C# or VB.NET. Red Gate have been kind enough to provide us with a copy of ANTS Memory Profiler to give away on the night. ANTS Memory Profiler, is a tool for identifying causes of memory leaks and optimizing the memory usage of your applications.

For those of you who haven't been before, the Newcastle Coders Group is a great place to learn about the latest technologies in software development. It's also a great place to meet your peers in the local area. Everyone is welcome, so bring your friends and colleagues.

We order pizza and soft drink on the night. We ask people to contribute $5 if they want some. It’s purely voluntary as you can bring your own food if you prefer.

I look forward to seeing you there.