• http://blog.gavinpayneuk.com Gavin Payne

    Hello John,

    Excellent article, I agree that people too often only think about performance monitoring when their system has a problem, but by baselining with the tools you mention and Microsoft’s free utilities like perfstats, SQL Nexux and PAL we can be prepared for any issues by knowing already what our most commonly run queries, database hotspots, highest wait_stats and platform bottlenecks etc are. We can immediately then know if performance issues were almost to be expected or caused by something new and un-expected.

    Also, as a prepared DBA we want to be familiar with those tools so we can use them instantly when a problem occurs and baselining our systems on a normal day is an excellent opportunity for us to learn to use them at our own pace.

  • Pingback: @JohnSansom posts How to Get a Head Start on Performance Tuning | sqlmashup()

  • Pingback: 7 Essential Habits of Successful DBAs()