Customer experience | Sales, Customer Insights,...

Poor performing query

(0) Share

Report

Posted on by Hakkinen

We have a Dynamics CRM 365 onpremise with some webservices to fetch data for out other applications.

One of the webservices times out and when we trace in SQL what is happening we see that there is one SQL SELECT which reads miliions of rows and takes 88000 milliseconds.

Now, when we take that SQL query and run it separately in SqlServer Management Studio => same query takes 2000 milliseconds !

What can be behind this - it looks like when run from Dynamics CRM it will not use index - how can it work differently ?

All responses (2)

Answers (0)

Suggested answer

Hakkinen 15 on at

Like (0)

Report

RE: Poor performing query

Actually we found the reason. Technical user, which was running our web-services had wrong setup and it could not access indices. (did not know that that was possible in MSSQL)
Gustavo Longo on at

Like (0)

Report

RE: Poor performing query

Hello Hakkinen,

Hope you are well.

If you are using the same query, would say SQL server engine should use the same execution plan to run the query regardless the source.

Would say to capture SQL Server Execution Plan and identify potential areas to improve indexes or statistics:

www.mssqltips.com/.../

Regards,