• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

SQL Server view query slow until refreshed

I have a view that starts performing slowly when queried via a C# program using LINQ to SQL.  The equivalent query executed in management studio performs fine.  By equivalent I mean that the SQL code that is created by LINQ to SQL is pasted into management studio and executed.

After I run sp_refreshview then the LINQ to SQL C# program performs as well as running the query in management studio.  There have not been any changes to the schema during this period.

Any ideas?
0
codebozo
Asked:
codebozo
1 Solution
 
Scott PletcherSenior DBACommented:
I suggest adding "OPTION (RECOMPILE)" to any SELECTs from this view and seeing if that solves the problem.

Sounds like you have the equivalent of the "parameter sniffing" issue for stored procs.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now