Hey Guys,
We observed huge growth in SQL Database for CRM2016. Please find below table sizes from our CRM Database.
|
TableName
|
reserved_kb
|
data_kb
|
index_kb
|
unused_kb
|
|
dbo.AsyncOperationBase
|
620,993,360.00
|
468,719,672.00
|
78,842,960.00
|
73,430,728.00
|
|
dbo.PluginTraceLogBase
|
394,180,312.00
|
328,281,200.00
|
54,813,624.00
|
11,085,488.00
|
|
dbo.AuditBase
|
191,799,536.00
|
108,552,312.00
|
83,212,512.00
|
34,712.00
|
|
dbo.ActivityPointerBase
|
20,382,760.00
|
8,537,840.00
|
11,756,904.00
|
88,016.00
|
|
dbo.ContactBase
|
14,049,008.00
|
9,108,976.00
|
4,851,432.00
|
88,600.00
|
|
dbo.as_contactproductBase
|
12,959,160.00
|
8,821,776.00
|
3,926,464.00
|
210,920.00
|
|
dbo.ActivityPartyBase
|
10,115,016.00
|
3,527,576.00
|
6,581,480.00
|
5,960.00
|
|
dbo.CustomerAddressBase
|
7,378,376.00
|
4,780,632.00
|
2,578,816.00
|
18,928.00
|
|
dbo.BulkDeleteDependent_b87cd18963f04b8aa58ba3fa034ff651
|
5,551,640.00
|
5,527,384.00
|
24,200.00
|
56.00
|
|
dbo.as_investmentchoiceBase
|
4,873,904.00
|
2,533,256.00
|
2,329,320.00
|
11,328.00
|
|
dbo.as_memberbalanceBase
|
4,511,096.00
|
2,612,736.00
|
1,869,416.00
|
28,944.00
|
|
dbo.AccountBase
|
2,381,704.00
|
1,193,848.00
|
1,124,000.00
|
63,856.00
|
We have configured SQL job to cleanup of async completed records on daily basic. for the first time we have deleted 130 million records from completed state but size is not reduced yet.
AsyncOperationbase and PluginTraceLogBase tables occupied 1TB space in our SQL.
Enable logging to plug-in trace log is enable for All in our system settings.
Please suggest best way to resolve these issues and suggest best maintenance jobs to have in our CRM.
*This post is locked for comments
I have the same question (0)
