web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Behavior of Table "UserQueryBase"

(0) ShareShare
ReportReport
Posted on by 120

Hello all,

Our UserQueryBase has grown a lot in the last 30 days. The following screenshot is from our development environment:

06th February: 8096 MB

08th March: 10625 MB

pastedimage1678286365222v2.png

I then checked the database entries via XRMToolBox. Here is the following for the jump on 7th March:

pastedimage1678286463354v3.png

During the strong increase on 03 March, there were about 95 new views. But it looks like all of them are new standard system views. (Recognizable by the "My..." - because none of my users is active on the DEV system).

It looks like these are all standard system views.

Do you have similarly strong increases? Why does the memory consumption increase so much?
Does every user here get every standard view and does it scale so extremely high? (We have ~400 users)

Thank you a lot!

Br

Michael

I have the same question (0)
  • Suggested answer
    Manoj Mane Profile Picture
    1,020 on at

    Hi MichaelFo96 ,

    Connect with MS Technical Support Team and get the Top 10 Storage Table Report.
    It will help you to analysis if there are any system jobs are running.

    Refer the below link to Free up storage Space:- Free storage space in Microsoft Dynamics 365


    Thanks,

    Manoj Mane.

    Please mark this as VERIFIED if it helps. image

  • MichaelFo96 Profile Picture
    120 on at

    Hello Manoj Mane,

    thank you for your answer.

    I will have a call with the MS Technical Support today.

    BR

    Michael

  • Suggested answer
    Manoj Mane Profile Picture
    1,020 on at

    Hi MichaelFo96,

    Thanks for your update. Don't forget to update over once you got the solution. 

    It will help the community going forward. 

    Please mark this as VERIFIED if it helps. image

    Thanks,
    Manoj Mane.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans