cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaunwilks Member
Member

SQL Server data course, Database Views and the tempdb

I am looking for some technical information

Datasoure: SQL Server Database - using Database Views - Import Queries

This is the operating framework for our PowerBI solutions.

 

In many instances the size of the SQL Server tempdb increases in size more than double the size of the source database itself.

 

While the tempdb shrinks in size with a SQL Restart - Can someone please tell me what part the tempdb plays in a SQL Server database load in the PowerBI desktop ?

 

I have searched far and wide but all I read is posts where people are instructued to increase the size of this database - no explanation as to when it uses this database and how to minimise the size impacts via queries.

 

Please advise.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: SQL Server data course, Database Views and the tempdb

Hi @shaunwilks ,

 

For your first question, "While the tempdb shrinks in size with a SQL Restart - Can someone please tell me what part the tempdb plays in a SQL Server database load in the PowerBI desktop ? ", you may refer to the link: https://www.microsoftpressstore.com/articles/article.aspx?p=2233324&seqNum=3 .

 

For your second question , you can refer to the links:

https://logicalread.com/sql-server-tempdb-considerations-w02/#.XYmHrygzaUk ,

https://logicalread.com/sql-server-tempdb-best-practices-initial-sizing-w01/#.XYmKOCgzaUl ,

https://social.technet.microsoft.com/wiki/contents/articles/7508.how-to-change-the-tempdb-file-size....

(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

shaunwilks Member
Member

Re: SQL Server data course, Database Views and the tempdb

Thanks

I am familiar with these sorts of posts as our database is housed on a SQL Server.

What I am looking for is information on what exactly PowerBI is doing in there.

 

Our PBI solutions are sourced from VIEWS on the database.

The views can be accessed by any other third party application without the tempdb growing rapdily.

 

However when you refresh your PBI solution from those views the tempdb can in some cases grow drastically.

Having to restart the SQL Server Engine after every time Its not really a solution to advise.

Failure to restart the service leaves the database at huge levels. 

 

So as its PowerBI Desktop growing the size of the database I would like to know what impacts on the size of that growth and what ways us as developers writing the Database queries can minimise the size of the growth.


@v-xicai wrote:

Hi @shaunwilks ,

 

For your first question, "While the tempdb shrinks in size with a SQL Restart - Can someone please tell me what part the tempdb plays in a SQL Server database load in the PowerBI desktop ? ", you may refer to the link: https://www.microsoftpressstore.com/articles/article.aspx?p=2233324&seqNum=3 .

 

For your second question , you can refer to the links:

https://logicalread.com/sql-server-tempdb-considerations-w02/#.XYmHrygzaUk ,

https://logicalread.com/sql-server-tempdb-best-practices-initial-sizing-w01/#.XYmKOCgzaUl ,

https://social.technet.microsoft.com/wiki/contents/articles/7508.how-to-change-the-tempdb-file-size....

(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 440 members 4,123 guests
Please welcome our newest community members: