144 questions
6
votes
4
answers
10k
views
Azure VM SQL Server Tempdb on Temporary Storage
We're setting up SQL servers in the Azure cloud using VMs. When we were determining the best setup for our data/logs/tempdb we ran into many blog posts that recommend placing the tempdb on the ...
- 2,485
5
votes
3
answers
25k
views
Is it safe to delete the tempdb.mdf file manually?
In SQL Server 2008, I am trying to BULK INSERT a CSV that's about 1GB in size. As I'm doing so, it's creating a huge tempdb.mdf file. Right now, it's 35GB for this 1GB CSV file.
I've tried the ...
- 18.3k
2
votes
2
answers
5k
views
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 ...
- 4,147
0
votes
1
answer
388
views
SQL Server Tempdb goes over to 200GB
SQL Syntax as below
DELETE V From Table1 V
INNER JOIN Table2 AS A ON A.Col1 = V.Col1 AND A.Col2 = V.Col2
AND A.Col3 = V.Col3 And A.Col4 = V.Col4
AND A.Col5 = V.Col5 AND A.Col6 = V.Col6
Info for ...
- 13
0
votes
2
answers
961
views
What happens to data when running a query against a federated SQL Server?
SQL Azure give you an option to setup federated SQL servers - e.g. essentially partition your data across multiple servers by some key. However, when you run select * from order, it puts all the data ...
- 62.1k
8
votes
2
answers
3k
views
When a variable is declared in a T-SQL stored procedure, is it kept in memory or tempdb?
We're trying to optimize some of our T-SQL stored procedures to reduce tempdb contention, but I can't figure out how non-table variables are stored by SQL server:
What about simple data types like INT ...
- 2,611
2
votes
4
answers
5k
views
SQL Server tempdb permanent tables use cases
Are there any use cases for permanent tables in tempdb database ? By permanent I mean not using # or ## but creating a real table in tempdb. I know that restarting the sql service will wipe the tempdb,...
- 8,261
1
vote
3
answers
2k
views
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 @...
- 10.5k
0
votes
1
answer
5k
views
sybase tempdb log segment filling
I have a Sybase ASE server that hangs every week or so, indicating tempdb log segment is full.
I have tried everything. trunc log on chkpt is enabled and it works correctly resetting used_pages ...
- 61
3
votes
4
answers
506
views
Using a SQL #tempdb to databind() to ListBox
I am creating a webpage in which I have a series of pairs ListBoxes. In each pair there is a source (containing many options) in which you can then select an option (or multiple) and add it to the ...
- 113
3
votes
4
answers
26k
views
Why are temporary tables not removed from tempdb in SQL Server?
I have created one stored procedure with 7 temporary tables and each temp table is dropped at the end of their own work.
I am calling the SP from one web service and same web service we are used for ...
- 2,958
0
votes
1
answer
1k
views
Configuration for ASPState database
Persistent ASP Session store can reside in either "tempdb" or "aspstate" database in SQL Server 2005. The sqlConnectionString parameter, in sessionState doesn't specify this (example below). How is ...
6
votes
1
answer
6k
views
SQL Server 2008 TempDB on other HD
I would like to make all stuff related to TempDB be stored on a separate HD.
I have this new HD with a 500 Gb size as my E:\ drive.
How would I use or move TempDB from one drive to another drive?
--...
- 25.2k
0
votes
3
answers
1k
views
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 ...
- 2,518
0
votes
4
answers
4k
views
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 ...
- 11
2
votes
1
answer
2k
views
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+...
- 89
1
vote
1
answer
1k
views
Size of SQL Server tempDB for Data Warehouse
Is there an expected size of tempDB for a Data Warehouse application.
Is 10 gigs excessive?
It's hit by frequent large queries.
The Data Warehouse itself is 50 gigs.
I'm using SQL Server 2000
- 4,821
1
vote
2
answers
3k
views
tempdb SQL Server locking
Our application runs alongside another application on a customers machine.
We have put some efforts regarding avoiding long-running locks in tempdb since this obviously affects concurrency badly.
The ...
2
votes
3
answers
2k
views
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.
- 1,547
16
votes
3
answers
54k
views
How tempDB works?
I am trying to understand the tempDB and following are the doubts popping in my mind.
What is the lifetime of data in tempDB? Say a query is doing some Order By and uses tempDB for performing that. ...
- 29.6k
2
votes
5
answers
3k
views
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).
...
11
votes
5
answers
7k
views
SQL Server 2005 Memory Pressure and tempdb writes problem
We are having some issues with our production SQL Server.
Server: Dual Quad Core Xeon
8 GB RAM
Single RAID 10 Array
Windows 2003 Server 64-bit
SQL Server 2005 Standard 64-Bit
There is about 250MB of ...
- 761