SQL Server  - Error on Insert

Posted on 2012-08-13
Medium Priority
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 41

Accepted Solution

Kyle Abrahams earned 800 total points
ID: 38287914
LVL 30

Assisted Solution

by:Rich Weissler
Rich Weissler earned 740 total points
ID: 38287964
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

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Integration Management Part 2
Loops Section Overview

862 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