Why i get dbid 32767

• Atif

  Hall of Fame

  Points: 3578

  More actions

  January 1, 2009 at 4:22 am

  #126234

  Running the following script why i get dbid 32767 for all generated rows

  SELECT top 10 bucketid, objtype, dbid, text

  FROM sys.dm_exec_cached_plans

  CROSS APPLY sys.dm_exec_sql_text(plan_handle)

  GO

  Regards

  DBDigger Microsoft Data Platform Consultancy.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 1, 2009 at 5:38 am

  #919941

  What are the queries associated?

  DBID 32757 is the resource database, where all the system views, functions and procedures are stored. So if the queries that you see are system procs, you'd expect the dbid to be 32767.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Atif

  Hall of Fame

  Points: 3578

  More actions

  January 1, 2009 at 9:45 pm

  #920091

  I am trying to get cache objects as we get through syscacheobjects in SS2000. There we have dbid for databases to which the cache object belongs.

  DBDigger Microsoft Data Platform Consultancy.

• Atif

  Hall of Fame

  Points: 3578

  More actions

  January 1, 2009 at 11:03 pm

  #920104

  thanks for the help, the reason to get me confuse was that function db_name(dbid) was not providing me name of any db. So now i have got it.

  DBDigger Microsoft Data Platform Consultancy.