Tagged Questions

0
votes
0answers
43 views

sql server 2005 profiler

We have a overnight agent job and one of the steps runs particular slow recently. The step calls a stored procedure. I used sql server profiler to capture the trace for that proc into a table. I ...
0
votes
0answers
33 views

Email alerts and Server Side Tracing

This question is in regards to SQL 2005 and email alerts on long running queries. Does this sound like the best approach (with the least impact to the server) to receiving alerts to long running ...
4
votes
3answers
416 views

Logging query text without Profiler

I'm in the process of porting an old, semi-broken ASP.NET/SQL Server application to PHP/PostgreSQL. Among the torments^H^H^H^H^H^H^H^Hchallenges I'm faced with is that the reporting is done by a ...
2
votes
0answers
87 views

Lock timeout on user tables traced back to system processes

I have a problem where users are reporting intermittent errors in an application that is using a SQL Server 2005 database. Nothing jumped out at me at first glance so I took a look at ...
4
votes
3answers
950 views

How to see the value of a variable being used in an sql statement during a server trace?

I have a stored procedure which has SQL statements that take variables. For example, update customer set cust_id = @newcust_id where issuedate < @transferdate and cust_id = @oldcust_id The ...
1
vote
1answer
78 views

sql 2005 - trace capturing all events

I am trying to capture all statements/SPs and RPCs (either they finish or fail) on a SQL 2005 server using SQL trace. Are the following events enough? Exceptions Stored Procedure RPC:Completed ...
4
votes
1answer
812 views

SQL Profiler - Scripting a trace with HostName filter

I have a stock of scripted trace definitions that I use for different levels of diagnostics, none of which filter by HostName. I needed to filter traffic by host today so: Fired up Profiler Created ...
3
votes
4answers
296 views

what is hitting your db?

What is a quick way of finding out what is hitting your database especially when the log files are going crazy. SQL profiler? If so, how?