Can I control the performance of a specific table in sql server 2008 profiler

Question

I want to track all the DML commands that run in a specific table of my database in the sql server profiler. Im using SQL Server 2008 R2

Answer 1

Yes, of course, you can check out this video series by Brad McGee:

Mastering SQL Server Profiler - Video Tutorial

This is very useful and teaches you the basics and some of the more advanced SQL Server Profiler concepts. Highly recommended.

Or here's a 10-minute short version of Brent Ozar: SQL Server Profiler Tutorial

In SQL Server Profiler, when you create a new profile trace, you can define filters . You can limit statistics collected per ton of different criteria - one of them is Object Name , for example. The name of the table you want to check.

For more on this topic, see Profiler Filters .

Answer 2

In addition to the proposed solutions, you can use a third-party tool that reads SQL Server traces.

ApexSQL Comply is a SQL Server audit tool that uses SQL traces, reads relevant information from them, and stores it in its central repository database. It allows you to select the tables and types of events that you want to control. You can specify to monitor different sets of events for each database.

It provides various built-in reports in which you can filter out a specific DML operation. It also has custom reports, so you can create your own reports.

You can configure the tool to monitor only certain events in the table, or if you control all events, you can use filters in reports to show only DML commands.

Disclaimer: I work for ApexSQL as a support engineer

Answer 3

You can also view advanced events based on your specific needs . This has several advantages over using SQL Profiler / SQL Trace in terms of performance, filter flexibility, and available information.

If you decide to investigate this, you can find my answer to another question , useful for starting up and working.