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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
<?xml version="1.0" standalone="yes"?>
<dsConfig
xmlns:pssd="http://tempuri.org"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="SQLDiag_Schema.Xsd">
<Collection setupver="3.0.1.7" casenumber="SRX000000000000">
<Machines>
<Machine name=".">
<MachineCollectors>
<EventlogCollector enabled="false" startup="false" shutdown="true" />
<PerfmonCollector enabled="true" pollinginterval="5" maxfilesize="256">
<PerfmonCounters>
<PerfmonObject name="\PhysicalDisk(*)" enabled="true">
<PerfmonCounter name="\Avg. Disk sec/Read" enabled="true" />
<PerfmonCounter name="\Avg. Disk sec/Write" enabled="true" />
<PerfmonCounter name="\Disk Read Bytes/sec" enabled="true" />
<PerfmonCounter name="\Disk Write Bytes/sec" enabled="true" />
<PerfmonCounter name="\Avg. Disk Bytes/Transfer" enabled="true" />
</PerfmonObject>
<PerfmonObject name="\Processor(*)" enabled="true">
<PerfmonCounter name="\% Processor Time" enabled="true" />
<PerfmonCounter name="\% User Time" enabled="true" />
<PerfmonCounter name="\% Privileged Time" enabled="true" />
</PerfmonObject>
</PerfmonCounters>
</PerfmonCollector>
</MachineCollectors>
<Instances>
<Instance name="*" windowsauth="true" ssver="10" user="">
<Collectors>
<SqldiagCollector enabled="true" startup="false" shutdown="true" />
<BlockingCollector enabled="true" pollinginterval="5" maxfilesize="350"/>
<ProfilerCollector enabled="true" template="_GeneralPerformance90.xml" pollinginterval="5" maxfilesize="350">
<Events>
<EventType name="Database" enabled="true">
<Event id="92" name="Data File Auto Grow" enabled="true" description="Indicates that a data file was extended automatically by the server." />
<Event id="94" name="Data File Auto Shrink" enabled="true" description="Indicates that a data file was shrunk automatically by the server." />
<Event id="167" name="Database Mirroring State Change" enabled="true" description="Occurs when the state of a mirrored database changes." />
<Event id="93" name="Log File Auto Grow" enabled="true" description="Indicates that a data file was extended automatically by the server." />
<Event id="95" name="Log File Auto Shrink" enabled="true" description="Indicates that a log file was shrunk automatically by the server." />
</EventType>
<EventType name="Performance">
<Event id="58" name="Auto Stats" enabled="true" description="Indicates an automatic updating of index statistics has occurred." />
<Event id="28" name="Degree of Parallelism Event (7.0 Insert)" enabled="true" description="Occurs before a SELECT, INSERT, or UPDATE statement is executed. " />
<Event id="165" name="Performance statistics" enabled="false" description="Occurs when a compiled query plan has been cached for the first time, recompiled, or removed from the plan cache." />
<Event id="123" name="SQL:FullTextQuery" enabled="true" description="Occurs when a full text query executes." />
<Event id="97" name="Showplan All" enabled="true" description="Displays the query plan with full compile-time details of the SQL statement executed. Note that the TextData column does not contain the Showplan for this event." />
<Event id="169" name="Showplan All For Query Compile" enabled="true" description="Occurs when an SQL statement compiles. Displays complete, compile-time data. Use to identify Showplan operators." />
<Event id="98" name="Showplan Statistics Profile" enabled="true" description="Displays the query plan with full run-time details of the SQL statement executed. Note that the TextData column does not contain the Showplan for this event." />
<Event id="96" name="Showplan Text" enabled="true" description="Displays the query plan tree of the SQL statement from the query optimizer. Note that the TextData column does not contain the Showplan for this event." />
<Event id="68" name="Showplan Text (Unencoded)" enabled="true" description="Displays the plan tree of the Transact-SQL statement executed." />
<Event id="122" name="Showplan XML" enabled="true" description="Occurs when an SQL statement executes. Include this event to identify Showplan operators. Each event is stored in a well-formed XML document. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan." />
<Event id="168" name="Showplan XML For Query Compile" enabled="true" description="Occurs when an SQL statement executes. Displays the complete, compile-time data. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan." />
<Event id="146" name="Showplan XML Statistics Profile" enabled="true" description="Occurs when an SQL statement executes. Identifies the Showplan operators and displays complete, compile-time data. Note that the Binary column for this event contains the encoded Showplan. Use SQL Server Profiler to open the trace and view the Showplan." />
</EventType>
<EventType name="Stored Procedures">
<Event id="100" name="RPC Output Parameter" enabled="true" description="Produces output values of the parameters for every RPC." />
<Event id="10" name="RPC:Completed" enabled="true" description="Occurs when a remote procedure call (RPC) has completed." />
<Event id="11" name="RPC:Starting" enabled="false" description="Occurs when an RPC has started." />
<Event id="38" name="SP:CacheHit" enabled="false" description="Indicates when a stored procedure is found in the procedure cache." />
<Event id="35" name="SP:CacheInsert" enabled="false" description="Indicates when an item is inserted into the procedure cache." />
<Event id="34" name="SP:CacheMiss" enabled="false" description="Indicates when a stored procedure is not found in the procedure cache." />
<Event id="36" name="SP:CacheRemove" enabled="false" description="Indicates when an item is removed from the procedure cache." />
<Event id="37" name="SP:Recompile" enabled="false" description="Indicates that a stored procedure was recompiled." />
<Event id="43" name="SP:Completed" enabled="false" description="Indicates when the stored procedure has completed." />
<Event id="42" name="SP:Starting" enabled="false" description="Indicates when the stored procedure has started." />
<Event id="45" name="SP:StmtCompleted" enabled="true" description="Indicates that a Transact-SQL statement within a stored procedure has finished executing." />
<Event id="44" name="SP:StmtStarting" enabled="false" description="Indicates that a Transact-SQL statement within a stored procedure has started executing." />
</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="true" 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>
<EventType name="User Configurable" enabled="false">
<Event id="82" name="User Configurable 0" enabled="false" description="Event data defined by the user." />
<Event id="83" name="User Configurable 1" enabled="false" description="Event data defined by the user." />
<Event id="84" name="User Configurable 2" enabled="false" description="Event data defined by the user." />
<Event id="85" name="User Configurable 3" enabled="false" description="Event data defined by the user." />
<Event id="86" name="User Configurable 4" enabled="false" description="Event data defined by the user." />
<Event id="87" name="User Configurable 5" enabled="false" description="Event data defined by the user." />
<Event id="88" name="User Configurable 6" enabled="false" description="Event data defined by the user." />
<Event id="89" name="User Configurable 7" enabled="false" description="Event data defined by the user." />
<Event id="90" name="User Configurable 8" enabled="false" description="Event data defined by the user." />
<Event id="91" name="User Configurable 9" enabled="false" description="Event data defined by the user." />
</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.log" "%output_path%%server%_%instance%_SQLDUMPER_ERRORLOG.log"" />
</CustomDiagnostics>
</Collectors>
</Instance>
</Instances>
</Machine>
</Machines>
</Collection>
<Analysis>
<Producers>
<Producer name="System Info Loader" assembly="BCPLoader.dll" selected="false" />
<Producer name="Blocker Loader" assembly="TextRowsetLoader.dll" selected="false" />
<Producer name="Event Log Loader" assembly="BCPLoader.dll" selected="false" />
<Producer name="SQLDiag Loader" assembly="TextRowsetLoader.dll" selected="false" />
</Producers>
<Analyzers>
<Analyzer name="SQLDiag Analyzer" assembly="BaseAnalyzer.dll" selected="true" />
<Analyzer name="Waitstats Analyzer" assembly="BaseAnalyzer.dll" selected="true" />
<Analyzer name="Corruption Root Cause Analyzer" assembly="HardwareAnalyzer.dll" selected="true" />
<Analyzer name="Blocker Analyzer" assembly="BlockerAnalyzer.dll" selected="true" />
<Analyzer name="Perfmon Analyzer" assembly="BaseAnalyzer.dll" selected="false" />
</Analyzers>
<ViewItems>
</ViewItems>
<Trends>
</Trends>
</Analysis>
</dsConfig> |
SQLSERVER 2008 / SQLDIAG
Répondre avec citation
Envoyé par dbaffaleuf
Partager