Posted by NiponW on 11/16/05 14:56

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]