Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c] SQL:...
Hi, I'm using this 3rd party sql tracing application because I have sql server express 2008 installed (just a trial version). It only shows the sql passed into the server, with the parameters like @p1 and not that actual value of the parameter, which to me is not all that usefull. Does the built in sql profiler show you the actual val...
Duplicate of: Does sql profiler show you the paramater values that were passed in? (Asked by same user.) Hi, I need a sql profiler that will show all the sql (raw sql or sproc) that are called to a database, along with the parameters passed into the queries. I don't mind a commercial product if it has a trial. ...
I'm currently experiencing some problems on my DotNetNuke SQL Server 2005 Express site on Win2k8 Server. It runs smoothly for most of the time. However, occasionally (order once or twice an hour) it runs very slowly indeed - from a user perspective it's almost like there's a deadlock of some description when this occurs. To try to work ...
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 event selections for the trace, but not sure what else to select. I am currently only selecting this: SQL:StmtCompleted - TextData & SPID I do...
I have an application written in C# which uses Linq2SQL for communicating with the SQL Server. There are some queries that run a bit (very) slow, and I figure it probably need some indexes to speed things up. But I don't really know how to do that or on what or where or what I should or should not do. So I was thinking I could ask here,...
The output from a SQL Server trace in profiler contains the columns CPU and Duration (amongst others). What units are these values in? ...
Hello, I am struggling with a strange problem using Sql Profiler. While running some performance testing scripts, I run profiler to find bottlenecks. One particular statement seems to be taking a lot of time - with CPU 1407, Reads 75668 and Duration of 175. However when I run the same statement in Management Studio, SQL Profiler return...
I am using the Context_Info() variable to keep track of the user that is executing a stored procedure and free-form sql. When troubleshooting issues on this server everyone session comes through. I would like to be able to bring in the value of the context_info() variable and filter based on it. ...
I'm using SQL Profiler to watch some database activity, and I'm interested in watching "Permission Denied" for various objects in the database. There are about 50 different items in the "Security Audit" category, but none that seem to display "Permission denied" for an object. I can see Login Failed, and a few other failures, but nothing...
SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can that be done most easily? ...
I have just noticed that Sql Profiler 2008 is not hiding trace outputs that include sp params called password. In 2005 it used to give me a message saying "The text has been replaced with this comment for security reasons". Has they removed this security feature? ...
Hi, 99% of my time is in SQL Server land and so I'm not at all familiar with Oracle or its products...Is there a similar application to Microsoft SQL Profiler for use against Oracle databases? I'm helping debug/tune an ASP.Net application that connects to Oracle using ODAC etc thanks heaps! ...
I'm trying to troubleshoot this problem using SQL Profiler (SQL 2008) After a few days running the trace in production, finally the error happened again, and now i'm trying to diagnose the cause. The problem is that the trace has 400k rows, 99.9% of which are coming from "Report Server", which I don't even know why it's on, but it seems...
I have been told that SQL Profiler makes changes to the MSDB when it is run. Is this true and if so what changes does it make? MORE INFO The reason I ask is that we have a DBA who wants us to range a change request when we run the profiler on a live server. Her argument is that it makes changes to the DB's which should be change contro...
My SQL Profiler was working previously against my Server. I have not (AFAIK) made any modifications to the configuration of my server. When I go into SQL Profiler I attempt to "Connect to SQL Server", I enter my SQL Server (which is on my local dev machine), I get the error To connect to this server you must use SQL Server Managemen...
Hi, I have the following pretty simple linq query querying a linq to entities edmx. (from i in ent.Inspectors select i).OrderBy(s => s.Surname).Skip((page - 1) * count).Take(count).ToList(); In Sql Server Profiler I can see that the exact same select query is being sent twice. Can someone explain why? Cheers, Dave ...
Hello, 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 query came from. It only has the communication details between the web server and the sql server. Is there ANY way for me (any unknow...
We're running a Citrix farm and I'm trying to track heavy users of our DB, I can get the PID of the process from Sql Profiler but I then need to laboriously search for that PID in each server in the farm - anyone know a better way? ...
We have a big system with several hundred concurrent users so sql profiler gives a bit too much information without appropriate filters. I'd like to see what SQL commands are run under my account and my account only. With account I mean the username I use to log in to the system. These user names are stored in a regular database table an...