How do you use cloud databases? Take the survey.

Using Azure SQL Serverless as data repository

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?


Best Answer

  • Russell DRussell D Posts: 1,324 Diamond 5
    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.
    Have you visited our Help Centre?


Sign In or Register to comment.