Could not allocate space for object dboSORT temporary run storage

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

Tags:

Error The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B The Transaction Manager is not available The DTC transaction failed to start This could occur because the MSDTC Service is not runningTransaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim Rerun the transactionAsp.net Cache ObjectC# Remove Trailing Comma Spaces And ZerosRemoving aspnet runtime from IISDo Not Disturb Registry [dnd]Temporary disposable emailGridview select emailsession objectsExecuted as user NT AUTHORITY5cSYSTEM A cursor with the name does not existHTTP Error 404 File or directory not found

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.