We help IT Professionals succeed at work.

SQL Server  - Error on Insert

JElster
JElster asked
on
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.
Comment
Watch Question

Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooter
CERTIFIED EXPERT
Commented:
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.