A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual SQLPASS community summit. I’ve also submitted 4 sessions and one precon, and I would be very happy if you can vote for them. Here are the 4 session abstracts:
Advanced SQL Server 2008 Troubleshooting
It’s Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task? In this session you will see a lot of different tools with which you can do effective SQL Server troubleshooting. You will learn how to identify performance bottlenecks with those tools, and how to resolve the identified bottlenecks.
Service Broker: Message in a bottle
Service Broker provides several new key features for building SOA applications directly with SQL Server 2008. This “No slides – just code” session shows you, in just 75 minutes, how to build an SOA-based, secure, reliable, and distributed messaging application with SQL Server 2008 Service Broker from scratch. In this session you will see:
*) The core architectural concepts behind Service Broker
*) How you can do SOA with Service Broker – a practical approach
*) Routing between several SQL Server instances
*) Implementing reliable messaging
*) Securing a Service Broker conversation between you and your trading partners
*) Using managed code in Service Broker applications
SQL Server Database Internals
Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyze the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution.
Troubleshooting SQL Server TempDb
For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server. TempDb is also one of the performance bottlenecks by design, because it is shared across the whole SQL Server instance. In this session we will take a closer look into the TempDb, how it is used by SQL Server, and how you can troubleshoot performance problems inside TempDb and how you can resolve them.
I’ve also submitted my workshop titled “Advanced SQL Server 2008 Performance Monitoring and Troubleshooting” as a precon for SQLPASS:
It’s Monday, 10:30am. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task? In this workshop you will see you can do effective performance monitoring and troubleshooting with SQL Server. You will learn how to identify performance bottlenecks with tools and information provided by SQL Server and how to resolve the identified performance bottlenecks.
We will start by giving a general overview about SQL Server and the life-time of a query inside SQL Server. You will learn about Wait Statistics and how you can use them to identify your performance bottlenecks. After laying out the foundation we will move on with SQL Server Profiler and the Windows Performance Monitor. We will also have a look into the TempDb, because TempDb is a performance bottleneck by design, because it is shared across a whole SQL Server instance. We will also have a deep look into Memory Management and how SQL Server interacts with the Windows OS to acquire and release memory. Finally you will learn about SQLDiag and SQL Nexus which are 2 tools for advanced performance monitoring and troubleshooting.
I’ve already done this precon at SQLbits a few weeks ago in Brighton/UK with about 40 people in it, and got amazing feedback on it. Here are some feedbacks, so that you can get a picture what you can expect from this precon:
- “I attended the one-day workshop that Klaus ran at the recent SQLBits conference in Brighton, and it has been the most useful training I have attended in years. It was not just the level of knowledge presented, but the way that Klaus explains concepts in ways that really make them stick, which makes it so valuable. I came away from the course as a better DBA, armed with a better understanding and new practical tools which I can immediately use, plus he has opened my eyes to different ways to approach the whole area of performance tuning and troubleshooting. I can recommend Klaus very highly as a trainer, and I have no doubts about his ability to deliver as a consultant.”
- “I just want to say that I think it was an amazing workshop and gave me a lot of tips and a better understanding on SQL Server. I work as an administrator and only have 20 % of my time to SQL Server so the workshop helped a lot.”
- “Thank you very much. I really enjoyed this training. I learned a lot of good things that I can apply at work now.”
Here’s the link for the session/precon voting: http://www.sqlpass.org/summit/2011/Speakers/SessionPreferencing.aspx