Sample Header Ad - 728x90

Is there a direct way to know if a merry-go-round scan happened?

3 votes
1 answer
174 views
In the [docs](https://learn.microsoft.com/en-us/sql/relational-databases/reading-pages?view=sql-server-ver16) it says we can share index scans (Advanced Scanning). Now [here](https://www.mssqltips.com/sqlservertip/4472/sql-server-enterprise-advanced-scan-aka-merrygoround-scan/) they used wait stats and statistics and i did not find an extended events session that could directly identify it. The question is - how can i know that an advanced scan has been used? I know about ordered false property, but that just says that it did not use the order in the index key?
Asked by Suleyman Essa (167 rep)
Feb 21, 2025, 11:09 AM
Last activity: Feb 23, 2025, 07:14 AM