Answered by:
Async Service running Shrinkdatabase command

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 = 30hth & 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 = 30hth & 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