| 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 |