Share via

How do you report a bug? dm_db_mirroring_auto_page_repair dumps stack traces.

Bruce 20 Reputation points
2024-10-30T02:01:05.21+00:00

If you select from dm_db_mirroring_auto_page_repair as a non sysadmin user, with View Server State and there is a database in restoring state, SQL dumps a stack trace.

So far, I've seen this on SQL 2012, 2014 and 2019.

We are doing this in a health check script we don't want to run as sysadmin.

Attempting to join sys.databases and filtering out dbs in state 1 isn't working for me... After SQL2012 I can't work out how to force a plan that doesn't appear to scan dm_db_mirroring_auto_page_repair causing the dump...

SQL Server Other
0 comments
Accepted answer
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2024-10-30T22:57:52.4366667+00:00

    You can report bugs on https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0 This lets Microsoft know about the bug.

    If it is an issue for which you need a fix, you need to open a support case.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2024-10-30T02:29:14.01+00:00

    Hi @Bruce,

    • For Bugs: Include the version number (e.g., SELECT @@version for SQL Server, or Help -> About for SSMS/ADS) you are using. If applicable, add a full repro script, including all supporting tables and any data needed for us to confirm behavior. You can use GitHub to share multiple files or GitHub Gist to share scripts/snippets, if needed.
    • For Suggestions/Other Ideas: Tell us how this impacts your business operations and how what you're asking for will enable/unblock your scenario. Be as descriptive as possible!

    SQL Community

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.