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> |
SQLDIAG ne me donne rien dans la trace TRC
Répondre avec citation
Partager