Crm Newshubb
Advertisement
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
Crm Newshubb
No Result
View All Result
Home CRM Software & Tools

Activity Pointer Base Table Unexpected Growth – CRM Software Blog

admin by admin
November 27, 2022
in CRM Software & Tools


Recently I had a customer that had a runaway data increase of their Activity Pointer Base table. It would grow about 4-5GB each weekend. We looked for the usual suspects such as inline images, amount of email being sent on the weekend, and nothing really seemed to stick out. I started doing email counts and noticed that the training environment wasn’t even receiving or sending email on the weekends, but was still showing growing storage usage. This led us to believe that there was an index at work here. I searched online and this was suggested by others, but no one could figure out why their index was growing out of control. We needed a method for taming runaway growth of Activity Pointer Base Table data, and so we went to the source…

Indexes and Descriptions

We opened a case with Microsoft I found out that if you put a Description field for an Activity into a column view you can get this very situation to happen. Each time that ndx_ ATuneActivityTypeCode index runs it will grab the full body of the Email messages and include that in the index, every week.

So, the way to fix this is first look at any Activity views and remove the description field from any view columns. Email is affected by this the most. Then you will need to open a case with Microsoft letting them know you found Description fields in your view columns. and they will need to run a mitigation script against the ndx_ ATuneActivityTypeCode index.  (keep reading on www.beringer.net)

 

 



Source link

Previous Post

A Home for Your Real Estate Business to Grow

Next Post

Get Tailored Notifications and Alerts on Mobiles and Tablets in your Dynamics 365 for Phones App! – CRM Software Blog

Next Post

Get Tailored Notifications and Alerts on Mobiles and Tablets in your Dynamics 365 for Phones App! - CRM Software Blog

Recommended

Qualified Versus Unqualified Leads | SugarCRM

March 14, 2023

Healthcare Portal: Streamlining the Pharma Workflow

November 8, 2022

CRM Helps Manufacturers in Operational Resiliency

September 15, 2022

Security & Scalability: Foundational IT Needs

March 28, 2023

Don't miss it

CRM Software & Tools

Webinar: Reduce storage consumption in Dynamics 365 CRM and Auto Sync Security Privileges to SharePoint! – CRM Software Blog

May 28, 2023
CRM Software & Tools

CRM Portal In College: Communication, Collaboration, and Learning

May 27, 2023
CRM Software & Tools

Meet Your Non-profit Goals by Leveraging Your Data – CRM Software Blog

May 26, 2023
CRM Software & Tools

Unified customer data enhances your client retention

May 26, 2023
CRM Software & Tools

Helped the Client Enrich Patient Experience with Dynamics Portal

May 25, 2023
CRM Software & Tools

Power BI Delivers Powerful Data Set Comparisons – CRM Software Blog

May 24, 2023
crm-white

© CRM News Hubb All rights reserved.

Use of these names, logos, and brands does not imply endorsement unless specified. By using this site, you agree to the Privacy Policy and Terms & Conditions.

Navigate Site

  • Home
  • News
  • CRM Software & Tools
  • Contact us

Newsletter Sign Up

No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us

© 2022 CRM News Hubb All rights reserved.