EF Core 3.1 query sometimes is superfast but sometimes is slow

.net c# entity-framework-core sql-server

Question

I am using EF Core 3.1 with sql server 2019 Developer Edition I have a complex select query with multiple includes which 90% percent is very fast (avg 200ms) but sometimes it becomes slow (sometimes takes up to 25 seconds) for the same parameters.

I have read about parameter sniffing in sql server but I don't know how to identify if this is the case that slows down the query. How can I check if this is the case?

1
2
3/18/2020 2:02:14 PM

Popular Answer

I have read about parameter sniffing in sql server but I don't know how to identify if this is the case that slows down the query. How can I check if this is the case?

Turn on the SQL Server Query Store. Monitoring performance by using the Query Store

3
3/18/2020 2:12:06 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow