How can we help you today? How can we help you today?

Using Azure SQL Serverless as data repository

Hi,
Installation went without errors and everything seems to work fine. However base monitor event log is showing following error:
2019-08-27 13:15:16,694 [31] ERROR RedGate.SqlMonitor.Engine.Monitoring.Core.LogRetrieval.RepositoryInformationProvider [(null)] - Unable to retrieve repository information.
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'sp_MSforeachtable'.

sp_MSforeachtable SP is not supported in any PAAS flavor of Azure SQL except MI which I'm trying to avoid using in order to separate monitoring traffic to own resource. How critical error this is?

JoonaHook
0

Comments

3 comments

Sort by
  • Pete_Ruiz

    Hello Joona,


    Thanks for reaching out and sorry that you're having trouble with SQL Monitor. I'm trying to uncover more details about this but need more information. Can you please send over the log files to the ticket we've opened for you here with our Support Team?


    https://documentation.red-gate.com/sm9/advanced-operations/viewing-component-information-and-log-files


    Kind regards,


    Pete Ruiz
    Pete_Ruiz
    0
  • Russell D
    The above error is nothing to worry about. It's a stored procedure that simply wasn't ported to Azure (by Microsoft), so whilst you might see errors crop up in the logs it shouldn't have any effect on SQL Monitor. We're going to look into filtering the query out for Azure SQL DBs.
    Russell D
    0
  • JoonaHook
    After few days Analysis section stopped to show any data. Here's screenshot of the situation:
    What could be the reason?


    JoonaHook
    0

Add comment

Please sign in to leave a comment.