SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

My SQLrally Session about how to measure Index Impact Changes

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

During the current week I have spoken at 2 SQLrally conferences, once in Stockholm/Sweden, and once in Amsterdam/Netherlands. At both conferences I have presented my brand-new session titled “How to measure Index Impact Changes”.

The goal of the session is very easy: imagine you want to change your Indexing Strategy in for your production system, and before applying that change, you want to find out in a reliable way, if your change is good or bad one. In my session I am presenting a simple approach how to capture your production workload, how to replay it on a different isolated test environment, and how to measure the impact of the index changes itself.

The feedback from the audience was really awesome, because in that session I described an approach, for whom people where looking for a long time. And finally they found one :-)

If you were not able to join one of my SQLrally sessions in Stockholm and/or Amsterdam, it is not a big deal, because I am also offering this session through my brand-new SQLpassion Online Academy. So if you are interested in this session, please feel free to check-out my online course about it.

Thanks for reading



Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at http://twitter.com/Aschenbrenner.


Leave a comment on the original post [www.sqlpassion.at, opens in a new window]

Loading comments...