Squeezing Wasted Full Scans out of SQL Server Agent

  • Excellent Article. I've seen the heartbeats you describe ever since 7.0, and had researched it to see what it was years ago, but never thought to change the behavior myself. I simply accepted that I knew what did it, it was a system function, and left it at that. There have been many times, in watching performance counters that I wished I could easily recover that processing time myself. Kudos.....

  • Good write up! I think I'd add that you want to make sure you save the changed script out someplace since a service pack "might" overwrite your change - and you'll need to look for such changes when applying the service pack. Not a big deal.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply