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 |
|
sqlteampraful
Starting Member
2 Posts |
 Posted - 2011-09-07 : 11:21:21
|
| i have stored procedure which takes 4 min during off peak time but it takes 30 mins during peak time.the transaction replication is setup on the same server.what is the exact cause for long execution time ? Please help mei tried everything sql profiler,execution plan,update statistics,rebuild /reorganize index,created extra index,checked the utilization of memory/cpu/ io statistics, applied transaction isolation level read uncommitted/with nolockbut all these things not helped to find out the exact cause of the 30 mins.the server configuration is 24 gb ram,64 bit os it is very challenging thing to solve. |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-07 : 11:53:30
|
| I have deleted your duplicate post. please don't post duplicates in future |
 |
|
|
|
|
|
cause of different execution time of same sp