Tagged Questions

3
votes
1answer
54 views

CPU column 5x higher on one machine vs another?

We're running into a strange issue in a deployed version of our product where the performance is just not very good. When we restore a backup of their DB on one of our machines, it performs as we ...
0
votes
2answers
55 views

Server side trace to database

How can I set up a server side trace that dumps to a database instead of a trace file? I set-up and tested a trace configuration I want with Sql Server Profiler that dumps only needed info straight ...
3
votes
1answer
89 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 ...
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 ...
1
vote
2answers
62 views

SQL Server Profiler 2005 on remote SQL Server 2008 Express?

Is it able to trace remote SQL Server 2008 using SQL Profiler 2005? If yes, anyone knows what else should I do, if during loging in appeares this message "Unable to locate trace definition file for ...
5
votes
1answer
93 views

Query in procedure occasionally does not finish

I have a question about how to debug very strange behavior (nested query getting stuck) in SQL Server 2008 R2 (Standard Edition) running a query. Sometimes (unfortunately not always) when I run a ...
3
votes
1answer
160 views

Profiler TextData output is null

I am doing a trace on a database and dumping the trace realtime into a table. The reason I'm doing a trace is I want to see all the queries that are being executed against the database. ...
2
votes
1answer
67 views

SQL Server Profiler behavior?

I want to monitor only sp's. Does SQL Server Profiler listen to all events and then filters the desired data (e.g. sp's)? Or rather the sql emits only Profiler pre-configured events ?
4
votes
3answers
399 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 ...
11
votes
1answer
203 views

Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?

Using SQL Server Profiler (I'm on SQL Server 2012), I'm trying to generate a useful trace that shows the parameter values, not just the SQL with variable names. The stored procedure walks through a ...
2
votes
1answer
388 views

Finding exact statement causing error 3930

Lately I've been seeing errors in the SQL Server Log. Code:3930 Description:"The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the ...
2
votes
3answers
4k views

Download SQL Server profiler for SQL Server Management Studio

How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio ...
3
votes
1answer
115 views

How can I change the target server type for a trace template?

I've got a .tdf SQL Server Profiler trace template someone wants me to run but the template is targeting SS 2008 R2. While my SSMS is 2008 R2 the server I need to trace is SS 2005. When attempting 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 ...
3
votes
5answers
712 views

Does SQL profiler affect server performance?

I am facing a problem where the sql server 2008 fails for some high load. I need to find that load case and need to optimize the code so that it can handle the load. I have found on the internet that ...
2
votes
1answer
94 views

Profiler: Only want to see Provider Errors

I'm replaying a trace in Profiler, and I'd like to only see the Provider Errors. Granted, there are ~30,000 of them but I'm not concerned at the moment about row update conflicts, foreign key or ...
2
votes
2answers
326 views

SQL Server Profiler is available for SQL Server 2008 Dev Edition?

I just upgrade from SQL Server 2008 Express with advance services to Dev Edition. I wonder whether SQL Profiler is available for the Dev Edition? Please let me know how to access that if it is ...
0
votes
1answer
425 views

SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”

Yesterday i ran the "SQL Server Profiler" tool and outputted the data to a table, now when i look in it i find many "exec sp_reset_connection" rows and thats expected with our data access layer! But ...
2
votes
1answer
209 views

SQL Server 2008 R2 DETA Error: Can not get minimal database information in allotted time

I have a 18,6 GB SQL Server 2008 R2 profiler trace file. Trace file recorded at tuning profile. When I submit this trace file to database engine tuning advisor I get this error: Error: Can not get ...
2
votes
1answer
80 views

How to get SQL Server Profiler to show amended tables

The ASP.Net application I'm maintaining at the moment has a lot of activity in the database when ever a postback occurs. For the example I'm currently looking at, Profiler shows a mass of activity ...
0
votes
1answer
170 views

Running a sql server Trace of 1 GB using sqlcmd

I am load testing two sql server instances. I have a trace file from sql server 2000 database with a file size of little less than 1 GB. I am running this using the sqlcmd utility and it is been ...
7
votes
1answer
936 views

When should extended events be used instead of SQL Profiler/perfmon?

The extended events seem like a better technology and less stress on the server, but the SQL Profiler/perfmon has better tooling. Also the extended events seem to have a steeper learning curve. In ...
12
votes
3answers
3k views

Using SQL Profiler on a database that's in production

As a developer, I use SQL Profiler quite often. It's a good debugging tool, both to track what my code is doing and to analyse performance problems. But I've always used it on my development ...