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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-01-10 : 11:48:38
|
| we have a lot problems with DB,like:1.in the weekend we have "running-DTS" ,that pull data for one year (usually we pull for 2 month) ,bur recently it take a 24 Hours to complete it. in usually it take 12 hours.2.some cubes will stuck,(in process but not finish) it happend not every day.how can i check the DB? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-10 : 12:11:17
|
| 1)Check for locking/blocking.2)Load will be slow if you have more indexes. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-01-10 : 13:42:38
|
| we dont have any indexes how can i check the locking if it run in the night? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-10 : 14:00:31
|
what is your real job man?quote:
we dont have any indexes how can i check the locking if it run in the night?
just kidding 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-01-10 : 14:14:46
|
| that build the fact |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-11 : 07:10:02
|
quote:
Originally posted by inbs
we dont have any indexes how can i check the locking if it run in the night?
Blocking- Run sp_who2 active and blocked by column or activity monitorLock- sp_lock or sys.dm....tran_lock (DMV). |
|
|
|
|
|
|
problem with DB-SQL 2000