SQLTeam.com | Weblogs | Forums

Script that trace SQL Server Database activities

sql2008r2

#1

How to run the traces for the database in SQL server, is there any script for that ? Also, I want to trace every single activity of my database.?


#2

SQL Profiler?


#3

If there is much activity this will produce LARGE amounts of data. Be prepared for that.


#4

See if this might work for you: https://github.com/billgraziano/sql-scripts/blob/master/sp_ClearTrace.sql

I wrote to capture all SQL activity to feed ClearTrace.