Martin Stevnhoved Posted November 29, 2018 Share Posted November 29, 2018 Hi. I would really like to see the SQL Server Module to support Azure SQL. It would be great if we could se performance data (which all can be read from system tables), and create notifications based on thresholds. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-resource-stats-azure-sql-database   Link to comment Share on other sites More sharing options...
Martin Stevnhoved Posted November 29, 2018 Author Share Posted November 29, 2018 When trying to configure SQL Server module for an Azure SQL, it tests the connection fine. But when Pulseway tries to get information from the server, it writes this error in the trace.log 29-11-2018, 10:53:07.404: [Service] Microsoft.SqlServer.Management.Smo.UnknownPropertyException: Product: unknown property. at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap) at Microsoft.SqlServer.Management.Smo.Server.get_Product() at MM.Monitor.Service.Configuration.DbSQLServerConnection.GetServerInfo() at .........(Request .) Â Link to comment Share on other sites More sharing options...
Martin Stevnhoved Posted November 29, 2018 Author Share Posted November 29, 2018 When trying to query from Pulseway manager, I am able to query the server information and database information for master. I cannot query the information for user databases because Azure SQL requires that you connect to database, and nos just change database with USE. I think it would be a fairly simple task to change the Module to support its basic functionality on Azure SQL. Link to comment Share on other sites More sharing options...
Administrators Paul Posted December 20, 2018 Administrators Share Posted December 20, 2018 I've added this to our todo list, we will definitely add support for it! -Paul Martin Stevnhoved 1 Link to comment Share on other sites More sharing options...
Martin Stevnhoved Posted February 19, 2021 Author Share Posted February 19, 2021 I have created this as a feature request. Support for Azure SQL - Pulseway (featureupvote.com) Please vote. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now