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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2009-05-07 : 18:59:48
|
| In SQL 2005 you could use this and see the LOCKS BY PROCESSES or OBJECTS.Where is this located in SQL 2008 Cheers |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-10 : 09:48:19
|
| Right Click the Server and you will see it. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-13 : 12:12:03
|
| Not in SQL 2008 only in SQL 2005 |
|
|
|
jmill130
Starting Member
26 Posts |
Posted - 2009-05-14 : 11:59:48
|
| is it once you right click on server->activity monitor->click on processes to expand it so you can see everything?? |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-18 : 23:45:35
|
| Let me look again for the locks by process or objects and even the CPU ...only see memory not cpu. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-19 : 04:35:44
|
| You are right, I can't find it either. I am guessing that we are supposed to use the dm views. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-20 : 18:16:19
|
| Yes i just clicked it again i do not see it.........The recent expensive queries shows CPU but that wouldn't be the current ones running... |
|
|
|
|
|
|
Activity Monitor