Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 24 Hr Trace

Author  Topic 

runnerpaul
Starting Member

24 Posts

Posted - 2012-03-23 : 04:44:23
I have been asked to run a 24 hour trace to try to identify what is causing a blocking process on my database.

My first concern is that this could use a massive amount of space. I'm also wondering if there will be any performance issues on the server.

Can anybody please advise? I'm not familiar with running traces.

Cheers
Paul
   

- Advertisement -