Squeezing Wasted Full Scans out of SQL Server Agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Bob Musser » Squeezing Wasted Full Scans out of SQL Server...

Squeezing Wasted Full Scans out of SQL Server Agent

Rate Topic

Display Mode

Topic Options

Author

Message

BobAtDBS

Posted Saturday, February 08, 2003 12:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, October 10, 2011 2:00 PM
Points: 297, Visits: 329

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

Post #9857

Scorpion_66

Posted Thursday, February 13, 2003 4:47 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 6:37 AM
Points: 593, Visits: 25

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.....

Post #53787

Andy Warren

Posted Thursday, February 13, 2003 5:33 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

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/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #53788

« Prev Topic | Next Topic »

Permissions