Your own Performance Analysis Toolkit - Rob Carrol
How easy is it to do your own performance analysis. In this session Rob will look at:
- Using SQLDiag to run performance collections
- Analysing Profiler output using SQL Nexus
- Analysing Perfmon data using PAL
Rob Carrol
Rob Carrol has been working with SQL Server since 1999 when he started out his career as a web developer using ASP/.NET, ColdFusion and SQL Server. Since then he has continued to work with SQL Server in a DBA and consultancy capacity, specializing in performance tuning and database troubleshooting. He joined Microsoft in April 2008 as a SQL Server Premier Field Engineer, working with some of Microsoft's largest clients in the UK and Europe. Rob lives in South Ayrshire, Scotland and I am married with 2 daughters. When he's not working with SQL Server you'll usually find him playing Xbox or thinking about football or golf !
Introduction to Powershell for a DBA – Martin Bell
A new feature of SQL Server 2008 is the SQLPS mini-shell in this session Martin will be showing what you can do with this new scripting environment and why you should start using it!
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 – Your own Performance Analysis Toolkit - Rob Carrol
19:50 - 20:00 - Break
20:00 - 20:50 – Introduction to SQL Server Powershell – Martin Bell
20:50 - 21:00 - Close
Location:
Microsoft Office at Waverley Gate
http://www.microsoft.com/uk/about/map-edinburgh.mspx
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.