SQL Server - Error on Insert

I get the following when inserting records.. any ideas?
thx

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.
LVL 1
JElsterAsked:
Who is Participating?
 
Rich WeisslerConnect With a Mentor Professional Troublemaker^h^h^h^h^hshooterCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.