Top "Sql-server-profiler" questions

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results.

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the …

sql-server profiler sql-server-profiler
Where is SQL Profiler in my SQL Server 2008?

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere. I believe I installed the SQL Server Enterprise …

sql-server sql-server-profiler profiling
What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" …

sql-server database-connection sql-server-profiler sp-reset-connection
What is "Audit Logout" in SQL Server Profiler?

I'm running a data import (using C#/Linq), and naturally I'm trying to optimize my queries as much as possible. …

c# linq sql-server-2005 linq-to-sql sql-server-profiler
SQL Profiler CPU / duration units

The output from a SQL Server trace in profiler contains the columns CPU and Duration (amongst others). What units are …

sql-server-profiler
Unit of measurement for Duration column in SQL Profiler

What is the unit of the Duration column in SQL Profiler? I thought it was milliseconds but in the following …

sql-server sql-server-profiler
How to get SQL Profiler to monitor trigger execution

I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently …

sql-server sql-server-2005 sql-server-profiler
How do I get parameter values for SQL Server query in SQL Server Profiler

I'm trying to analyze a deadlock in SQL Server 2008 profiler. I know how to find the offending sql queries, but …

sql-server sql-server-2008 sql-server-profiler
How to dump an output from SQL Server Profiler 2008 to a CSV-like file

I am debugging stored procedures, and right now I am interested in what ran in what order and which which …

tabular sql-server-profiler output-formatting
How to filter SQL Server 2008 Profiler Output for a single database?

SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can …

sql-server sql-server-2005 sql-server-2008 sql-server-profiler