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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-07-28 : 10:55:39
|
| Hi,We're running SQL 2005 Ent. When looking in the Activity Monoitor, in the left column I see red arrows pointing down and a few hour glasses. Can someone tell me what these icons indicate?Also - It used to be easy in SQL 2000 to find the "Blocking" process by looking under Current Activity --> Locks. It would simply show the process blocking all others by labeling it "Blocking". Is there an Easy way to find the blocking process in SQL 2005?Thank you!Terry |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2009-07-28 : 11:22:20
|
| I found the answer to my first question but could still use some help with the second part concerning Blocking processes.Regards,TerryThanks,Terry |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2009-07-28 : 11:32:11
|
| Never mind. I found everything. It was all right there in front of my eyes. All I needed to do was open them!Thanks,Terry |
|
|
|
|
|
|
Activity Monitor