What is "Select @OlapEvent ..."

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



hi,

I ran a SQL Profiler on my database engine and saw a bunch of entries
like following:

"DECLARE @OlapEvent BIGINT;SELECT @OlapEvent = ObjIdUpdate(2);SELECT
(@OlapEvent & convert(bigint, 0xffff000000000000)) /
0x0001000000000000 AS Status, (@OlapEvent & convert(bigint,
0x0000ffff00000000)) / 0x0000000100000000 AS DbId, @OlapEvent &
convert(bigint, 0xffffffff) AS ObjId;"

Anybody know what these events are?

More importantly, these events normally has a ver long
"duration" (around 1-2 seconds) while their "CPU"/"READ"/"WRITE" are
0. How should I interpret these numbers? should I worry about the long
duration, or should I ignore them since they don't cost any CPU/IO and
probably are just stuck in the queue?

Thanks in advance

.



Relevant Pages

  • Re: Pervasive doesnt allow any more incoming connections
    ... I can shed some light on some of the log entries but do not believe ... So the database engine logs that another process has the file locked. ... This would be the transaction durabitlity log file that is corrupt. ... >Pervasive connections, while the existing connections can still remain ...
    (comp.databases.btrieve)
  • /etc/paswd, Samba and Active Domain
    ... A bunch of entries in /etc/passwd of the form first.lastname, ... Note that the "x" makes this an account that you can't log in under. ... I have to add each user to smbpasswd throught the SWAT GUI because the ...
    (SunManagers)
  • Re: Moving WINS from 2000 to 2003
    ... Unless you have a bunch of static entries in WINS don't bother. ... mornig and startup their machines the new WINS's listing will populate ... > the DHCP scopes and statics to ...
    (microsoft.public.win2000.networking)
  • Re: Help a newbie with virtusertable and aliases
    ... In article Dan M ... We handle e-mail for a bunch of domains. ... and they're handled with entries in virtusertable ... user's mailbox. ...
    (comp.mail.sendmail)
  • Problem with Event Log event triggers
    ... I have the following code to raise events when something gets written ... The problem I'm seeing is when a bunch of ... I receive an event for the first entry, ... the events for the other entries aren't triggered until another entry ...
    (microsoft.public.dotnet.languages.csharp)