Stack Overflow
Stack Overflow

Questions tagged [tempdb]

138 questions
2
votes
1 answer

Why isn't SQL Server 2008 R2 using all available RAM?

We have an analytics database server running SQL 2008 R2 with 192 GB of physical RAM. However, we're noticing that during analytics process, the server only uses around 70 GB, but tempdb swells to 300+ GB. The current Maximum Memory is set to…
Aaron Lewis
  • 89
  • 1
  • 1
  • 6
2
votes
0 answers

The following error occurred while opening the file '\\?\E:\TempDB\MDTempStore_1584_1_j1pv2.tmp': Access is denied

I'm trying to start a fresh install of TFS 2013 but running into the issue TF255356: The following error occurred when configuring the Team Foundation databases: TF400711: Error occurred while executing servicing step Create Warehouse for component…
chrisblue13
  • 263
  • 3
  • 18
2
votes
1 answer

SQL Server - Tempdb vs. Database Log usage

This may be a very basic question, but how can you determine beforehand whether a large operation will end up using database log or tempdb space? For instance, one large insert / update operation I did used the database log to a point where we…
Kahn
  • 1,630
  • 1
  • 13
  • 23
2
votes
3 answers

Limiting SQL Temp DB Growth

I am facing a serious issue in my production server where the temp DB grow exponantialy. Is there any way we can recover the tempDB space without restarting the SQL service? Cheers Kannan.
Kthevar
  • 1,547
  • 5
  • 14
  • 18
2
votes
1 answer

TempDB has 2 data files, but SQL Server doesn't know it?

I'm on a SQL Server 2008 R2 box. According to SQL Server, my TempDB looks like this: CREATE DATABASE [tempdb] ON PRIMARY ( NAME = N'tempdev', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\tempdb.mdf' , SIZE…
Dave Clary
  • 55
  • 1
  • 7
2
votes
2 answers

Tempdb filling up

The BI project I'm currently working on receives it's data from a complex processes based in SPs that use (too) many temp tables. This is something we do not have control over (or I would've changed it). Our part in this project is mainly based on…
Gidil
  • 4,137
  • 2
  • 34
  • 50
2
votes
5 answers

Sql Server 2000 - tempdb growing very large

We have a SQL Server 2000 production environment where suddenly (ie. the last 3 days) something has caused the tempdb data file to grow very large (45 gigs with a database which is only 10 gigs). Yesterday, after it happened again we shrank the…
Richard Berthold
  • 51
  • 1
  • 4
1
vote
2 answers

SQL Server 2005 user-defined data type, tempdb and permissions

I have a DB running on SQL Server 2005 that has a user-defined data type. The user-defined data type is also implemented in the model database, so that when I create a temp table I can use the same user-defined data type. For instance, in AppDB I…
Geoffrey McGrath
  • 1,663
  • 1
  • 14
  • 35
1
vote
3 answers

SQL cross join on temp table slow results

Have added the following code to my SQL query: (Note cut down version) DECLARE @rowType AS TABLE ( rowTypeLabel NVARCHAR (20)); INSERT INTO @rowType VALUES ('Cumulative'); INSERT INTO @rowType VALUES ('Non-Cumulative'); --select * from…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
1
vote
0 answers

Is Exponential Growth for SQL Server TempDB Normal?

I am in the position of "acting" DBA since our previous DBA left. I haven't had any formal training or the like in SQL Server. I've searched on TempDB autogrowth terms and can find a lot of information about how to turn it on, how to shrink dbs etc,…
Mark
  • 11
  • 4
1
vote
0 answers

Unusual growth tempdb

My question is the following: Scope: I am currently using Microsoft Dynamics Ax 2012 R3 and my database has the following settings in the properties of the tempdb in Microsoft Sql Server 2012. Actualmente tengo un disco de 29 GB para almacenar la…
Pablo Sanchez
  • 31
  • 3
1
vote
1 answer

TempDB one physical datafiles per CPU core in SQL Server 2000

I know it is recommended for SQL 2005 onward but does it also apply on SQL Server 2000? Any link for reference will also be appreciated.
Shahzad
  • 21
  • 3
1
vote
0 answers

Could not allocate space for object 'dbo.SORT temporary run storage: 142590947360768' in database 'tempdb' because the 'PRIMARY'

Could not allocate space for object 'dbo.SORT temporary run storage: 142590947360768' in database 'tempdb' because the 'PRIMARY'..... This error message happened 3 days ago. How can I track down what/where/when/how/who caused it? I am very new to…
Vel
  • 75
  • 1
  • 1
  • 10
1
vote
3 answers

TSQL updating large table with other from TEMPDB causes enormous grow

I have a custom import tool which bulk-insert the data in temp (421776 rows). After that the tool inserts unknown rows into the target table and updates existing rows based on a hash key(combination of 2 columns). The target db has nearly the same…
Casper Broeren
  • 760
  • 2
  • 10
  • 27
1
vote
2 answers

How to find/see tempdb in SQL Server

Should I expect to be able to see tempdb tables in SSMS? e.g. If I run this code, should I expect to be able to see the table in SSMS? -- Drop the table if it already exists IF (SELECT OBJECT_ID('tempdb..#TempPasswords')) IS NOT NULL DROP…
Allan F
  • 2,110
  • 1
  • 24
  • 29
1 2
3
…
9 10