Post reply

Profiler dbid = 0

  • April 15, 2010 at 9:45 am

    #386713

    I was looking at the profiler, trying to figure out what is hitting the server the hardest, and I found that dbid 0 hits a lot, however I don't know what that means?

    Thanks

    Marts

  • April 15, 2010 at 11:07 am

    #1152300

    I know that when you look at sys.triggers and the db_id is zero, it's because it is a Logon Audit trigger, so it's not associated to a specific database, but to the server as a whole; without looiing at your trace specifically, i would guess that it is the same thing...a trace that is capturing logon info would have to have no db context until after the connection, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply