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

All replies

• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  1

  Sign in to vote

  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 PM

  Moderator
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  

  Hi Kalman ,

  Please find table storage details.

  Thanks and regards.

  ---

  Poonam YC

  Thursday, November 28, 2013 9:48 AM
• 

  

  0

  Sign in to vote

  Is there a DBA you can ask to rebuild the table? It appears to be some sort of corruption.

  Table recreate link:

  http://stackoverflow.com/questions/13521085/how-to-generate-scripts-to-recreate-table-using-sql-server-management-studio

  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 2012

  
  

  Thursday, November 28, 2013 11:28 AM