Asked by:
The size of Microsoft Dynamics CRM 2011 - ActivityPointerBase table is inceasing very rapidly.

Question
-
The size of Microsoft Dynamics CRM 2011 - ActivityPointerBase table is inceasing very rapidly.
The table size has reached to over 300 GB and keeps increasing causing the disk space on the server tobe used up.
How can I control the size of the ActivityPointerBase table .
The CRM was upgraded from CRM 4.0 to CRM 2011.
Poonam YC
- Moved by Kalman Toth Tuesday, November 26, 2013 9:10 PM Not db design
Tuesday, November 26, 2013 7:32 AM
All replies
-
I think you will have better luck if you post your product-specific questions to a product-specific forum.Tuesday, November 26, 2013 4:52 PM
-
This is a database design forum.
300GB appears to be huge.
I am moving it to a more appropriate forum.
Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
- Edited by Kalman Toth Tuesday, November 26, 2013 9:08 PM
Tuesday, November 26, 2013 9:07 PM -
Hello,
The only way to control size of ActivityPointerBase table is delete old Activities. You can create BulkDelete job to do that. Recheck following article - http://blog.customereffective.com/blog/2012/06/using-the-bulk-delete-feature-in-crm-2011.html I'm afraid that this is the only way how you can control size of table.
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog- Proposed as answer by MubasherSharif Wednesday, November 27, 2013 5:48 AM
Tuesday, November 26, 2013 9:21 PMModerator -
As mentioned you can only control the size of that table by deleting the old activities, assuming the information has no business worth.
How is the system growing? By that I mean by how much over what time? What kind of size were you expecting the database to be over this period of time? If not maybe a design flaw that needs investigating.
regards,
Matt
Wednesday, November 27, 2013 9:29 AM -
Hi there,
Please follow below urls
http://technet.microsoft.com/en-us/library/ms178148%28v=sql.105%29.aspx
http://technet.microsoft.com/en-us/library/ms190787%28v=sql.105%29.aspx
Wednesday, November 27, 2013 10:24 AM -
Hi,
Please find details of the ActivityPointerBase table. There are only 1409 rows but still the size is over 300GB.
Thanks and regards
Poonam YC
Thursday, November 28, 2013 5:24 AM -
Where did you get the 300GB size exactly?
What do you get if you run the following command:
exec sp_spaceused 'Production.Product'
Replace the argument with schema.ActivityPointerBase . If there is no schema, just ignore it (dbo is the default schema).
Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
- Edited by Kalman Toth Thursday, November 28, 2013 9:33 AM
Thursday, November 28, 2013 9:33 AM -
Hi,
My ActivityPointerBase is showing Rowcount 42734 with dataspace 547.539MB.
What size is the whole database? How has it grown?
Matt
Thursday, November 28, 2013 9:44 AM -
Hi Kalman ,
Please find table storage details.
Thanks and regards.
Poonam YC
Thursday, November 28, 2013 9:48 AM -
Is there a DBA you can ask to rebuild the table? It appears to be some sort of corruption.
Table recreate link:
Make sure the database is backed up first.
To backup the data in the table, use SELECT INTO: http://www.sqlusa.com/bestpractices/select-into/
Contacting Microsoft support may prove to be beneficial.
Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012Thursday, November 28, 2013 11:28 AM