MARS issue in 2.5.0.5 while loading Trace file

Feb 9, 2009 at 4:05 PM
02/09/09 10:54:38.108 [4680] Attempting to cleanup existing RML files from previous execution
02/09/09 10:54:38.108 [4680] Using extended RowsetFastload synchronization
02/09/09 10:54:38.108 [4680] Establishing initial database connection:
02/09/09 10:54:38.108 [4680] Server: esys-qa-vsql\qa_esys_2k5
02/09/09 10:54:38.108 [4680] Database: sqlnexus
02/09/09 10:54:38.108 [4680] Authentication: Windows
02/09/09 10:54:38.342 [4680] Creating or clearing the performance database
02/09/09 10:54:39.030 [4680] Processing file: F:\PerfStats\Save\SQLDiagOutput_LPI\Esys-QA-VSQL_QA_ESYS_2K5_sp_trace.trc (SQL 2005)
02/09/09 10:54:39.030 [4680] Validating core events exist
02/09/09 10:54:39.030 [4680] Validating necessary events exist for analysis
02/09/09 10:54:39.030 [4680] WARNING: The following trace events were not captured: [SP:StmtStarting, SP:StmtCompleted, Showplan Statistics]. Review the help file to ensure that you have collected the appropriate set of events and columns for your intended analysis.
02/09/09 10:54:39.092 [4680] Events Read: 1000 Queued: 1000 Processed/sec: 0
02/09/09 10:54:39.530 [4680] ERROR: SPID was detected using Multiple Active Result Sets (MARS).  ReadTrace can only process this set of trace files with -T35 enabled
02/09/09 10:54:39.530 [4680] ***************************************************************
02/09/09 10:54:39.530 [4680] WARNING: [SPID: 0] Disabling aggregation operations.
02/09/09 10:54:39.530 [4680] ***************************************************************
02/09/09 10:54:39.530 [4680] ERROR: All output types have been disabled, shutting down.
02/09/09 10:54:39.670 [4680] *** ERROR: Error encountered with operating system error 0x80004005 (Unspecified error) State: 0
02/09/09 10:54:39.686 [4680] Reads completed - Global Error Status 0xffffffea
02/09/09 10:54:39.686 [4680] Shutting down the worker thread message queues.
02/09/09 10:54:39.686 [4680] Waiting for the worker threads to complete final actions.
02/09/09 10:54:39.873 [4680] Total Events Processed: 1880
02/09/09 10:54:39.873 [4680]  Total Events Filtered: 2
02/09/09 10:54:39.889 [4680] Parse errors: 0
Feb 9, 2009 at 4:26 PM

Please disregard.  I found the issue

  Problem: Trace files not processing.

 

  Diagnosis:

1.       In SQL Nexus look at Open Nexus Log.  (Currently this feature is only on )

a.       Look for ERROR: SPID was detected using Multiple Active Result Sets (MARS).  ReadTrace can only process this set of trace files with -T35 enabled

 

 Solution:

1.       In SQL Nexus

a.       Click on Import in the Data Box

                                                                           i.      In the bottom left corner click on Options

1.       Importers > ReadTrace (SQL Profiler TRC File) > Enabled -T35 to support MARs

a.       Make sure the Enabled -T35 to support MARs is checked