SQL Server agent | raise error when particular conditions are met |
xp_logevent | used to record predifined message in sql-server log without raising errror |
SQL Profiler | see all incoming queries |
cache manager | used for procedure compiled |
buffer manager | see physical file flushed on the disk |