Re: Help with blocking

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Umut Nazlica (UmutNazlica_at_discussions.microsoft.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 00:49:03 -0800

I don't think parallel queries cause multiple rows in sysprocesses. I only
see multiple entries in sysprocesses related to same SPID when lightweight
pooling is set to 1. (NT Fibre's).

FYI: Parallel Process wait type is CXPACKET

"steveg@payerpath.com" wrote:

> I don't thing the DELETE is running as a parallel process because while
> it's running I only see one row for it in sysprocesses. For parallel
> queries I would expect to see multiple entries in sysprocesses for the
> same SPID with different values in the ecid column for each process.
>
> Steve
>
>

Relevant Pages

  • Re: SELECT 42 AS a, a AS b FROM system.iota
    ... Luc, system.iota in ADS has only one row and one column, which is also ... What you want doesn't work in ASE (spid is a columnname of sysprocesses): ...
    (comp.databases.sybase)
  • Re: SELECT 42 AS a, a AS b FROM system.iota
    ... What you want doesn't work in ASE (spid is a columnname of sysprocesses): ... Hello Luc, the ambiguity didn't occur to me, probably because in ADS ... select suid as spid, ...
    (comp.databases.sybase)
  • sysprocesses table in Master db
    ... There is a column named "nt_username" in sysprocesses ... tells me the exact nt login name, ... what "spid" tells. ... Jeanny ...
    (microsoft.public.sqlserver.programming)
  • Re: Allowing only certain clients access to SQL Server 2K
    ... > select net_address from sysprocesses where spid = @spid ... >>I want to increase security on my SQL Server database by restricting ...
    (microsoft.public.sqlserver.security)
  • Re: How to translate net_address
    ... select spid, dbo.fn_getIPaddress(hostname) as IPaddress ... from sysprocesses ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.connect)