CONGRATULATIONS - this is my SQL home - the best site for tools, references and help. Thanks to all who contribute to make this the best SQL site around 😀

It is because the files are ~250GB and it is the fastest way. SQL backups are also performed. We are having discussions about a new platform and changes will be...

SQL service is stopped and restarted every night at 11:00 PM so a snapshot of the datafiles can be backed up. At that time, I had an alert activated to...

Very interesting article, very helpful and clearly written. I just set up a Domain/User to run SQL 2000 on a Win2K server had had to reattach the server to the...

One other thing....the trace started at 10:00 and then again at 12:30 showed results that did not indicated the database was the issue causing the sluggish response. However, the response...

Yesterday was interesting, I was prepared. After all the traces were evaluated, we found that it wasn't the SQL server. There were some report queries that were taking 8 minutes...

Thanks, I have downloaded the SQL 2005 - 2007 version of BoL. I have read online and others agree it is not comprehensive or very helpful on this subject, probably...

I stopped the trace, but what command do you use to close the trace?

To complete the testing, I was able to:

-execute the script to start the trace

-write the trace results to a file on the server where the data/log files are NOT located...

Just so you have all the information I will post the script also:

/****************************************************/

/* Created by: SQL Server Profiler ...

GilaMonster (11/28/2008)

---

Set up a trace in profiler against another server (dev server) with the events you want. Run it for a few moments, stop it, go to the file menu...

Thanks Gail for the instructions on how to create the file with minimal impact. I will test it today and let you know the results.

OK, so select the Save to File and write it to a local share. Do I enable File rollover? Do you have recommendations on what should be the max file...

I am writing the data to a remote server, not the server having the sluggish performance. I hope to have this trace recording for a few minutes only when I...

The table has an ID for EventClass, where profiler display has a name...how does TSQL display the name and what is the ID of deadlock events?

The query below yields 39...