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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-04-14 : 04:39:10
|
| Dear All,I have a query which was running fine till now by taking 2 minutes.Suddenly its taking 30 minutes to complete.I need to look for initial investigation.Can you please tell me basic and advanced checks i can do to make it run as it was running earlier.Thanks,Gangadhar |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-04-14 : 04:46:59
|
| Analyse Execution plan and try to remove index scans.Vaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-04-14 : 04:54:16
|
| I need little bit more info on how we can remove index scan Any link will be helpfull. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-04-14 : 05:27:34
|
| Is it a query or a stored procedure?PBUH |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-14 : 07:41:41
|
| Try google:First two results for "optimising stored procedures"are:http://www.sql-server-performance.com/articles/per/query_tuning_p1.aspxhttp://www.sql-server-performance.com/articles/per/optimizing_sp_recompiles_p1.aspxaCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-15 : 06:24:13
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Query tunning