Re: Are RANGE locks indicative of Serializable isolation level?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 23:03:12 -0400

Make sure you have (among the normal events) the Existing connections,
SP:Stmt starting, SQL:Stmt Starting events and Login. One of these should
show a command of SET ISOLATION_LEVEL xxxx. Make sure you start the trace
before they Login so you can see all the commands. 

-- 
Andrew J. Kelly
SQL Server MVP
"TJTODD" <Thxomasx.Toddy@Siemensx.com> wrote in message
news:uX9jTqqQEHA.556@TK2MSFTNGP10.phx.gbl...
> Thanks for the response Andrew.
>
> A follow-up question...
> How would I be able to tell the isolation level for a particular SPID in a
> profiler trace?  I don't see anything apparent that would give me this
info.
>
> Thanks Again.
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:#mC4edqQEHA.3596@tk2msftngp13.phx.gbl...
> > Yes they are associated with Serializable actions.  You should be able
to
> > see what is going on by running a profiler trace.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "TJTODD" <Thxomasx.Toddy@Siemensx.com> wrote in message
> > news:%23Hkw4MpQEHA.808@tk2msftngp13.phx.gbl...
> > > I recall reading somewhere that RANGE are only used in serializable
> > > isolation level.  Can anyone confirm this?
> > >
> > > I've recently found some blocking and when I did an "sp_lock" on the
> > > blocking SPID I saw many RANGE locks.  The programmer tells me that
they
> > are
> > > using "read committed" isolation level but based on the RANGE locks -
I
> am
> > > thinking that it must be serializable.
> > >
> > > Can anyone confirm that RANGE locks are used ONLY in serializable
> > isolation
> > > level?
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Error when rebuild table index
    ... Since my SQL Server is ... The job command is as follows. ... "Andrew J. Kelly" wrote: ... >> Rebuilding indexes for table 'cliStores' ...
    (microsoft.public.sqlserver.tools)
  • Re: different environment fails to fill a dataset
    ... successfully ran the select command with no problems. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: [Announce] Angband User Interface Patch
    ... >>> Hi Andrew, ... >>This is how the Unangband implementation does it. ... > an item when issuing the handle command, ... but floor items were a headache - the various ...
    (rec.games.roguelike.angband)
  • Re: DBCC DBREINDEX
    ... > Andrew Excellent that is what I wanted to know. ... >> command can be executed the one before it must finish completely. ... >> before the previous DBCC command is completed. ... Or will it loop once issue the dbcc dbreindex ...
    (microsoft.public.sqlserver.dts)
  • Re: >> Converting a work computer to a home computer?
    ... Andrew E. wrote: ... youre internet connection,once thru,go to run,type:cmd In cmd type: ... When I login to windows, ... then it finallys logs me into windows. ...
    (microsoft.public.windowsxp.general)