Skip to main content

All 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 ...
Mike's user avatar
  • 7,701
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 (...
Mike's user avatar
  • 7,701
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 ...
mindlessgoods's user avatar

X