Notifications
Announcements
No record found.
The below query execute from Financial reporting database and tempdb is full because of it.
select t.name, c.name from sys.columns c join sys.tables t on t.object_id = c.object_id join sys.schemas s on s.schema_id = t.schema_id and s.name = 'Datamart' where t.name = 'DimensionValueAttributeValue' and c.name like 'AttributeValue%' or t.name = 'FactAttributeValue' and c.name like 'AttributeValue%' or t.name = 'DimensionCombination' and c.name like 'Dimension%Id' or t.name = 'DimensionCombinationUnreferenced' and c.name like 'Dimension%Id' or t.name = 'DimensionCombinationResolving' and c.name like 'Dimension%Id' or t.name = 'DimensionCombinationStaging' and c.name like 'Dimension%Key'
Hi Rami,
What is you current tempDB set up in SQL? Do you have any limitations for tempDB autogrow?
Hi Sergei,
No limitation for tempdb.
If there are no limitations, then check the available disk space.
HI Andre,
disk space is full now , What are the steps for this problem not to be repeated from the financial reports?
Do you know which operation you have performed before the issue occurred? You can increase disk size where tempDB files are located or try to restart SQL server to drop current tempDB and operation could be completed successfully after it.
thanks,
I have increased drive yesterday and restart the database but my problem because of repeated this issue.
How much space have you added yesterday? I saw cases when tempDB can eat quite a lot. And it's quite strange that the query above causes some issues. What kind of databases you have on the same server? Is it only MR, AxDB? Do you have any backup databases online?
150 GB, Just Financialreporting and AXDB
Try to run the last script from the article www.sqlshack.com/.../ and check what kind of temp tables you have there, also I would recommend to monitor SQL after the restart and check long queries. I have a case (not related to MR) when 4 years slice of data was tried to aggregate in one very complex query and it brought the same kind of issues with tempDB.
Also last week MS activated global temp tables feature for cloud production instances. I'm not sure how it works for on-premise environments, but maybe there are some other processes utilize tempDB database and resource are not released correctly.
Do you have anything else except tempDB files on the same disk? Did it work before?
TempDb and log for axdb and financial reporting .
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
