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 |
|
imsganesh
Starting Member
28 Posts |
 Posted - 2005-05-03 : 19:31:21
|
| All,I've a database (db1 in server1) which is accessed by some of the DTS packages. One of the packages, is copying the data (100 million records) from one table & writing into another table (Its a simple Insert Into...select * from....). This package used to run in 45mins. For the last 2 weeks, FOR NO REASON, this package is not running at all. I tried to run over the weekend & it didn't complete even after 30hrs. So i has to cancel it. Initally i thought this could be a server problem. So, I copied one more db from (db2 from server2 which is same as server1 db & this has 105M recs) & ran the same job pointing to db2. The job ran in same 45mins. Is there any way to find out why the job suddenly stopped running while it was working fine 2 weeks before?If I couldn't find out the problem, I am planning to delete this database & create a new one. In that case, do i need to change all the DTS packages pointing to this db again (though the db name will be same)?Thanks,Ganesh |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-03 : 23:30:38
|
| Have you ran a DBCC CHECKDB on the databases in questions? Have you updated statistics or reindexed lately?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
imsganesh
Starting Member
28 Posts |
Posted - 2005-05-04 : 17:08:22
|
| No I didn't do anything to the database. Only now, I've run the DBCC stmt & it is completed without any errors (0 allocation & 0 consistency errors). How can get back my job to run? or can i re-create the database? |
|
|
|
|
|
|
Configuring New Db