All Questions
Tagged with tempdb sql-server-2008-r2
30 questions
1
vote
0
answers
129
views
High parallel tempdb disk usage
We recently added some secondary tempdb files to reduce allocation contention, this seems to have worked; however we are now getting lots of slowdowns related to I/O (WRITELOG and SQLTRACE_FILE_BUFFER ...
0
votes
4
answers
7k
views
Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database
Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database ?. Please tell me if it has bad effect on a production database.
My database ...
- 101
0
votes
0
answers
57
views
Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]
please can anyone help?
I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile.
I want to change this setup as per best practices by adding 3 additional euqally ...
- 39
0
votes
0
answers
204
views
TempDB log file bloated suddenly [duplicate]
I am trying to understand what could be the possible reason which would have caused tempdb ldf file grow full and went out of space on the drive it resides.
Compared the pattern for last month and ...
- 2,230
4
votes
1
answer
369
views
CONVERT_IMPLICIT when inserting a Geography datatype into a Geography datatype column on Temp Table
@@Version
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64)
If I try to insert data into a geography datatype in a temp table I get a CONVERT_IMPLICIT, converting a Geography datatype to a ...
- 823
2
votes
1
answer
4k
views
DBCC CHECKDB grows tempdb to a huge size - Legacy MS SQL Server 2008 R2 Instance
I have an older Microsoft SQL Server Instance (2008 R2 SU3 GDR - Build: 10.50.6220). When I run DBCC CHECKDB via a Maintenance Plan, the TempDB grows very large.
The largest DB on the instance is ...
- 21
0
votes
1
answer
3k
views
Getting PAGELATCH_UP:tempdb:1(PFS) with so many waiting queue [closed]
Getting PAGELATCH_UP:tempdb:1(PFS) with so many waiting queue. What can be solution?
We have two hexacore processors. Ideally how much tempdb can we create to handle this issue?
- 125
0
votes
1
answer
375
views
SQL Server TempDB files 1-> n and write stalls growing
I have been kinda accidentally pushed to starting to manage our DB settings, performance analyzing etc. Also as it's commonly said that TempDB file should be spread into n files based on core numbers ...
- 1
1
vote
1
answer
1k
views
ms/write on tempdb data files are dead slow
I don't know why writes on my tempdb data files are extremely slow. ms/write on each of the tempdb data files reaches to more than 800 ms!!! that's even after I moved the 8 equally sized (7GB) tempdb ...
- 91
2
votes
1
answer
1k
views
Temp DB space allocated- will it be reclaimed ever?
I have observed that the tempdb in the production environment has grown over to 100 GB after initializing it.
I understand that due to server load and some expensive queries have resulted to the ...
- 243
6
votes
1
answer
5k
views
How to solve blocking on tempdb
I am having tempdb contention (I guess, at least) on one of the servers (SQL Server 2008 R2).
Both the blocker and the waiters (10 of them) has PAGELATCH_EX wait type on database tempdb and all ...
- 1,550
12
votes
1
answer
2k
views
Does CREATE TABLE SomeSchema.#TempTableName have a bug?
Simple test-bed:
USE tempdb;
GO
/*
This DROP TABLE should not be necessary, since the DROP SCHEMA
should drop the table if it is contained within the schema, as
I'd expect it to be.
*/
...
- 71k
1
vote
2
answers
3k
views
Moved 'tempdb', now file 'tempdev2' does not exist
I moved the tempdb first locating the files:
use master
select name, physical_name
from sys.master_files
where database_id = DB_ID('tempdb');
GO
then I moved each file:
use master
go
alter database ...
- 127
1
vote
0
answers
90
views
tempdb contention issue and excessive pagewrites/s
Still removing the rust from my SQL Server skills, so please bear with some stupid questions here and there...
Customer has a SQL Server 2008 R2 running in an Azure VM with 8 cores and 14GB RAM. ...
- 143
7
votes
1
answer
369
views
Sudden increase in Page Writes/s after patching / rebooting
I was given a SQL Server 2008R2 to run, but my DBA skills are rusty after some years away from the day-to-day ops, so please bear with my (somewhat) silly questions.
This SQL Server is running in ...
- 143