Followup post to https://thebakingdba.blogspot.com/2023/02/severity-10-using-extended-events-to.html
I decided to try and improve the two different sev10s I do - these are SQL Server Extended Events that look at the sqlserver.error_reported with a severity>10 (It was originally 10 but that one is so incredibly chatty). This saves to memory (10mb limit, but it also only seems to save 1000 rows), and then this rips it down. This should now work on Azure SQL Database, Azure SQL Managed Instance, and regular ole SQL Server. This post also updates my gist, so the old post has been updated.
<script src="https://gist.github.com/mbourgon/5bd2d9c2456b2c613d8ccf36e403e98a.js"></script>
No comments:
Post a Comment