On one of our v12 azure sql servers, querying (from master)

SELECT top 400 * FROM sys.resource_stats
WHERE database_name = 'myDbName'
ORDER BY end_time DESC

gives error : "Unable to open the physical file "https://wasd2prodxxx.blob.core.windows.net/telemetry-servername-guid/". Operating system error 86: "86(The specified network password is not correct.)".

This is the same error discussed in this thread from february: v12-sysresourcestats-error 

On another server, the same query does not fail, but is taking over 6 minutes to produce a result! 
Also the new azure portal takes ages to display the usage graphs, probably because it is using the same view...

• Edited by Eivind Tjore Thursday, May 21, 2015 10:08 AM typos

Hi Eiving,

Sorry you are having this problem again. It should resolve itself, however if it does not, could you please send me an email with the server name so that we can mitigate the problem for you?

We know that the long response time of this view is a problem. We are actively working on improving the performance. You should see a significant improvement in the next few weeks.

Thanks,

Jan

• Proposed as answer by Joseph IdziorekMicrosoft employee Friday, May 22, 2015 4:58 AM
• Marked as answer by Girish PrajwalMicrosoft contingent staff, Moderator Sunday, May 24, 2015 2:38 PM