Announcements
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 ?
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,
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)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Manoj - ManoVerse 108 Super User 2026 Season 1
11manish 63
Chris1968 20
