Comments (7)
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.
from opserver.
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.
from opserver.
I like the idea of a plugin that integrates with the Azure Management API
from opserver.
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.
from opserver.
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.
from opserver.
@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
from opserver.
Hey guys, has this support plugin for SQL Azure been implemented yet? It still seems not to work.
from opserver.
Related Issues (20)
- Web site is kind of broken in Edge HOT 1
- Error During Remove PollNode
- Please help to explain perNodeSettings
- DashboardSettings - Node grouping per application
- Setup non-admin user account for WMI provider
- Cluster with multiple instances
- Docker "No security provider was found!" HOT 1
- Dashboard: Fix network speed to use proper unit
- Update nugets build errors on Opserver ASP HOT 5
- Config / Default folder missing in build HOT 2
- Additional filtering in exceptions view HOT 2
- System.NullReferenceException When Oncall Schedule Doesn't Have User HOT 1
- Redis: "An invalid IP address was specified." for master node HOT 1
- Issue With OIDC Authentication
- CPU Utilization and charts not showing in IIS deployment HOT 1
- Build badge was not updated HOT 1
- Minor typo in AsynchronousCommit HOT 4
- AG Cluster Info not displaying on SQL Dashboard HOT 12
- Enhancement : Additional Metrics for Web Servers
- Error: could not deserialize access token. Expected digit
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from opserver.