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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-07-07 : 16:13:21
|
| GurusCan you please tell me that if in sql server 2000 under management=>currentactivity=>locks/processid.in this window if the number of spids are more what does that mean?Please helpregardsNiitn |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-07 : 16:16:40
|
| What do you mean if the number of spids are more?You'll always have spids in there.Tara Kizeraka tduggan |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-07-07 : 16:37:32
|
| Yes tarathis is what i want to know?what are these SPIDs here.does this have to do anythin with locking?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-07 : 16:45:07
|
| Yes it has do with locking. These are the spids that currently have locks on objects.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-07-07 : 16:56:03
|
| So in order to have good performace these SPIDs in this window should be less?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-07 : 17:17:58
|
| Not necessarily. Locking doesn't necessarily mean performance issues. Locks are normal. When you run a select statement, shared locks are issued. You'll need to read up on locking in SQL Server Books Online to understand the various locks and their purpose.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-07-07 : 17:58:51
|
| Thnaks taraI am on to it.And tara just wanted to share a info with youi got selected as Sql DBA with one of the best in IndiaRegards |
|
|
|
|
|
|
Locking