How can get database performance and statistics from AZURE using Powershell ?

Question

User1253338400 posted

How can i get data about my databases and performance  from Azure using powershell scripting ?

Answer 1

User283571144 posted

Hi robby32,

As far as I know, you could use Get-Az Sql Database Activity to get the current status of the database. 

If you want to query the performance and statistics  for the  Azure sql database. You could try to use Intelligent Insights to capture the information and then use powsershell to get the information. Details, you could refer to this article. 

Besides, since this forum is mainly talking about the asp.net related issue, I suggest you could also ask this issue on the Stackoverflow with azure SQL database tag.

Best Regards,

Brando

Answer 2

User1253338400 posted

This a great start.