SQL Trace

Question

SQL Trace

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
September 11, 2008 at 12:39 am

#63531

Comments posted to this topic are about the item SQL Trace

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jim SSCrazy Eights Points: 8720 More actions · Answer 1

Preface: I answered the question correctly but...

I understand that all events are guaranteed to be captured. However, even if the event IS captured but a write error occurs, in my mind, the event is lost. Same thought comes to mind with writing data to the database. SQL Server may have captured the transaction but if a write error occurs writing that transaction to the database, the data IS lost.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

Jim

Agree with you there. I was surprised to learn this, but I also wouldn't want my instance stopping because of tracing. The data is lost, perhaps there should be some alerting to notify the admin if space is an issue?

Jim SSCrazy Eights Points: 8720 More actions · Answer 3

I would add write errors to that notification as that could signify something else on the horizon.

dmoldovan SSCertifiable Points: 6334 More actions · Answer 4

Indeed I/O can be a problem, even if everithing is captued, see also

http://sqlcat.com/technicalnotes/archive/2008/02/01/precision-performance-for-microsoft-sql-server-using-rml-utilities-9-0.aspx

Vivien Xing SSChampion Points: 12297 More actions · Answer 5

Is the question clear?

"...can events be lost if you have disk space?" or "...can events be lost if you have disk space PROBLEM?"

This is not only for SQL2008 but also for SQL2005. Not sure whether it is for SQL2000.