SQLDW: Could not allocate a new page for database

Issue: Recently I faced an issue where Stored Procedure running on SQLDW failing with error as follow An error occurred in Stored Procedure Activity execution. Diagnostic details: Database operation failed on server ‘xxxyyyy123.centralus1-a.worker.database.windows.net,11087′ with SQL Error Number ‘1101’. Error message from database execution : Could not allocate a new page for database ‘Distribution_11’ because of…

0