SQLDIAG ne me donne rien dans la trace TRC
Bonjour
J'ai des problèmes ce matin avec les compteurs en français dans Sqldiag et je pensais que le reste aller rouler sans problème.
Et bien non !
Malgré un fichier XML assez classique pour les évenements SQL, je n'ai rien dans ma trace, juste un TRACE start, TRACE stop
des idées?
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
| <?xml version="1.0" standalone="yes"?>
<dsConfig>
<Collection setupver="3.0.1.7" casenumber="SRX000000000000">
<Machines>
<Machine name=".">
<MachineCollectors>
<EventlogCollector enabled="false" startup="false" shutdown="true" >
<Eventlogs>
<EventlogType name="Application" enabled="true"/>
<EventlogType name="Security" enabled="true"/>
<EventlogType name="System" enabled="true"/>
</Eventlogs>
</EventlogCollector>
<PerfmonCollector enabled="true" pollinginterval="30" maxfilesize="256">
<PerfmonCounters>
<PerfmonObject name="\Disque physique(_Total)" enabled="true">
<PerfmonCounter name="\Pourcentage du temps de lecture du disque" enabled="true" />
</PerfmonObject>
<PerfmonObject name="\Processeur(_Total)" enabled="true">
<PerfmonCounter name="\% temps processeur" enabled="true" />
</PerfmonObject>
<PerfmonObject name="\MSSQL$X3:Buffer Manager" enabled="true">
<PerfmonCounter name="\Buffer cache hit ratio" enabled="true" />
<PerfmonCounter name="\Page life expectancy" enabled="true" />
</PerfmonObject>
</PerfmonCounters>
</PerfmonCollector>
</MachineCollectors>
<Instances>
<Instance name="*" windowsauth="true" ssver="10" user="">
<Collectors>
<SqldiagCollector enabled="true" startup="false" shutdown="true" />
<BlockingCollector enabled="false" pollinginterval="5" maxfilesize="350" filecount="1"/>
<ProfilerCollector enabled="true" template="_GeneralPerformance90.xml" pollinginterval="5" maxfilesize="350" filecount="1">
<Events>
<EventType name="Locks">
<Event id="148" name="Deadlock Graph" enabled="true" description="Occurs when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim. Provides an XML description of a deadlock." />
<Event id="24" name="Lock:Acquired" enabled="false" description="Indicates acquisition of a lock on a resource, such as a data page." />
<Event id="23" name="Lock:Released" enabled="false" description="Indicates that a lock on a resource, such as a page, has been released." />
<Event id="26" name="Lock:Cancel" enabled="false" description="Indicates that the acquisition of a lock on a resource has been canceled (for example, due to a deadlock)." />
<Event id="25" name="Lock:Deadlock" enabled="false" description="Indicates that two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources the other transaction owns. " />
<Event id="59" name="Lock:Deadlock Chain" enabled="false" description="Produced for each of the events leading up to the deadlock." />
<Event id="60" name="Lock:Escalation" enabled="true" description="Indicates that a finer-grained lock has been converted to a coarser-grained lock (for example, a page lock escalated or converted to a table lock)." />
<Event id="27" name="Lock:Timeout" enabled="false" description="Indicates that a request for a lock on a resource, such as a page, has timed out due to another transaction holding a blocking lock on the required resource. Time-out is determined by the @@LOCK_TIMEOUT function, and can be set with the SET LOCK_TIMEOUT statement. " />
<Event id="189" name="Lock:Timeout (timeout > 0)" enabled="true" description="Occurs when a request for a lock on a resource, such as a page, times out." />
</EventType>
<EventType name="TSQL">
<Event id="12" name="SQL:BatchCompleted" enabled="false" description="Occurs when a Transact-SQL batch has completed." />
<Event id="13" name="SQL:BatchStarting" enabled="false" description="Occurs when a Transact-SQL batch has started." />
<Event id="40" name="SQL:StmtStarting" enabled="false" description="Occurs when the Transact-SQL statement has started." />
<Event id="41" name="SQL:StmtCompleted" enabled="false" description="Occurs when the Transact-SQL statement has completed." />
<Event id="71" name="Prepare SQL" enabled="false" description="ODBC, OLE DB, or DB-Library has prepared a Transact-SQL statement or statements for use." />
<Event id="72" name="Exec Prepared SQL" enabled="false" description="ODBC, OLE DB, or DB-Library has executed a prepared Transact-SQL statement or statements." />
<Event id="73" name="Unprepare SQL" enabled="false" description="ODBC, OLE DB, or DB-Library has unprepared (deleted) a prepared Transact-SQL statement or statements." />
<Event id="166" name="SQL:StmtRecompile" enabled="false" description="Occurs when a statement-level recompilation occurs." />
<Event id="198" name="XQuery Static Type" enabled="false" description="Occurs when an XQuery expression is executed. This event class provides the static type of the XQuery expression." />
</EventType>
<EventType name="Transactions">
<Event id="19" name="DTCTransaction" enabled="false" description="Tracks Microsoft Distributed Transaction Coordinator (MS DTC) coordinated transactions between two or more databases." />
<Event id="50" name="SQL Transaction" enabled="false" description="Tracks Transact-SQL BEGIN, COMMIT, SAVE, and ROLLBACK TRANSACTION statements." />
<Event id="181" name="TM: Begin Tran starting" enabled="false" description="Occurs when a BEGIN TRANSACTION request starts." />
<Event id="182" name="TM: Begin Tran completed" enabled="false" description="Occurs when a BEGIN TRANSACTION request completes." />
<Event id="183" name="TM: Promote Tran starting" enabled="false" description="Occurs when a PROMOTE TRANSACTION request starts." />
<Event id="184" name="TM: Promote Tran completed" enabled="false" description="Occurs when a PROMOTE TRANSACTION request completes." />
<Event id="185" name="TM: Commit Tran starting" enabled="false" description="Occurs when a COMMIT TRANSACTION request starts." />
<Event id="186" name="TM: Commit Tran completed" enabled="false" description="Occurs when a COMMIT TRANSACTION request completes." />
<Event id="187" name="TM: Rollback Tran starting" enabled="false" description="Occurs when a ROLLBACK TRANSACTION request starts." />
<Event id="188" name="TM: Rollback Tran completed" enabled="false" description="Occurs when a ROLLBACK TRANSACTION request completes." />
<Event id="191" name="TM: Save Tran starting" enabled="false" description="Occurs when a SAVE TRANSACTION request starts." />
<Event id="192" name="TM: Save Tran completed" enabled="false" description="Occurs when a SAVE TRANSACTION request completes." />
<Event id="54" name="TransactionLog" enabled="false" description="Tracks when transactions are written to the transaction log." />
</EventType>
</Events>
</ProfilerCollector>
<CustomDiagnostics>
<CustomGroup name="msinfo" enabled="true" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get MSINFO32" type="Utility" point="Startup" wait="OnlyOnShutdown" cmd="start /B /WAIT MSInfo32.exe /computer %server% /report "%output_path%%server%_MSINFO32.TXT" /categories +SystemSummary+ResourcesConflicts+ResourcesIRQS+ComponentsNetwork+ComponentsStorage+ComponentsProblemDevices+SWEnvEnvVars+SWEnvNetConn+SWEnvServices+SWEnvProgramGroup+SWEnvStartupPrograms" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get default traces" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd=""%sspath%log\log*.trc" "%output_path%"" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get SQLDumper log" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd=""%sspath%log\SQLDUMPER_ERRORLOG*.*" "%output_path%"" />
</CustomDiagnostics>
</Collectors>
</Instance>
</Instances>
</Machine>
</Machines>
</Collection>
</dsConfig> |
