Stack Overflow
Stack Overflow

Questions tagged [tempdb]

138 questions
0
votes
3 answers

SQL Server 2008: A *Data File IO counter* for SQL Server

I make a stress test of the SQL Server 2008 and I want to know what is the data flow to tempdb because of usage of temporary tables and variables. The statistics is also shown in Activity Monitor: Is it possible somehow to record the data and…
Timofey
  • 2,478
  • 3
  • 37
  • 53
0
votes
0 answers

TempDB running out of space for MERGE query

I am using a MERGE Query that is INSERTING over 800 Million records into a table from another table in the same database (conversion project). We run into this error below when it get's to this particular table it has to write to for the SQL…
MikeGen18
  • 49
  • 7
0
votes
0 answers

Both tempdb and database transacton log full

We saw some substantial log growth on both tempdb and one of the user databases. Our database is in Snapshot isolation and we take transaction log backups every 15 minute. First 'TL log full error 9002' happened at 12.03, 2 minutes after the tl…
Nish
  • 21
  • 4
0
votes
0 answers

Access information about temp tables in SQL Server

In SQL Server Management Studio, I have a bunch of temporary tables, they look like they were created by the system: Can I drop them? How can I get more information about them? For example, what procedures are creating these? I'd like to fix what…
Joth
  • 155
  • 1
  • 2
  • 10
0
votes
0 answers

sql server tempDB files on RAMDisk AND physical disk

We find, for our application, locating TempDB files on RAMDisk improves performance significantly. But we don't want to allocate more RAM to RAMDisk than necessary. Nor do we want SQL Server to fail because it can't grow TempDB. I remember reading…
Paul Davis
  • 23
  • 5
0
votes
4 answers

SQL Server 2005 TempDB Size

We are using SQL Server 2005. Recently SQL server 2005 crashed in our production environment due to large tempdb size. 1) what could be reason for large tempdb size? 2) Is there any way to look what data is there in tempdb?
Maulin
  • 11
  • 2
  • 3
0
votes
1 answer

TempDB with big files - Performance issue

I have a TEMPDB database with 8 files but, they have different sizes which is not recommended, as follow: TempDB Files I have a plan to resize to the same size as recommended with 20GB each, the TEMPDB total will be 160GB. My question is, if the SQL…
RFerreira
  • 39
  • 1
  • 1
  • 6
0
votes
2 answers

How To Detect Active User Session by sqlcmd

I'd like to get active user session count before rebooting instance, exclude any background sessions. Just thinking to use following query but I'm not sure how to exclude select session for tempdb by SQL Server. SELECT COUNT(*) FROM…
Sachiko
  • 808
  • 1
  • 12
  • 31
0
votes
1 answer

Memory Spill in dmvs

In sql server 2014, can we find the queries which spilled into tempdb using dmvs ?
jshikha
  • 3
  • 2
0
votes
1 answer

SQL Update with join involving NVARCHAR(MAX) column balloons TEMPDB

The following query causes the SQL Server 2014 TEMPDB.MDF to grow to 40Gb and takes about an hour to run. Similar queries for columns that are not NVARCHAR(MAX) take a few minutes. The table being updated has approximately 7 million rows. Adding the…
Jon Mason
  • 3
  • 2
0
votes
1 answer

Detecting performance impact of tempdb disk speed with snapshot isolation level in SQLServer

We use SQL Server with snapshot isolation level. Exactly it is a read committed snapshot level. As far as I know, in such case, SQLServer uses the version store in tempdb. In our environment tempdb is stored on slower disks than the main database.…
Gattaka
  • 147
  • 1
  • 9
0
votes
1 answer

Temp procedure messes up collation

Issue: i have a procedure (simplified), created by .NET application: create procedure #SaveData @InValue varchar(128) as begin insert into Production.TargetTable (PREFIX_Value) select @InValue end Problem is, the database uses…
Vladislav Zalesak
  • 703
  • 5
  • 18
0
votes
1 answer

SQL Query to get data from various databases

I wrote the below query to pull the data from different databases. I have created two temp tables to pull the data from two different databases and finally a select statement from the original database to join all the tables. My query is getting…
unnikrishnan
  • 141
  • 2
  • 3
  • 15
0
votes
1 answer

Is temp DB scalable in azure SQL DB

I’m trying to bulk import a very large table (75G) into the azure SQL DB (pricing tier P6 premium 1000 DTUs), it failed with the following error message “Msg 40544, Level 17, State 2, Line 179 The database ‘tempdb’ has reached its size quota.…
LeonM
  • 1
  • 1
0
votes
0 answers

stored procedure MSenumgenerations90 is slowing down merge replication

I have a merge replication that has been running fine for a year (the system has been active for several years but I recreated the replication a year ago because of some other problems). Everything is still working but when someone is…
Dratskapoo
  • 11
  • 5
1 2 3
…
9 10