0
votes
1answer
589 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
119 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
669 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 ...
3
votes
3answers
3k 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 ...
1
vote
1answer
303 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
361 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
782 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 ...