InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 01:18:11 GMT20http://www.sqlservercentral.com/Forums/Topic9857-107-1.aspxGood 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.Andyhttp://www.sqlservercentral.com/columnists/awarren/Thu, 13 Feb 2003 17:33:00 GMTAndy Warrenhttp://www.sqlservercentral.com/Forums/Topic9857-107-1.aspxExcellent 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..... Thu, 13 Feb 2003 16:47:00 GMTScorpion_66http://www.sqlservercentral.com/Forums/Topic9857-107-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/bMusser/squeezingwastedfullscansoutofsqlserveragent.asp>http://www.sqlservercentral.com/columnists/bMusser/squeezingwastedfullscansoutofsqlserveragent.asp</A>Sat, 08 Feb 2003 00:00:00 GMTBobAtDBS