May 5, 2010 at 11:19 am
Can temp database get big in express SQL2008, if yes, what I need to do to fix it and why temp gets bigger?
May 5, 2010 at 11:32 am
One easy way is to change the recovery model as Simple;
May 5, 2010 at 11:54 am
temp db is already in simple
May 5, 2010 at 12:06 pm
My temp db size 5474.63 mb and available is 5472.82 MB, how can I make it smaller
May 5, 2010 at 12:30 pm
How is it posible anyway, I though you can have only 4G in sql express
May 5, 2010 at 1:18 pm
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.
May 5, 2010 at 1:25 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
May 6, 2010 at 8:29 am
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
May 6, 2010 at 9:26 am
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.
May 7, 2010 at 4:50 am
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!
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply