A Question About DBCC Inputbuffer

[andyrobins]

I have been tasked to set a job running that will actively monitor out of hours users and record what they were doing. It is my intention to try and throw the output of DBCC INPUTBUFFER into a table for any non-system users that are actually executing something.
The problem comes from the fact that I can't see any way of actually recording the output. Any suggestions?

Thanks in Advance

 

[JamesLean]

You would be much better off creating a Profiler trace to monitor activity - this is what it's designed to do!

With DBCC INPUTBUFFER you need to specify the SPID you want to check. If you're running this out of hours and want to see ALL activity how do you know what SPIDs are in use? You would have to do some horrible thing with iterating through the sysprocessess table or something - not nice at all!

With Profiler you could use one of the templates to monitor general activity and record it either in a log file or a table and then go back in the morning and analyze it easily.

--James

 

[andyrobins]

Why do I have such an ability to over complicate things!!

THanks James that's so much more sensible than my idea!