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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-08-11 : 09:42:11
|
| Hello All,I have a stored procedure in production which use to take 30sec for to get the results but now is taking 4 minutes for the same parameters. Nothing changes server wise. Any suggestions? I am running Rebuild index job now to see if that would help.How do check if any additional indexes are required? I am using SQL 2005.Thanks much,- |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-08-12 : 17:04:40
|
| Also update statistics. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-08-13 : 06:48:18
|
| Prior to checking the indexes , do an UPDATE statistics with FULL SCAN. Be careful if it's a Production system. Also do a recompile of all objectsCheck the result.If thid doesn't help do an Index Rebuild . If that doesn't help , use Profiler and Query Plans to check for inefficient execution plans.Is it just the one stored procedure or are you experiencing a wider system slow down?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Index advisor wizard