Getting Error Suddenly on SQL Azure - Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.
Our application has been running for a while and now is offline. We are getting a message stating:
When selecting from any table (MyTable below), we get:
Transaction aborted when accessing versioned row in table 'dbo.MyTable' in database 'CloudNode'. Requested versioned row was not found. Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
How does the hosted version of SQL server run out of tempdb space?
- 種類を変更済み Matt Calhoun - Datavail 2011年8月20日 11:57 SQL Azure Down
TEMPDB has a 5GB space limitation in SQL Azure, please see: http://social.msdn.microsoft.com/Forums/en-US/windowsazuredata/thread/4c66d811-9ee1-45b5-ae47-b2c1bcfd4f81
SQL Azure default database wide setting is to enable read committed snapshot isolation. Row versions generated by transactions for features such as snapshot isolation and triggers are stored in TEMPDB. You may need to modify the queries to reduce the TEMPDB space usage.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.
- 回答としてマーク KJian_Moderator 2011年8月29日 6:21
2011年8月22日 13:52As mentioned by JIAN, temp db has a capacity of 5GB space limitation. Try to reset that and execute..
Thanks Karthikeyan Anbarasan http://f5debug.net/
Can you please provide more details on what you application is doing exactly ? Since you said, your application is running for a while, if its running a single transaction for a long time, this might cause issue.
Break down the processes and try to do it as smaller and shorter transactions.
Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"