Posted by Mike Epprecht \(SQL MVP\) on 11/16/05 23:02

Hi

Have a look at this thread:
http://groups.google.com/group/microsoft.public.sqlserver.server/msg/b86e343e513ab281?hl=en

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"NiponW" <niponw@yahoo.com> wrote in message
news:1132145773.581669.233070@g49g2000cwa.googlegroups.com...
> Hi,
> I have SQL SERVER 2000 SP4 Enterprise , Windows 2003
> Enterprise on
> Xeon 4 Processors (now with multi-threading CPU) and I have
> questions which
> seem weirds to me (used to have the same config without
> Multi-Threading) as following:
> 1. SQL Server see 8 CPUs. Is this because of
> multi-threading CPUs ?
> 2. when use SP_WHO2 ACTIVE ,
> 2.1 Result has user SPID , which block
> itself
> (it is UPDATE and SELECT
> statements, most often)
> 2.2 Result has user SPID , show more
> than one result rows with
> the same processe and command
> 3. when use Properties of SQL Server , it has an
> error 15407 in log.
>
> many thanks in advance
> NiponW
>

[Back to original message]