i need to clearly see what IP address made what sql query to SQL server. I am trying to use SQL Profiler, but it seems there is no way i can somehow to differentiate the machine (browser) where the...

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

I have a stored procedure, let's call it 'MyStoredProc', which gets called every few seconds. I want to filter it because it's cluttering the view. The proc is called like exec sp_executesql N'...

I've Googled this with no success. I'm using SQL Server Profiler for SQL Server 2008 R2, and I've ensured that for the 'Events Selection' of the trace: I'm reporting all columns for Security Audit...

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

I am profiling some MS SQL queries with the SQL Server Profiler for my C# Application that I develop with Visual Studio and IIS Express: The duration that is given for the event "Audit Logout" (...

I have a SQL Server Profiler trace and it's working for all commands. But the profiler skips one record like below:

I am debugging stored procedures, and right now I am interested in what ran in what order and which which parameters as opposed to how fast things ran and what may sneak in between and cause a slow...

Scenario: User logged in to desktop using domain account User has an Azure account in AAD which is different from the domain account Azure SQL database with AAD authentication configured for the A...

I've successfully only been able to see transaction isolation level events in the Audit Login event. Are there any other ways to monitor the transaction isolation level changes using SQL Profiler o...

I'm calling a stored proc from BizTalk server and trying to debug it. 1) Use SQL Debugger when stored proc called by an external process 2) Getting sp_tracegenerateevent to work in a stored proc...

I am trying to view SQL generated by Linq to SQL in the SQL Server Profiler (2005). I can see the sql sent to the server from anything except for linq to sql. I'm betting that I need to change even...

In my application, I use ASP.NET Identity. Every thing is work fine but by testing, I found that the following command produces many database accesses: SignInManager.PasswordSignInAsync: var resul...

I've tried several methods such as using double hyphens, i.e. --THIS IS A COMMENT but when the executed sql is read in a profiler the comment is stripped out leaving only raw SQL that is being perf...

In our ColdFusion 11 app with SQL Server 2008 R2. A .cfm file is using a CF component that is called with a syntax such as: <cfscript> objMyTable = createobject('component','components.myTa...

I am running SQL Server Profiler (SQL Server 2008). Is there a way to see the name of the stored procedure that is executing? I am profiling SP:Started and SP:Completed. The TextData column hasn't ...

I will be the first to admit that I often get confused when I use SQL Server profiler. Having said that, I decided to fire it up to see the SQL that was being generated by experimenting with the ...

I am using Sql Profiler all the time to capture the SQL statements and rerun problematic ones. Very useful. However, some code uses the SqlBulkCopy API and I have no idea how to capture those. I s...

I am helping improve the performance of a complex application with hundreds of Entity Framework queries scattered throughout the code base. One problem we have is that when we run the SQL Pro...

I am using SQL Server 2008 R2 Profiler to debug an issue on a ColdFusion 7 application - that was developed by someone else - running on Windows 7 with SQL Server 2008 R2 as a backend. The applicat...

I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, howev...

I'm using the following format for commiting changes to my db using linq. Begin Transaction (Scope Serialized, Required) Check Business Rule 1...N MyDataContext.SubmitChanges() Save Changes Don...

I'm running a data import (using C#/Linq), and naturally I'm trying to optimize my queries as much as possible. To this end I'm running a trace on the DB using SQL Server Profiler, with my trace fi...

When profiling a .Net Application in SQL Server Profiler the default Application Name is taken from the Data Provider. How can I change this to my own Application Name?

I've setup SQL Server Profiler to only report events relevant to me and it works great. However, I think what sucks is that it doesn't remember the column widths. I could set them up properly and s...