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 |
|
jtrusted
Starting Member
3 Posts |
 Posted - 2009-08-13 : 04:05:31
|
| My system was very quickly but now sql server 2005 sp execution duration system is very slow . what is the problem ? I dont understand . Can you help me please? |
|
|
jtrusted
Starting Member
3 Posts |
Posted - 2009-08-13 : 04:18:52
|
| every system equipment is same . |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-13 : 05:42:20
|
| What part of your system is slow? Is it slow for a particular operation or slow all the time.Is the server loaded? Check the performance manager on the db server (perfMon)What logging strategy are you using (simple / full (default) / bulk logged)Could be anything.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
jtrusted
Starting Member
3 Posts |
Posted - 2009-08-13 : 07:25:40
|
| I am executing stored procedure . about 9 minutes I am getting results. Before this sp is about 1 second time.I dont know where is the problem ? |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-13 : 07:30:10
|
| OK -- so it is one stored proc that is now slow?My guess is that the stored proc is not written in a scalable way and with more data (accumulated over time) it will get slower and slower.I'll take an educated guess and say either:that the stored proc is using some horrible nested cursor?You don't have good indexes for the stored proc.Either way if you post the code of the sp you'll probably get some suggestionsCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
sql server 2005 sp execution performance problems