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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-04-12 : 05:57:58
|
| In sql server 2000, under current Activity I see alot of spids under Locks / ProcessIDIn addition I see the names of alot of the databases under Locks / object IS this a bad thing to see? Are these referring to locks? Do they need investigation. Any thoughts please?Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-12 : 06:12:51
|
| Depends. See what is being locked, what type of lock and what the spids are doing.Every spid will have a lock on the datbase resource.==========================================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. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-12 : 07:40:18
|
| unless you see a red mark or numbers appearing beside the process icons, or server is dead slow, timeouts reported, no need to be alarm, it is natural to see lots of processes especially if the server is shared by n-number of databases--------------------keeping it simple... |
|
|
|
|
|
|
Current Activity