Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
evick
Starting Member
2 Posts |
 Posted - 2010-08-24 : 10:44:07
|
| Good Morning to the community:In the last 2 Months I'm been developing a Application and been using a view that runs in No more than 2 Seconds. Something strange happen yesterday that the same view takes 44 Seconds to display results.Anywhere who can bring me a clue will be highly appreciated.Thanks --evick |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-24 : 11:34:24
|
| there might be several reasons behind this:1. check on application side2. check for any concurrent events that might be slowing down your query in the view3. check the performance of the view on your sql server4. look for any index fragmentation on the tables your query is using in the view5. check the log files and disk size |
 |
|
|
|
|
|
Views suddenly run slow