Re: waitresource

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hassan (fatima_ja_at_hotmail.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 15:06:01 -0700

On page 80, should it be "Process 52 requests an EXCLUSIVE lock on a key
that process 56 already has a share lock on."

Also on lock escalation, i think in your Inside SQL server 2000, you talked
more about the algorithm used such as if lockx ? x or so on and so forth. It
would have been nice to see that

Also on page 46, you state that in Chapter 6, you'll discuss how we might be
able to tell if a lock escalation has actually caused blocking problems.. I
dont see anything in Chapter 6

And the deadlock detection algo was not so clear to me...

"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:ec5PQmNcEHA.1764@TK2MSFTNGP10.phx.gbl...
> Please send any errors to me.
> I might be able to do an update. That's supposed to be one of the
advantages
> of an ebook, but since it got sold to a different publisher, I'm not sure
> what the procedure is.
>
> Thanks
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:OD37MCNcEHA.3716@TK2MSFTNGP11.phx.gbl...
> > btw Kalen, in your trobleshooting guide on Locking and Blocking, do you
> have
> > an error log for errors in that publication if any noted someplace ?
> >
> > "Kalen Delaney" <replies@public_newsgroups.com> wrote in message
> > news:%23%23pt%23LIcEHA.796@TK2MSFTNGP09.phx.gbl...
> > > If the waittype is 0, you are not waiting for anything. The
lastwaittype
> > is
> > > just the last thing you were waiting for, no matter how long ago.
> > >
> > > PAGELATCH usuallly means you are waiting for I/O to complete.,
> > >
> > > Pages are identified by DB ID: File # and Page #. So the last thing
that
> > > process waited on was IO in tempdb, file 1 page 216.
> > >
> > > Why are you concerned about this process?
> > >
> > > --
> > > HTH
> > > ----------------
> > > Kalen Delaney
> > > SQL Server MVP
> > > www.SolidQualityLearning.com
> > >
> > >
> > > "Hassan" <fatima_ja@hotmail.com> wrote in message
> > > news:uINqr2HcEHA.1356@TK2MSFTNGP09.phx.gbl...
> > > > I have a waittype of 0x0000
> > > > lastwaittype of PAGELATCH_UP
> > > > and waitresource as 2:1:216
> > > >
> > > > How exactly do i read that waitresource ? What is 2, 1 and 216 ?
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: waitresource
    ... SQL Server MVP ... > Also on lock escalation, i think in your Inside SQL server 2000, you ... >> Kalen Delaney ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Irregular read-only errors
    ... not allowing me to open a recordset with the correct cursor and lock ... I'm about ready to switch to using SQL Server (which I know I probably ... be an easy switch so if I could sort out Access for the time being ... Would setting the ADO connection mode to adModeReadWrite accomplish ...
    (microsoft.public.inetserver.asp.db)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... This is working fine in SQL Server and multiple session can get the ... But in Oracle the first session only return 1 row but locks all the ... It looks like both the session got the ROW-X lock but one session is ...
    (comp.databases.oracle.server)
  • Re: OLE DB Cursors
    ... You don't do this with properties in the SQL Server OLE DB provider. ... client-side cursor, otherwise you have a server-side cursor managed from the ... I have to do a lot of updates() here, ... > its optimistic lock / client cursor. ...
    (microsoft.public.data.oledb)
  • Re: Hung up using a SELECT MAX when an alter database has been execute in a SQL Server database
    ... exclusive lock, as it does for the ALTER TABLE statement. ... see "Isolation Levels" in SQL Server Books Online. ... Public Sub StartConnection() ... Set objRstSel = New ADODB.Recordset ...
    (microsoft.public.data.oledb)