Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    23

    Unanswered: Query governor cost limit

    Hi all,
    I want to turn on the query governor cost limit option for 20 minutes so that queries do not run longer than 20 minutes but I could not find any info as if this option would also not allow database backup job or other maintenance jobs to run more than 20 minutes. We have backups (Via RedGate) run over 3.5 hours and others like rebuild indexes and integrity checks even more than 3.5 hours...........Any feedback will be appreciated..............Thanks...............

    SQL Server 2012 SP2-CU1
    Windows 2008 R2
    Last edited by cdx28; 09-18-14 at 10:10.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    First, are you doing full backups all of the time? If so, have you thought doing one full one a week and differentials during the week? Have you looked at backing up by file group? There are also products like...

    SQL Server Backup & Recovery Solutions | Dell Software

    I have not been a production DBA in a long time, but trying to slap the query governor on your VERY important backup and maintenance jobs is not the right answer.

    You may also want to look at how you are rebuilding your indices. There are several options there that might be more suitable to your needs.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •