2
votes
1answer
797 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
688 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
653 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: ...
4
votes
3answers
736 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
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 ...
0
votes
1answer
284 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 ...
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. ...
2
votes
2answers
902 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 ...