SQL Server  - Error on Insert

Posted on 2012-08-13
Last Modified: 2012-08-13
I get the following when inserting records.. any ideas?

Could not allocate space for object '<temporary system object: 422225420288000>' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Question by:JElster
    LVL 39

    Accepted Solution

    LVL 29

    Assisted Solution

    by:Rich Weissler
    Check your tempdb in SQL Management Studio.  I'd set it's initial size to something 'fairly large' -- as large as it would normally grow to anyway.  Then make certain it can grow to a 'slightly larger than you think is reasonable'.  (Unfortunately those values will be 'it depends on your situation'.)  It's not a bad idea to have multiple files in the primary filegroup too.  Some folks recommend one for each CPU core, or at least one for every 2-4 cores.  Adding a few files if you are starting with a single file isn't a bad idea.

    Some connection may have used up all the available space in the tempdb -- SQL uses that space on it's own a fair bit, for a lot of operations, and users sometimes use that space as well.  It gets wiped and recreated when you stop and restart SQL regardless.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now