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 |
|
AmyBVT
Starting Member
2 Posts |
 Posted - 2008-11-05 : 09:41:51
|
| Hey All, I've got an SSIS package that when I run it thru VS in debug mode, it runs fine, perhaps bumping CPU up to 25% on the server in a couple of small spikes. Now, I'm trying to run it thru the agent. When it runs this way, it spikes the CPU, and stays high for much longer than the little spikes that occur when I'm running in debug mode. This behavior seems to have crashed our production server last week. However, if I run it just as frequently but in VS debug, no problems. HELP!! This is driving me nuts. What am I missing?Amy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-05 : 10:53:35
|
| What SSIs package is doing? |
 |
|
|
AmyBVT
Starting Member
2 Posts |
Posted - 2008-11-05 : 11:00:00
|
| It reads all records in a source database table, then reads all the records in a destination database table, compares dates, then either inserts,updates or deletes on the destination database. My question is really why this would use more CPU when run thru the agent than when run in debug mode in VS. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-05 : 11:04:57
|
| Read this:http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx |
|
|
|
|
|
|
|
|
SSIS Package run in VS Fine, in Agent CPU hog