YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    A Break from Data

  • 2

    Making New Infrastructure Investments

  • 3

    Use Tools

  • 4

    The TCO of the Cloud

  • 5

    Continuous Releases

The Voice of the DBA Instrumentation

MEVIOtoday

Sep 09, 2010 Instrumentation

In a discussion recently someone mentioned that they built in timing mechanisms into their application so they were aware of how long certain modules or functions were executing. Using this data, they could easily determine if the system was performing poorly by comparing the average of timings to the current performance.

I thought that was a great idea, and it shows some proactive, forward thinking on the part of the developer. I haven't often seen this in SQL Server, though it does seem that many good DBAs maintain some type of overall baseline for their database servers in order to help them response to performance issues.

Read the rest of "Instrumentation" at SQLServerCentral.