Support SQL Azure

[bgiromini]

It seems that SQL Azure does not support most of the stored procedures used to return system performance information. I don't know if we should add version checks to call different queries or if we should create a different page to show specific stats for Azure. For example, sysjobs is not available and you can't install sp_WhoIsActive.

[NickCraver]

We don't use azure, so I'm not sure where to begin here - SQL monitoring is more for servers you own since you control the perf there. Someone with more azure experience would have to chime in here, I wouldn't want to include major changes to support it though, since they have their own tooling. It may be more appropriate to actually hit some azure APIs than run SQL for those cases...it would be a great candidate for the plugin model we're working on. Think of adding your own top level tabs and such to Opserver without needing to modify the core project - that's the goal.

[bgiromini]

The plugin model sounds what we need. After looking at the source code and I think it might be doable as we could just do version checks and run different sql. However SQL Azure doesn't support most of the metrics on regular Sql Server so making it a plugin sounds better. I will wait to see the new feature. Thanks for the feedback.

[arri-cc]

I like the idea of a plugin that integrates with the Azure Management API

[asalvo]

I agree that a separate Sql Azure plugin is the right way to go. After all, Microsoft made separate SCOM management packs for Sql Azure and on premise Sql Server. While the data collection mechanism is mostly the same, querying system views, the system views available on Sql Azure differ. There are also things you would want to see for Sql Azure that are not available/relevant to On Premise. Consumption, Billing, and Connection Errors (i.e. throttling events) are all very useful metrics to have for Sql Azure.

[Plasma]

How's the plugin system coming along; just revisiting this project (nice work!) and looking into making it my primary dashboard - would be happy to contribute.

Azure also has other metrics that don't make sense to normal SQL Servers (such as connection limit quotas and DB size limits), so an SQL Azure server would need to be graphed differently too.

[NickCraver]

@Plasma I haven't had a ton of time to implement the plugin space because our SQL future is still a little uncertain - we should have more info this week about where we'll be a year from now and what code gets high priority

[tmacharia]

Hey guys, has this support plugin for SQL Azure been implemented yet? It still seems not to work.