web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Very Large Dynamics CR...
Microsoft Dynamics CRM (Archived)

Very Large Dynamics CRM 2011 SQL Database

(0) ShareShare
ReportReport
Posted on by JadCham 255

Hi ,

I have been using the server for 11 month now and the CRM SQL Database is using 630 GB .What can be possibly wrong . Auditing is only using 5 GB this is what the auditing page in CRM listed.

I checked what tables are using the most storage here is the result :

TableName indexName RowCounts TotalPages UsedPages DataPages TotalSpaceMB UsedSpaceMB DataSpaceMB
AsyncOperationBase cndx_PrimaryKey_AsyncOperation 108272430 50001404 49908778 35851949 390635 389912 280093
WorkflowLogBase cndx_PrimaryKey_WorkflowLog 258283425 11714301 11712803 11638507 91517 91506 90925
PrincipalObjectAccess cndx_PrincipalObjectAccess 86126029 1532517 1532298 1515982 11972 11971 11843
AuditBase cndx_PrimaryKey_Audit 113842554 704634 704492 699470 5504 5503 5464
ActivityPointerBase ndx_PrimaryKey_ActivityPointer 50025 8305 8243 2832 64 64 22
ReportBase cndx_PrimaryKey_Report 165 1725 1713 23 13 13 0
IncidentBase cndx_PrimaryKey_Incident 31881 1576 1503 1451 12 11 11
ActivityPartyBase cndx_PrimaryKey_ActivityParty 96340 1152 1119 1098 9 8 8
IncidentExtensionBase PK_IncidentExtensionBase 31881 949 888 850 7 6 6
Attribute XPKAttribute 9671 876 854 837 6 6 6
EmailHashBase cndx_PrimaryKey_EmailHash 87676 867 694 671 6 5 5
UserEntityUISettingsBase cndx_userentityuisettingsownerid 1263 875 483 175 6 3 1
LocalizedLabel XPKLocalizedLabel 62514 652 628 610 5 4 4
WorkflowBase cndx_PrimaryKey_Workflow 201 694 663 10 5 5 0
DependencyNodeBase cndx_PrimaryKey_DependencyNode 42957 617 615 611 4 4 4
AnnotationBase cndx_Annotation 66 433 422 2 3 3 0
DependencyBase cndx_Unique_Dependency 52382 489 479 475 3 3 3
SdkMessageProcessingStepBase cndx_PrimaryKey_SdkMessageProcessingStep 6342 434 403 388 3 3 3
SubscriptionSyncInfo cndx_PrimaryKey_SubscriptionSyncInfo 28878 415 375 359 3 2 2
ContactBase cndx_PrimaryKey_Contact 8127 372 318 305 2 2 2
CustomerAddressBase cndx_ParentIdAddressNumber 14160 383 340 322 2 2 2
SavedQueryBase cndx_PrimaryKey_SavedQuery 2838 348 318 300 2 2 2
SystemFormBase cndx_PrimaryKey_SystemForm 726 308 283 107 2 2 0
UserQueryBase cndx_PrimaryKey_UserQuery 3393 268 270 253 2 2 1
AccountBase cndx_PrimaryKey_Account 2493 137 102 92 1 0 0
MailMergeTemplateBase cndx_PrimaryKey_MailMergeTemplate 60 197 195 2 1 1 0
RibbonDiffBase cndx_PrimaryKey_RibbonDiff 2016 218 209 129 1 1 1
RibbonTabToCommandMapBase cndx_PrimaryKey_RibbonTabToCommandMap 7302 130 110 105 1 0 0
AccountExtensionBase PK_AccountExtensionBase 831 26 13 10 0 0 0

What do you recommend ? 

Thank You

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Peter72 Profile Picture
    Peter72 1,815 on at

    Known Issue regarding AsyncOperationBase and WorkflowLogBase. You need to do a cleanup of these tables as described here:

    support.microsoft.com/.../en-us

    Hope this helps!

  • Verified answer
    Arpita Saini Profile Picture
    Arpita Saini on at

    I agree , just do a clean up following above kb article mentioned by Peter. Apart from this to maintain the size you can also follow below kb article and create  reg keys.

    The AsyncOperationBase and WorkflowLogBase tables grow very large and performance issues occur when you use many workflows in Microsoft Dynamics CRM

    support.microsoft.com/.../968755

    The Asyncoperation tables grow very large in Microsoft Dynamics CRM

    support.microsoft.com/.../974896

    These keys will work in CRM 2011 too.

  • JadCham Profile Picture
    JadCham 255 on at

    Hi ,

    Thanks for replying I have a couple of questions  :

    1) It is recommended to turn off the Async service but executing this query on the database will take more than 24 hours and I can't stop the crm server for 24hours (I tried running the query on a replica ). So what do you recommend me to do?

    2) Can I run the query during normal business hours ?

    3) If not what do you recommend me to do?

    Thanks !

  • Suggested answer
    Peter72 Profile Picture
    Peter72 1,815 on at

    Have you created the indexes as mentioned in the article?

    support.microsoft.com/.../en-us

  • JadCham Profile Picture
    JadCham 255 on at

    Yes I did !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans