February 8, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bMusser/squeezingwastedfullscansoutofsqlserveragent.asp
Student of SQL and Golf, Master of Neither
February 13, 2003 at 4:47 pm
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.....
February 13, 2003 at 5:33 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply