DTU Model tempdb size

Question

DTU Model tempdb size

Vishu 1,736

Hi Experts

For DTU models , the site mentions Maximum tempdb data file size (GB). Is there a max lof file size also for tempdb or Max Tempdb database size also applicable

https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases

Thanks

Accepted answer

1 additional answer

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

The max size for the log file can be found by running below query:

SELECT (CAST(Max_Size as decimal) * 8192) / 1024 / 1024 AS MaxSizeMB
FROM   tempdb.sys.database_files 
WHERE  type_desc = 'LOG'

Vishu 1,736 Reputation points

2022-02-25T06:38:42.84+00:00

Thanks Alberto. However this query will being results once the database is created.

Is there some indication there for log file size also for tempdb or Max Tempdb database at the design phase like it is mentioned for Maximum tempdb data file in the mentioned link
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-02-25T13:55:34.17+00:00

Hello @Vishu
I don't know an official MSFT document allowing to know that. It is always important to verify once the database is created no matter what official documents say. For example, you can create a DTU database on one region and there that database may be using a different hardware compared with the same tier for the database on another region. Query this DMV SELECT * FROM sys.dm_user_db_resource_governance. Take a look at the important information there and all the columns with the word MAX.
For planning, create a temp database and explore DMVs. It is my best recommendation for you.
Hope this gives you more vision for planning and hardware sizing

Answer 2

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

Hi, @Vishu Thanks for posting your query,
In addition to @Alberto Morillo , you can also refer to this document

Thanks, @Alberto Morillo for your support.

Regards
Geetha

Share via

DTU Model tempdb size

1 additional answer

Your answer