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

Announcements

News and Announcements icon
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 135

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
    135 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 142 Super User 2026 Season 1

#2
Nagaraju_Matta Profile Picture

Nagaraju_Matta 128

#3
11manish Profile Picture

11manish 119

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans