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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2009-02-17 : 10:37:39
|
| I'm just checking a new install of 2008 on my local PC. I'm looking at Activity Monitor. A number of website mention the following panes:Overview - Active User Tasks - Resource Waits - Data File I/O -Recent Expensive Queries - http://msdn.microsoft.com/en-us/library/ms175518.aspxI don't have "Active User Tasks" I've googled but found no help. Is this only available in some editions? My version is:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-02-17 : 20:41:23
|
| Yes, it's not in an obvious place! In Server Management Studio, right-mouse-click on the server & select "Activity Monitor". |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-02-18 : 04:46:20
|
| dexter cheers for reply - I can open Activity Monitor - it's what is displayed in the monitor I want to check. Do you have an "Active User Tasks" pane in your Activity Monitor? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-02-18 : 15:35:18
|
| oops - misread your post. I think active user tasks is the "Processes" pane. |
|
|
|
|
|
|
Active User Tasks