Azure Sql Database DMV issue

Hi All,

Recently we migrated from V11 to V12, and from that time onward's the event log DMV executes poorly.

If we run the DMV sys.event_log, it runs for 30 min to retrieve top 10 result. No clue why this degradation after migration.

Also is there any alternate methods/ways to read the event/connections stats log.

August 21st, 2015 5:52am

Raj,

   Sorry to hear that you are having performance issues with the DMV. We have a known performance issue with the metrics DMVs and we are working to fix this issue now. Did you try using the database pane in the Portal page to see the same data? That data comes through a different pipeline and may not have similar performance issues.

Srini

Free Windows Admin Tool Kit Click here and download it now
August 21st, 2015 8:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics