Could not allocate space for object dboSORT temporary run storage
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 162245511741440' 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.
It happens when you don't have enough space on your Drive where your tempDb database is lockated. You can avoid this by freeing up some space on that drive or
Restart MS SQL server. After restarting of SQL server it will freeup temp db size.
Note:* Do not restrict auto grow size of .MDF or .LDF file.
Also read, how SSD drive can boost the performance of your DB systems.
http://novicksoftware.com/Articles/sql-server-ssd-solid-state-disk.htm
Hard disk drives has mechanical hardware mechanisums which involves rotarry flatters and Read/Write head part.
This consumes lots time while retriving and writing the data. Bu, incase of SSD there is 2D matrix type of storage mechanisum and
there is no rotary parts which leads SSD drives for fast performance.
Satalaj
Currently rated 3.0 by 1 people
- Currently 3/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags: tempdb