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 |
|
pearsont74
Starting Member
27 Posts |
 Posted - 2007-09-07 : 10:21:14
|
| OK..i have 2 servers...1 inhouse and a dedicated webserver. Same database that i run a DTP import package on. Data and packages are the same. The one on the inhouse server takes maybe an hour and 15 mins. the one on the webserver takes over 6 hours??there are quite a few items running on the webserver vs the other. IIS for one and there are a few sites that are .net that use sql. How can i find out whats running and making this import run so long.as far as server specs...they are similar, the only big difference is the inhouse is on a RAID 5 with scsi HHD and the webserver is SATA HHD on a RAID 1, both have 2 gigs of ram. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-09-07 : 10:37:05
|
| I take it the package is running on the server where the dtabase resides.Where is the data being imported from? Is it a network issue.Are there any different indexes on the web server table.Is your database simple and the web one full.Are there triggers on the web table.Are there foreign keys?You can see what's running by querying master..sysprocesses.Have a look at this SP - you can change it to log to a table if you can't run it manually. Espcially look for blocking or increasing diskio.http://www.nigelrivett.net/SQLAdmin/sp_nrInfo.htmlIf that doesn't give you anything check for disk errors.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2007-09-07 : 10:50:36
|
| yes it is running on the that server, not over the network...no triggers or restrainst on that db....others im not sure...i'd ahve to look...and its importing to new tables and writes the indexs lastthe db is set to full.can i manage what is running on the master?should stopping IIS be the best solution before running this? |
|
|
|
pearsont74
Starting Member
27 Posts |
Posted - 2007-09-07 : 13:08:34
|
| I looked at this link and abit confused by what it actually does...can u explain in lamens terms lolthanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-08 : 00:16:22
|
| How big the db is? What's network speed? |
|
|
|
|
|
|
Import with DTS package taking forever