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 |
|
Heinduplessis
Starting Member
23 Posts |
 Posted - 2011-08-14 : 14:09:35
|
| In SQL 2005 Enterprise Manager, I was able to go down to Management / Activity monitor and it would give me a list of the current processes, show me what the queries are, which are locked and allow me to kill processes & connections.If I check under Activity Monitor under 2008 (right-click on the server) I only get a very high level view of what's happening on the server, and I'm unable to see which individual process are running.Am I missing things, or should I regress to run queries on master? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Heinduplessis
Starting Member
23 Posts |
Posted - 2011-08-14 : 23:39:01
|
| Thanks, was such a essential part of my diagnostics :/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-08-19 : 18:23:43
|
| In Re: "Where'd Activity Monitor Go?"To hell in a hand cart.=======================================I have never met a man so ignorant that I couldn't learn something from him. -Galileo Galilei, physicist and astronomer (1564-1642) |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
|
|
|
|
|
|
|
Where'd Activity Monitor Go?