The tag has no wiki summary.

learn more… | top users | synonyms (2)

2
votes
1answer
1k views

unable to locate trace definition file for microsoft sql server version 10.50.0

I try to create a new trace in sql server profiler. got following error: unable to locate trace definition file for microsoft sql server version 10.50.0 the database I connected to is sql server ...
0
votes
1answer
860 views

Can't install SQL Profiler, it's greyed out in the feature selection list

I got a problem when trying to install Management Tools - Complete on my MSSQL 2008 R2. At the Feature selection screen the Management Tools - Complete is greyed out and can't be interacted with. In ...
0
votes
1answer
32 views

How do I Trace SQL Server 2005 through restarts?

At my company I need to create a Trace on our SQL Server (for a workload file), that should run for several days. However, The Server is turned off every night, so the trace dies. How do I make a ...
0
votes
1answer
800 views

Report Server: login failed to master database

I noticed from the SQL Server log that every time server restarts (I'm using SQL Server 2008 developer edition) I get an error message into log: Login failed for user 'machine\sqlaccount'. Reason: ...
1
vote
1answer
134 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 ...
4
votes
3answers
922 views

Does running the sql server profiler affect performance on the server?

I need to see which indexes I should add to my database so I need to run SQL Server Profiler so I can use it as input for the Database Engine Tuning Advisor. My question is, does the profiler affect ...
1
vote
1answer
53 views

Proper Settings for SQL Server 2005 Profiler User Auditing

I have been tasked with creating a catalog of all users\applications that access a particular database at our company. The issue is that we have no idea what users are using the database and what ...
1
vote
1answer
196 views

Why is SQL Server profiler not capturing Global Temporary Table creation in some cases?

I need to reverse engineer are report from a third party application into SSRS, so that I can make some changes for our users. I have captured the SQL that is used by the report, however the query ...
1
vote
3answers
2k views

How do I properly set up SQL Server Profiler in a production environment?

In our production environment (SQL Server 2008 Enterprise), we've been having issues with CPU usage and network utilization. Based on the specs of the (multiple) machines we have and the general ...
3
votes
3answers
4k views

Deletion of SQL Profiler Trace files (.trc)

We've noticed a lot of .trc files in our SQL data folder (\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) on our server. The date range for these files spans over one day and the total file ...
0
votes
1answer
304 views

Is this a bug in Profiler or Entity Framework?

Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say ...
0
votes
2answers
306 views

SQL Server Profiler and RDP session

does SQL Server Profiler continue to profile also if I close the program and log out from the RDP session? Thank you all for help
1
vote
1answer
3k views

Kill Leaking Connections on SQL Server 2005

We have a legacy ASP application that somewhere leaks SQL Connections. In Activity Monitor, I can see a bunch of idle processes with Last Batch times over an hour old. When I look at the T-SQL ...
1
vote
2answers
284 views

TempDB is Full Issue for SQL Server 2000

Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, ...
2
votes
1answer
2k views

SQL Profiler in Developer Edition

I have SQL Server 2008 Developer Edition. My issue is that SQL Profiler is not installed, I've tried to reinstall it several times. SQL Profiler is not under Tools in SQL Server Management Studio. ...
1
vote
1answer
316 views

Resource consumption on running Deadlock profiler against production database

It is well known that running a profiler consumes a lot of resources depending on what events are being monitored. I am interested in monitoring deadlocks that occurs occasionally (3~5 a week). ...
1
vote
3answers
417 views

Opening Trace in SQL Server Profiler Using Disk Space

I've got a server set up with a smaller c: drive for applications and a huge d: for storage. I've recently run a SQL Server trace using SQL Server Profiler and stored the results to file on the d: ...
3
votes
3answers
3k views

Create an SQL trace without using SQL Profiler

I've read before that its possible to create a SQL profiler trace that records directly to a table without neeing to use the SQL profiler - apparently this is better than having the SQL profiler ...
2
votes
2answers
1k views

Is it possible to track who is running SQL Server Profiler?

Is it possible to see who is running SQL Server Profiler against a certain database and possibly from what machine? Say through Profiler itself or by T-SQL statement. I wonder if it is even possible ...