current activity window

I'm trying to understand the output of the current
activity window and have 2 questions:
(1) what is the difference between a green globe and a
grey one. I have a long-running job that says 'Executing'
in the jobs section of EM, but displays as a grey globe.
I thought that running jobs display as green ones?
(2) how can a process spid be displayed as several
globes? Is this multithreading?
TIA,
CBCB,
(1) Don't know, because I never use this, I always use sp_who2 in QA.
(2) Yes, multithreading.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
CB wrote:
> I'm trying to understand the output of the current
> activity window and have 2 questions:
> (1) what is the difference between a green globe and a
> grey one. I have a long-running job that says 'Executing'
> in the jobs section of EM, but displays as a grey globe.
> I thought that running jobs display as green ones?
> (2) how can a process spid be displayed as several
> globes? Is this multithreading?
> TIA,
> CB|||Thanks Mark, but does anyone know the difference between
a grey and green globe, and why a running job has a grey
globe in the current activity window?
TIA,
CB|||The green is for running processes and gray is for sleeping
processes. If you look up current activity window in the
help index, it will take you to the help topic Monitoring
with SQL Server Enterprise Manager which explains what the
different icons represent.
-Sue
On Wed, 3 Nov 2004 06:11:20 -0800, "CB"
<anonymous@.discussions.microsoft.com> wrote:
>Thanks Mark, but does anyone know the difference between
>a grey and green globe, and why a running job has a grey
>globe in the current activity window?
>TIA,
>CB