Denis Trunin's Blogs: Monitoring the most problematic performance problem in Dynamics AX - parameters sniffing

[Logger]

Цитата:

The solution was quite simple, a custom plan was created with the OPTIMIZE FOR UNKNOWN hint, that ensured that SQL Server would not use first passed location/site values to build a plan

еще в случае InventDim нередко помогает forceselectorder