Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

SQL Rally: One Day on Query Performance Tuning

The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This includes selection of the pre-convention (precon) paid presentations through a voting process. I have a session called Query Performance Tuning, Start to Finish. It’s a one day session on everything about tuning queries.

I won’t republish the abstract and bore the heck out of you, but I will list the 5 skills I think you’ll take away with you if you attend (after voting for me):

  1. The ability to collect performance metrics on your servers as part of an overall query tuning methodology
  2. The ability to generate, read, and understand execution plans from multiple sources in support of troubleshooting poorly performance queries
  3. An understanding of how the optimizer works in support of writing better TSQL code as well as troubleshooting poorly performing queries
  4. A working knoweldge of DMOs that will help you identify and fix performance issues on your servers
  5. The ability to address common query performance problems

The thing is, query performance frequently comes down to just a handful of common problems.If you learn how to identify which queries are running slowly, and how to discern which of the common problems you’re running into, you’ll almost always know how to fix the query, whether it’s restructuring it, rewriting it, or simply adding or modifying indexes in support of the badly performing query.

Please, if this sounds interesting, go and vote for it. If not, please go and vote anyway so that the community’s voice is heard.


Comments

Posted by bharathreddyabr on 28 October 2010

It will help all those who are interested  in sql server

Posted by Jens-Peter Giersch on 28 October 2010

*****

I voted for you, but I still haven't those skills yet. Something didn't work out :-(

:-)

Guess I really have to attend your session :-)

Posted by Grant Fritchey on 28 October 2010

What, they didn't arrive. Just wait, they should be there shortly...

Hope you can make it, whether or I win or not. SQL Rally should be a good event.

Posted by zeki on 30 October 2010

hello

Leave a Comment

Please register or log in to leave a comment.