title: ALTER DATABASE - Cannot process request. Not enough resources to process request.
body: <p>I am working to automate some of my performance tests on Azure SQL Data Warehouse.  I had been scaling up/down the databases using the Azure portal.  I read in <a href="https://msdn.microsoft.com/en-us/library/mt204042.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/mt204042.aspx</a> that it is possible to use T-SQL to accomplish this via</p>
  
  <p>ALTER DATABASE  ...</p>
  
  <p>In my first attempt using T-SQL, the attempt failed:</p>
  
  <pre><code>RunScript:INFO:  Mon Feb  6 20:11:06 UTC 2017 : Connecting to host      "logicalserver.database.windows.net" database "master" as "myuser"
  RunScript:INFO: stdout from sqlcmd will follow...
  ALTER DATABASE my_db MODIFY ( SERVICE_OBJECTIVE =  'DW1000' ) ;
  
  Msg 49918, Level 16, State 1, Server logicalserver, Line 1
  Cannot process request. Not enough resources to process request. Please retry you request later.
  RunScript:INFO:  Mon Feb  6 20:11:17 UTC 2017 : Return Code = "1" from host "logicalserver.database.windows.net" database "master" as "myuser"
  RunScript:INFO: stdout from sqlcmd has ended ^.
  </code></pre>
  
  <p>I immediately went to the Azure portal, requested a scale, and it worked (taking 10 minutes to complete).</p>
  
  <p>Is there any explanation?  </p>