#tmpDBCCinputbuffer process

• Gilbert Grant

  SSChasing Mays

  Points: 619

  More actions

  July 18, 2007 at 2:46 am

  #179715

  Hello,

  Using SQL2005 SP2

  I am seeing a process running under SSMS at certain times that has details:

  insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(53)')

  select [Event Info] from #tmpDBCCinputbuffer...

  where i think 53 is the SPID.

  This happens when i do a certain operation in our software - but am not sure the exact thing that kicks it off as i can pause the software, wait for a while then the process starts up. Killing the software does stop the process, but killing ssms does not. When this process is running SQL server takes full CPU.

  Any ideas?

  Regards,

  Gilbert

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 18, 2007 at 3:22 am

  #720305

  You can use profiler to trace and track when the object gets created. That should be helping you.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com