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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy