A tool that reads and analyses event trace information from a database management system.
3
votes
1answer
91 views
Slow SSRS Report in production
I have an SSRS report which gets its data by firing a series of stored procedures.
Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
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 ...
1
vote
0answers
230 views
Is it normal for the SQL Server Profiler SP:StmtCompleted event to give 0 duration?
I'm trying to diagnose a slow running stored procedure in SQL Server.
The procedure is quite long and complicated. I have been trying to figure out which statement is causing the issue.
I have run a ...
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
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
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 ...
0
votes
0answers
80 views
Debugging\Profiling CONTEXT_INFO
i have a problem with CONTEXT_INFO in SQL Server 2008.
My problem is identical to this question: Why is my CONTEXT_INFO() empty?
We use CONTEXT_INFO to store the application user in it and the use ...
