Temp

Question

Post reply

Temp

Krasavita

SSC-Insane

Points: 23138
More actions
May 5, 2010 at 11:19 am

#221286

Can temp database get big in express SQL2008, if yes, what I need to do to fix it and why temp gets bigger?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

jack_bab-959705 Grasshopper Points: 12 More actions · Answer 1

One easy way is to change the recovery model as Simple;

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

Krasavita

SSC-Insane

Points: 23138

May 5, 2010 at 11:54 am

#1162661

temp db is already in simple

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

My temp db size 5474.63 mb and available is 5472.82 MB, how can I make it smaller

Krasavita SSC-Insane Points: 23138 More actions · Answer 4

How is it posible anyway, I though you can have only 4G in sql express

Lynn Pettis SSC Guru Points: 442453 More actions · Answer 5

SQL Server 2008 Express has had the maximum size of the databases increased from 4 GB to 10 GB.

Start by looking at all your queries. Realize that tempdb is used by queries with ORDER BY's, GROUP BY's, aggregates, requires sorting for join processing, and probably a wealth of other intermediate activities that may transpire during query processing.

Grant Fritchey SSC Guru Points: 397956 More actions · Answer 6

And hash tables for join operations and table spools and lazy spools and index rebuilds and...

You get the picture. Tempdb is a major source of operational space in the server, even in Express. You need to know what's going on in order to appropriately size it and avoid putting stress on it.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software

Krasavita SSC-Insane Points: 23138 More actions · Answer 7

I know there is R2 package came out for express,but I don't have that I have 4G express2008 and I can't understand, how come my tem db is over 5G and it is still operational,can some one please!!!! help me to understand.Thank you

Lynn Pettis SSC Guru Points: 442453 More actions · Answer 8

Here is my take on it, tempdb is a system database and may be excluded from the 4 GB (or 10 GB) database limit. My best suggestion, contact Microsoft for a definitive answer.

paul.knibbs SSCoach Points: 15320 More actions · Answer 9

Lynn Pettis (5/5/2010)
SQL Server 2008 Express has had the maximum size of the databases increased from 4 GB to 10 GB.

Has it? The Microsoft download site for SQL Express still says the limit is 4Gb...do you have a link to a site showing this increase?

[EDIT] Actually, ignore me--I've just found this is a change in SQL 2008 Express R2. Microsoft don't seem to draw much attention to this on their website, though!