I want to leave sql profiler running all the time logging any queriy that runs for longer than 5 seconds. It's simple enough to start this using the profiler tool on my PC but how do I create it so it runs in the background on the server? ...
I'm running SQL Profiler 2008 on my application to get a better feel for what my application is doing at the DB level. There are some columns in the output that are unclear to me as to what they mean: 1) SPID: I'm using a single connection to the DB to do all my database activity. Yet I see several different SPID values. What does SPID ...
I have setup SQL Profiler as follows - Template: Tuning Save to dbo.myTable Event selection: Duration greater than or equal to 2000 (ms) This will record TextData, Duration, SPID, DatabaseID, DatabaseName, ObjectType, LoginName for the events RPC:Completed, SP:StmtCompleted & SQL:BatchCompleted. I exported the script for the SQL Tra...
The following query works, but its very slow for 10 records (2 seconds). The profiling says its creating a tmp table, but I'm not sure why. Basically, I'm joining the current user, to the acl groups, to get all groups they are in, then joining the groups to the companies, to get all companies they are in, then joining the companies to t...
Is there a quickstart guide on how to configure SQL profiler for SQL 2005? I am using a shared database, so I want to only view queries that are executed by my application. ...
Hi, I'm trying to run a trace with Sql Server Profiler against an Asp.NET Website Application running in Visual Studio development server. However, whenever the trace is running, all db requests from the web application fails giving me the error message: "Timeout expired. The timeout period elapsed prior to completion of the operation...
I have a SQL Server 2005 database with several tables. One of the tables is used to store timestamps and message counters for several devices, and has the following columns: CREATE TABLE [dbo].[Timestamps] ( [Id] [uniqueidentifier] NOT NULL, [MessageCounter] [bigint] NULL, [TimeReceived] [bigint] NULL, [DeviceTime] [bigint] NULL, [Devic...
I try to connect SQL Profiler to my local SQL Server 2008 instance, and get the following error: TITLE: Connect to Server ------------------------------ Cannot connect to (local). ------------------------------ ADDITIONAL INFORMATION: Unknown error. (pfutil) ------------------------------ BUTTONS: OK ------------------------------ ...
I am using LINQ select statement wrapped in a TransactionScope (to change the locking) but according to SQL Profiler, it doesn't seem to be working. My code looks like: using (var ts = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted} )) { using (myDBDataCo...
When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show updates? (I am using Entity Framework, btw, if that might make a difference.) ...
Hi Guys, 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 Done In Previous Query To Log File End Transaction Scope But in the SQL Server profiler I see the following line in the Conne...
I tried "Jet Profiler for MySQL", but I did not like ...