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: 442467 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: 398679 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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

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: 442467 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!