locked
Async Service running Shrinkdatabase command RRS feed

  • Question

  • I have installed MS CRM 2011 (RU5) on a test machine and migrated data from an instance of MS CRM 4.0.

    I have had no problem except that the Async Service continually (twice a day) runs a shrinkdatabase command on the SQL Server.

    The shrinkdatabase command should be use sparingly as it has a detrimental affect on performance if run too often.

    Is there a database or registry setting that I need to change or is some other process kicking this off.

    Thanks in advance for any help.

    Friday, January 27, 2012 4:26 PM

Answers

  • Yes we have some Bulk Deletes from time to time.

    Also, just found a unsupported way to disable the Shrink DB:

    Executing the following script on the Crm Config DB should do the trick. It disables the auto-shrink feature for all Crm DBs on the DB server.

    UPDATE ScaleGroupOrganizationMaintenanceJobs
    SET State = 1
    WHERE OperationType = 30

    hth & regards

    Uli

    • Proposed as answer by Ulrich Hüttinger Monday, January 30, 2012 10:42 AM
    • Marked as answer by Blidski Monday, January 30, 2012 11:03 AM
    Monday, January 30, 2012 10:11 AM

All replies

  • Hi,

    I am not aware of a Registry of config file switch to turn of this behaviour. Our workaround was to deny the user that runs the asynch service the permission to perform a Shrink DB command in the CRM DB.

    hth & regards,

    Uli

    Monday, January 30, 2012 9:48 AM
  • Thanks for getting back. And I like the work-around.

    So you can confirm that you also encountered this problem?

    It seems a very strange thing for the Async service do be doing and goes against SQL best practice.

    Do you run any Bulk Delete job?

    Monday, January 30, 2012 9:53 AM
  • Yes we have some Bulk Deletes from time to time.

    Also, just found a unsupported way to disable the Shrink DB:

    Executing the following script on the Crm Config DB should do the trick. It disables the auto-shrink feature for all Crm DBs on the DB server.

    UPDATE ScaleGroupOrganizationMaintenanceJobs
    SET State = 1
    WHERE OperationType = 30

    hth & regards

    Uli

    • Proposed as answer by Ulrich Hüttinger Monday, January 30, 2012 10:42 AM
    • Marked as answer by Blidski Monday, January 30, 2012 11:03 AM
    Monday, January 30, 2012 10:11 AM
  • Thanks.

    I think we have some tools now to defeat the Shrinkdatabase monster.

    Will investigate further before I implement.

     

    Monday, January 30, 2012 11:06 AM
  • We also have this problem that causes our database to have deadlocks. At what timings does the Auto Shrink occur? I noticed ours occur at around 9:13 PM.
    Monday, February 6, 2012 5:01 PM