Question : When I use SQL server profiler to trace the SQL statement flow using SP:StmtCompleted, I can only read […]
Tag: profiler
MSSQL Server XE column client_connection_id accessible through system view/table for auditing?
Question : In our .NET application we create a SqlConnection to talk to the database. After the connection is opened, […]
Is Network I/O included in the timings for “RPC complete” seen in SQL Profiler?
Question : When watching results in SQL Profiler, does the RPC Complete include time to send results to the client? […]
Identifying Unused Stored Procedures
Question : This next year, I am helping an effort to clean several SQL Server environments. We have about 10,000 […]
Mysterious procedure calls without parameters – but no exceptions generated
Question : I’ve been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient […]
Diagnosing Blocking issues using Blocked Process report
Question : I have an application that is going down as a result of timeouts. During these times we see […]
What is the use of trace captured via Profiler?
Question : I am learning about capturing trace via profiler. I understand that the purpose of capturing trace via profiler […]
What does ‘system lock’ mean in mysql profiling a LOAD DATA INFILE statement?
Question : 2M rows inserted using LOAD DATA INFILE to innodb takes 7.5min, and profiling shows 99% of that time […]
Running a sql server Trace of 1 GB using sqlcmd
Question : I am load testing two sql server instances. I have a trace file from sql server 2000 database […]
Interpretation of a column in SQL Server profile trace
Question : In a trace table generated by Profiler I tried to determine the origin of a lock using the […]