Stack Overflow
Stack Overflow

Questions tagged [tempdb]

138 questions
0
votes
1 answer

How much that Query will occupy in TempDB - TSQL

When I make a Insert Into statement it exists any way to predicte how much space that statement it will fill in TempDB? Thanks
Pedro Alves
  • 1,004
  • 1
  • 21
  • 47
0
votes
1 answer

Best Options to lead with tempDB with a lot of data

In order to load data from multiple data sources and a big amount of Data using SQL Server 2014. My ETL Scripts are in T-SQL and it taking a lot of time to execute because my TempDB are full. In your opinion, which is the best way to lead with…
John_Rodgers
  • 181
  • 1
  • 11
0
votes
1 answer

Sql Server 2016 temp db dont release space

Today i had very spesific case on temp db. My temp db has 10 datafile and all datafiles was full and database locked. I shrinked temp database, files and log files but it wasnt worked. Also i closed Sql server services and i opened again but still…
microracle
  • 69
  • 1
  • 11
0
votes
1 answer

Azure. Automation of tempDB with ARM templates

I need to automate setting tempDB files on SQL Server 2016 Web Edition with Windows Server 2016 on Azure. Is it possible to do with ARM templates?
Max
  • 35
  • 11
0
votes
0 answers

When it is generally preferred to use SORT_IN_TEMPDB=Off when creating index?

I am familiar with the indexing concepts from developer's perspective but new to creating and maintaining indexes. Most of our indexes are created with SORT_IN_TEMPDB=On option, which tells SQL Server to use tempdb for the sorting operations…
HappyTown
  • 6,036
  • 8
  • 38
  • 51
0
votes
3 answers

Changing tempdb "in-query"

Good day, Is it possible to change the tempdb my current session is using? I have a very heavy query that is meant for HD usage. Ideally, I'd like the query to be ran using a tempdb we have specifically for such heavy things. (Main issue is the…
ziv
  • 37
  • 3
  • 9
0
votes
1 answer

SQL Server job failed due to space issues

On our SQL Server agent, a job usually takes 30 minutes everyday to finish. Today, it ran for 3 hours and 41 minutes and then failed due to "Could not allocate space for object 'dbo.SORT temporary run storage: 140907480547328' in database 'tempdb'…
rvphx
  • 2,324
  • 6
  • 40
  • 69
0
votes
1 answer

SQL 2005 tempdb growth and DTA syntax errors

I arrived at work to today to discover one of our SQL 2005 servers had run out of disk space. On examination the database causing the problem was tempdb. It seems to have grown from around 8mb to 16gb, causing me some concern. After kicking…
gazamatazzer
  • 430
  • 6
  • 14
0
votes
3 answers

Sql server Tempdb on temporary disk

I read this article https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-windows-sql-performance/ that explain best practices to apply for improve performance on SQL server in Azure, I've a DS_v2 virtual machine with temporary…
Andrea
  • 1
  • 1
0
votes
1 answer

How to find out which table in TempDB consumed most spaces?

I'm facing the exact problem and thinking to give it a try on the solution proposed. I'm wondering how to query the largest size table in TempDB or is there a query whereby it list all tables in tempdb with the respective size
SuicideSheep
  • 5,260
  • 19
  • 64
  • 117
0
votes
1 answer

Use of variable tables, tempdb growth and db session sleeping

While i have got some further insight from this post i am still struggling to get a fuller understanding of my recent use of variable tables and the associated tempdb growth. I have recently been using variable tables within both stored procedures…
campervancoder
  • 1,579
  • 2
  • 11
  • 15
0
votes
1 answer

Does SQL Server recreate mdf file for TempDB on restart every time?

Does SQL Server recreate the primary files, secondary files for the TempDB database every time the server is restarted? Or does it just refresh the .mdf, .ndf or log files every time the server restarts?
user2728106
  • 185
  • 2
  • 5
  • 15
0
votes
0 answers

How can I solve whatever is causing SQL Server to throw "The transaction log for database 'tempdb' is full due to 'NOTHING'"?

SQL Server complains that it is full of nothing, which is, I guess, better than being full of some other things. This question has some very interesting answers, especially the one by Steven. However, after running the script he provided, rather…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

MsSQL collation advice needed. case-insensitive querys but case-sensitive data needed

I read a lot about "choosing the right collation" and similar stuff, but I still haven't a solution for the following problem: We got the following constellation: We switched the database for our application from Advantage Database to MsSQL Server…
Christian Schröder
  • 51
  • 3
0
votes
2 answers

Unallocate unused space in tempdb sql server

any script in sql server to find space used by temporary tables + the database name where that temp table was created in tempdb? The size of my tempDb has grown up to 100 gb and i am not able to recover the space and am unsure what is occupying so…
pso
  • 819
  • 12
  • 25
1 2 3
…
9 10