Profiler dbid = 0

• Marts

  SSC Eights!

  Points: 937

  More actions

  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

• Lowell

  SSC Guru

  Points: 323518

  More actions

  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!