Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excecution plan slows Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 7:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 12:57 AM
Points: 2, Visits: 1
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

Post #1477067
Posted Thursday, July 25, 2013 6:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 8:35 AM
Points: 377, Visits: 369
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



Post #1477462
Posted Thursday, July 25, 2013 7:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:22 PM
Points: 13,271, Visits: 12,101
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/


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1477484
Posted Friday, July 26, 2013 12:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 12:57 AM
Points: 2, Visits: 1
We will try these ways

Thank you!
Post #1477880
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse