|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sp_who show multiple rows for same SPID/Some SPIDS block same SPID
In a new to me environment, I see 8 rows for a given SPID in sp_who. Some of
those rows may show blocks and that value is the same as the SPID in question. The server is 2k, SP4 4 proc box with Hyperthreading. Why the muliple SPIDs(1 per proc) and why the self blocking? Multiple rows per SPID indicates parallel query operation. Self-blocking
display is a new feature of SP4. Before SP4, you had no way easy way to see this information even though it was happening. If you have excessive self-blocking you may want to tweak some parallelism settings. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Jeff Ericson" <JeffEric***@discussions.microsoft.com> wrote in message news:6AF407CE-A2E9-408C-B735-6DC593014F78@microsoft.com... > In a new to me environment, I see 8 rows for a given SPID in sp_who. Some > of > those rows may show blocks and that value is the same as the SPID in > question. The server is 2k, SP4 4 proc box with Hyperthreading. Why the > muliple SPIDs(1 per proc) and why the self blocking?  
Other interesting topics
SQL 2000 on W2k fragmentation
TSQL help to delete Performance: Primary Key = int/nvarchar/guid/... How do I get my local data in the database on the Internet? waittype=WRITELOG Switching off logging on varbinary column Multiple jobs on one schedule Memory allocation in MS-SQL 2000 instances Windows says SQL is installed, but it's not! annoying SQL Server error message |
|||||||||||||||||||||||
