Question : So I have this MySQL InnoDB query here: SELECT s.vid, s.body, s.timestamp, COUNT(v.id) AS votecnt FROM stories s […]
Tag: profiler
One SQL statement different results by using SQLOLEDB or MSDASQL
Question : I’m using VB6 with SQLOLEDB and MSDASQL. By switching the provider I notice that I’m getting different results […]
INSERT BULK in SQL Profiler without values
Question : I started SQL Profiler to catch actions that are doing on server, and among them I found one […]
Do I need to keep SQL Server Profiler interface open?
Question : I’m running SQL Server Profiler on SQL Server 2008R2. I opened Profiler, gave it the required settings (including […]
MySQL: What is SQL profiler, does it different for MySQL?
Question : Whenever SQL profiling comes in mind, focus goes to two below sections: GUI tools like – MONyog, Neor […]
CPU column 5x higher on one machine vs another?
Question : We’re running into a strange issue in a deployed version of our product where the performance is just […]
Profiler TextData output is null
Question : I am doing a trace on a database and dumping the trace realtime into a table. The reason […]
Why does SQL Server Profiler show some completed statements in pairs (twice)?
Question : In SQL Server profiler I am seeing pairs of completed statements. A pair is shown below. The TextData […]
SQL PROFILER Replay statistics event interpretation
Question : I tried capturing a replayable trace on a SQL Server 2012 production environment and then replay it against […]
Download SQL Server Profiler for SQL Server Management Studio
Question : How can I profile a SQL Server 2008 database to see code that’s being executed on a particular […]