Tuesday, 7 November 2017

Analyse SQL performance issues using SQL Query Store for D365FO

Someone at work showed me this. With the production environment the Query Store is enabled. So when you bring it back to a sandbox environment. All that information comes with it.

If you connect to the database via SQL management studio. Then navigate to the Query Store. There is a lot of great in depth information you could get. I have a customer that has gone live for 3 months and I wanted to see if there were any improvements we could do. Such as missing indexes we could add to our product.

image

I won’t dive in too deep as there are some great resources online on how to utilise Query Store.

I should mention a lot of this information shows up summerised on LCS. So that should be your starting point but I am really glad this is available.

No comments: