skip to main | skip to sidebar

Eric's Oracle and SQL Server Tips

The Sky is The Limit!

Jun 18, 2007

what is #tmpDBCCinputbuffer?

I often see an active process in Activity Monitor in SSMS, its detail likes the following.
What's that?

create table #tmpDBCCinputbuffer ([Event Type] nvarchar(512), [Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(72)')
select [Event Info] from #tmpDBCCinputbuffer

It is the process of Activity Monitor itself.
Posted by emao at Monday, June 18, 2007
Labels: SQL Server
Newer Post Older Post Home

Blog Archive

  • ►  2009 (5)
    • ►  May (2)
    • ►  April (1)
    • ►  February (2)
  • ►  2008 (9)
    • ►  June (1)
    • ►  May (5)
    • ►  March (3)
  • ▼  2007 (11)
    • ►  October (2)
    • ►  August (2)
    • ►  July (2)
    • ▼  June (3)
      • what is #tmpDBCCinputbuffer?
      • Windows Vista First Touch
      • Oracle Application Server Control 10g page not found
    • ►  April (1)
    • ►  March (1)
  • ►  2006 (19)
    • ►  December (3)
    • ►  October (1)
    • ►  September (4)
    • ►  June (1)
    • ►  May (1)
    • ►  April (9)
  • ►  2005 (16)
    • ►  October (2)
    • ►  August (2)
    • ►  July (6)
    • ►  June (6)
  • ►  2003 (3)
    • ►  August (2)
    • ►  July (1)

My Links

  • Orca for Oracle Database Monitoring
  • My Favorite Links
  • My Notes

Oracle on Linux

  • Oracle | Linux Technology
  • P U S C H I T Z . C O M

Database Security&Benchmark

  • Oracle Security from PeteFinnigan.com Limited
  • NIST Security Configuration Checklists Repository
  • The Center of Internet Security

Beyond English

  • VOCATIONAL - Communications Skills
  • Peak English
  • GoEnglish.com Pocket English Idioms