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

How To Use Dynamics 365 CRM Offline: A Step-by-Step Guide – CRM Software Blog

February 2, 2023

Document Management in Outbound Email Campaigns

July 28, 2022

You Don’t Have to “Do CRM” Anymore: Introducing DialoguePrime for Viva Sales – CRM Software Blog

January 11, 2023

7 Ways Businesses Can Reduce Customer Churn

November 24, 2022

Don't miss it

News

5 Features That Make Sugar Sell’s Forecasting Better

January 31, 2023
News

Vtiger CRM Blog » CRM Trends of 2023: Social CRM

January 31, 2023
CRM Software & Tools

Explore new markets with Census Data and Land Area Mapping with maps integration within Microsoft Dynamics 365 CRM – CRM Software Blog

January 30, 2023
CRM Software & Tools

Streamline Business Operations with Microsoft Dynamics 365 CRM and Power Platform Development Services by Inogic! – CRM Software Blog

January 29, 2023
CRM Software & Tools

4 Must Have Features On-field Sales Team Will Use Daily

January 28, 2023
CRM Software & Tools

Training Dynamics 365 Users is a Waste of Time – CRM Software Blog

January 27, 2023

crm-white

© 2022 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.