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 |
|
Dennis Falls
Starting Member
41 Posts |
 Posted - 2007-11-27 : 11:14:48
|
| I am using a third party etl tool, Pervasive Business Integrator, to perform a twice daily load of approximately 55,000 records from a pipe delimited file. My process contains 1 insert and 5 updates to the same table. during this process I maintain 2 indexes, one is the PK and is an indentity field. The other is the key for running the updates against. All other indexes are dropped and rebuilt.This step has increased it's processing time to over 2 hours, up from 35 minutes. Just before the thanksgiving holiday, I stopped and restarted the SQL Server Service, to clear out any lagging users. From Wednesday afternoon to Monday morning, the process took approx 35 minutes on average. Once users started running reports on Monday afternoon, the process took 2 hour 8 minutes. This morning, with no active users, the process still took 1 hour 48 minutes.Is there any one thing I should be monitoring in SQL Profiler on Performance monitor. When I look in the current activity processes, I don't see that there any blocks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-28 : 02:50:02
|
| Check disk i/o and page split/sec. |
 |
|
|
|
|
|
Third Party ETL tool