Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hwoarang
Starting Member
14 Posts |
 Posted - 2008-12-09 : 20:44:35
|
| Hi,Anyone know what purpose of DBCC inputbuffer this command, is will auto running by SQL server? And when this command running is will occupied all the memory resource?Because when SQL server running slow, i check from Activity Process will found out this command's status show runnable. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 22:22:05
|
| DBCC inputbuffer shows SQL Statement for Particular Spid. What You are seeing is your spid to see activity monitor. |
 |
|
|
|
|
|
DBCC Inputbuffer