Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Trace Expand / Collapse
Author
Message
Posted Thursday, September 11, 2008 12:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:20 PM
Points: 33,078, Visits: 15,191
Comments posted to this topic are about the item SQL Trace






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #567497
Posted Thursday, September 11, 2008 7:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 26, 2014 6:11 AM
Points: 1,330, Visits: 815
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.
Post #567722
Posted Thursday, September 11, 2008 8:45 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:20 PM
Points: 33,078, Visits: 15,191
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?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #567807
Posted Thursday, September 11, 2008 9:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 26, 2014 6:11 AM
Points: 1,330, Visits: 815
I would add write errors to that notification as that could signify something else on the horizon.
Post #567857
Posted Thursday, September 11, 2008 3:43 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 5:31 AM
Points: 363, Visits: 1,317
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
Post #568173
Posted Thursday, September 11, 2008 10:34 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,279, Visits: 2,203
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.
Post #568249
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse