Post reply

Temp

  • 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?

  • May 5, 2010 at 11:32 am

    #1162653

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

  • May 5, 2010 at 11:54 am

    #1162661

    temp db is already in simple

  • May 5, 2010 at 12:06 pm

    #1162671

    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

    #1162687

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

  • May 5, 2010 at 1:18 pm

    #1162719

    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

    #1162726

    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

    #1163256

    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

    #1163352

    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

    #1163944

    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