Monitoring performance of natively compiled stored procedures - database-scoped configuration options

added by DotNetKicks
4/4/2018 6:19:35 PM

1 Kicks, 146 Views

We just added new XTP_PROCEDURE_EXECUTION_STATISTICS and XTP_QUERY_EXECUTION_STATISTICS are available now in Azure SQL Database, and will be available in the next major release of SQL Server. These options will improve your monitoring and troubleshooting experience for databases leveraging database-scoped configuration options that will help with monitoring performance of natively compiled stored procedures.