July 24, 2013 at 7:49 am
Hi,
We have problems with a view created from a select sentence with a few joins.
This view runs properly some days until suddenly one day becomes very slow.
If then we drop this view and create again it solves the problem.
Is this an execution plan problem? Is it possible to lock an execution plan to don't be changed?
Thank you
Francesc
July 25, 2013 at 6:50 am
As a start, make sure that you have the latest service packs installed.
Have you looked through the execution plan and query statistics?
This could be due to a number of issues such as blocking, resource contention, design issues or even index fragmentation and out of date statistics.
When you drop the view and re create it would be removed from the plan cache.
The next execution of the view would then put the plan into the cache again.
Do some digging and perhaps post some more information if you need further help
July 25, 2013 at 7:34 am
There are a number of things that could be going on. The best way we can help is to look at the actual execution plan.
See this article for best practices when posting questions about performance issues.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 26, 2013 at 12:57 am
We will try these ways
Thank you!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply