I want to create a trace on a database server from my C# app, like what you do in SQL Server Profiler. I have found stored procedures (sys.sp_trace_create etc...) that dont seem to work for my SQL management studio. I was wondering if anyone could help with the coding, or where i would start to do this?! ...
In SQL Server Profile, I have it tracing SP:StmtStarting events. The "TextData" includes information like the following: EXEC MySortedProc @param, NULL, @param2, NULL What would I have to trace (or can I?) to view the value of those parameters? ...
I am wondering if it is possible to see stored procs that are being executed by other stored procs in Sql Server Profiler, is it possible, and if so how? ...
I have a .NET application that is merging two datatables with a lot of rows (10,000+). There is a good chance of having a large number of update/inserts to perform to the SQL table when using the DataAdapter.Update command. Right now, I have the Adapter UpdateBatchSize property set to 200. VS warns against setting this value too high ...
Hi, I'm trying to debug a deadlock with SQL Server Profiler 2008. I know how to get a graph of the deadlock in the profiler, but when I hover over one of the two statements in shown in the graph, the "Statement" tooltip that appears only contains the query with parameter names, not values. In other words I get tooltips like this: DE...
Hi, I'm trying to analyze a deadlock in SQL Server 2008 profiler. I know how to find the offending sql queries, but the collected queries do not include parameter values. I other words I can see something like this: DELETE FROM users WHERE id = @id But what I would like to see is this: DELETE FROM users WHERE id = 12345 I guess...
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 filtered by my SQL login name (it's a name that can uniquely be attributed to my data import process). Strangely enough, most of my SQL statem...
I've got a stored procedure with an int output parameter. If I run SQL Server Profiler, execute the stored procedure via some .Net code, and capture the RPC:Completed event, the TextData looks like this: declare @p1 int set @p1=13 exec spStoredProcedure @OutParam=@p1 output select @p1 Why does it look like it's getting the value of th...
I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO trace_folder FROM::fn_trace_gettable('C:\mytrace.trc', 4) However, this only appears to load the first file, not all four. ...
I have recently been working with a COM+ component that processes an input XML file, and makes a number of database updates based on the supplied data. Running SQL Profiler with EventClass Exception, and User Error Message selected, I see: Exception Error: 102, Severity: 15, State: 1 User Error Message Incorrect syntax near '3'. Ho...
Hello everyone, I am using SQL Server 2008 Enterprise and I want to use SQL Server profiler to capture deadlock event only. And when deadlock occurs and event captured, I will stop SQL Server profiler. My question is, since I launched SQL Server profiler, and before deadlock occur (event captured), any impact (more about performance im...
I've run profiler on sql 2000 database and generated a 3.6 gig trace. Now I'm running this trace into Tunning Advisor (2008r2) and its running for about 3 days and just spilled this error: Tuning process exited unexpectedly. By the way this trace was taken from a sql 2008 r2 x64 to a 32 bit sql 2000 instance, I replaced the database I...
I've been using SQL Server profiler quite frequently to check for redundant or badly performing queries. But is there an event (among the giant list) that allows you to log the total amount of time it takes to transfer the data from the data base to the application? This would be a very good indicator for queries that return way more d...
The title pretty much says it all. Im looking for som testing programs for a firebird db server, to stress-test and find bottlenecks. Something like DB-Optimizer, only for firebird would be nice. Can also be separate programs, one for stress-testing and one for profiling. ...