May 18, 2010 at 5:09 am
Dear All,
I have a production database, in that a transaction table which is often accessed by a windows service and the transactions are updated.
For the past one week it is very slow when updating alone but the select is working fine.
Sometimes just update of a single column with the where clause with the primary key takes 2 to 8 mins.
But the update statement works fine
I have rebuild the index also but no result.
When I restore the same database in the same SQL Server and try to run the same update query within 2 secs it is updating.
Can any one help me out to fix the issue.
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
May 18, 2010 at 5:37 am
What about the statistics and log file size?
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 18, 2010 at 5:41 am
Log size is normal.
How to check the statistics?
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
May 18, 2010 at 5:45 am
Could be a wide range of things...
Triggers , foreign key lookups, index updates .....
Can you post the execution plan ?
May 18, 2010 at 5:51 am
you can update stats using sp_updatestats procedure, if you still have same problem please post execution plan.
Nag
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
May 18, 2010 at 6:11 am
Hi all,
I have deleted all the index and now it is working fine.
I need to recreate all and again I have to check.
[font="Arial"]Nothing is impossible with Hard Work[/font]:)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply