All Questions
Tagged with parameter-sniffing entity-framework
3 questions
6
votes
2
answers
13k
views
Multi-tenant SQL Server databases and parameter sniffing
I have a multi-tenant database in SQL Server 2012 where each tenant's rows are identified by a tenant_id column (aka the Shared Database, Shared Schema approach). Some tenants, particularly the newer ...
7
votes
3
answers
5k
views
How do I control parameter sniffing and/or query hints in entity framework?
I have a problem where one of my Entity Framework (EF) queries is taking a very long time to execute in Sql Server, although when I copy-and-paste the generated TSQL into Sql Server Management Studio (...
24
votes
2
answers
5k
views
Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
I'm encountering some major performance problems with simple SQL queries generated by the Entity Framework (4.2) running against SQL Server 2008 R2. In some situations (but not all), EF uses the ...