SQLSERVER 2008 / SQLDIAG

Version imprimable

29/03/2010, 17h32
zinzineti

SQLSERVER 2008 / SQLDIAG

Bonjour tout le monde !
J’ai collecté des infos de performance avec SQLDIAG sur une instance SQL SERVER 2005 SP2 et ça marche nickel ! j’arrive donc à mettre en perspective les infos du performance monitor (fichier .BLG) et les traces SQLTRACE (fichier …__sp_trace.trc). jusque là aucun problème.

J’ai donc copié le fichier de configuration (mySQLDIAG.xml) pour exécuter le SQLDIAG sur mon instance SQLSERVER 2008 SP0. J’ai pris soins de modifier dans mon fichier de config (mySQLDIAG.xml) la balise <Instance name="*" windowsauth="true" ssver="10" user="">
pour prendre en compte la version 10 (SQLSERVER 2008) au lieu de 9 (SQLSERVER2005). Lors du lancement de la commande
sqldiag /I E:\traceSQLDIAG\mySQLDIAG.xml /O E:\TraceSQLDIAG\testToday j’ai cette erreur :

2010/03/29 16:50:33.18 TESTBED_ZINZINDOHOUE\* Error updating perfmon log . Function result: -2147481643. Message: Aucune donnée à renvoyer.

Auriez-vous une idée sur cette erreur ?

Merci d'avance
29/03/2010, 18h03
dbaffaleuf

Hello Etienne,

J'ai bien reproduit ton problème. Je suis dessus, il n'y a aucune référence dans la kb MS pour ce problème mais je subodore une vieille erreur de syntaxe, ou qq chose comme ça.

Je te tiens au courant.

David B.
29/03/2010, 18h53
dbaffaleuf

Re-,

Il faudrait nous poster le contenu du fichier XML s'il n'est pas trop volumineux.

merci,

David B.

Contenu mySQLDIAG.xml

[quote=dbaffaleuf;5098940]Re-,

Il faudrait nous poster le contenu du fichier XML s'il n'est pas trop volumineux.

merci,

David B.

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
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 &quot;%output_path%%server%_MSINFO32.TXT&quot; /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="&quot;%sspath%log\log*.trc&quot; &quot;%output_path%&quot;" />
                                <CustomTask enabled="true" groupname="MsInfo" taskname="Get SQLDumper log" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd="&quot;%sspath%log\SQLDUMPER_ERRORLOG.log&quot; &quot;%output_path%%server%_%instance%_SQLDUMPER_ERRORLOG.log&quot;" />
                            </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>

30/03/2010, 18h23
dbaffaleuf

1 pièce(s) jointe(s)

Merci,

J'ai quelques pistes mais pour l'instant c'est assez flou. Dans ma repro je vois un SHARING VIOLATION sur une réouverture du fichier BLG (cf pièce jointe).

Pour l'instant le seul contournement que j'ai trouvé est d'insérer un PerfmonObject bidon:

Citation:

<PerfmonObject name="\MSSQL$%s:User Settable(*)" enabled="false">
<PerfmonCounter name="\*" enabled="false" />
<PerfmonCounter name="\Query" enabled="true" />
</PerfmonObject>

Tu peux toujours essayer ça. Je voudrais tester le binaire avec le dernier niveau de patch avant d'ouvrir une demande sur Connect.

A+ David B.
30/03/2010, 22h03
zinzineti

PerfmonCounters

Citation:

Envoyé par dbaffaleuf

Merci,

J'ai quelques pistes mais pour l'instant c'est assez flou. Dans ma repro je vois un SHARING VIOLATION sur une réouverture du fichier BLG (cf pièce jointe).

Pour l'instant le seul contournement que j'ai trouvé est d'insérer un PerfmonObject bidon:

Tu peux toujours essayer ça. Je voudrais tester le binaire avec le dernier niveau de patch avant d'ouvrir une demande sur Connect.

A+ David B.

David,
Il me semble que l'anomalie provient des compteurs PerfmonCounters.
car lorsque TOUS les PerfmonCounters sont Disenabled c'est à dire Enabled=false
ou simplement PerfmonCollector enabled=false SQLDIAG se lance sans erreur mais rien n'est collecté du côté des compteurs Perfmon

Citation:

Envoyé par zinzineti

David,
Il me semble que l'anomalie provient des compteurs PerfmonCounters.
car lorsque TOUS les PerfmonCounters sont Disenabled c'est à dire Enabled=false
ou simplement PerfmonCollector enabled=false SQLDIAG se lance sans erreur mais rien n'est collecté du côté des compteurs Perfmon

ça marche maintenant ! mais je continue de chercher l'explication de cette anomalie.

Voici le fichier de config qui marche sous SQL SERVER 2008 :

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
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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<?xml version="1.0" standalone="yes"?>
<dsConfig>
<Collection setupver="3.0.1.7" casenumber="SRX000000000000">
    <Machines>
      <Machine name=".">
        <MachineCollectors>
          <EventlogCollector enabled="true" startup="false" shutdown="true" />
          <PerfmonCollector enabled="true" pollinginterval="5" maxfilesize="256">
            <PerfmonCounters>
			<PerfmonObject name="\PhysicalDisk(*)" enabled="true">
			<PerfmonCounter name="\Current Disk Queue Length" enabled="true" />
			<PerfmonCounter name="\% Disk Time" enabled="true" />
			<PerfmonCounter name="\Avg. Disk Queue Length" enabled="true" />
			<PerfmonCounter name="\% Disk Read Time" enabled="true" />
			<PerfmonCounter name="\Avg. Disk Read Queue Length" enabled="true" />
			<PerfmonCounter name="\% Disk Write Time" enabled="true" />
			<PerfmonCounter name="\Avg. Disk Write Queue Length" enabled="true" />
			<PerfmonCounter name="\Avg. Disk sec/Transfer" enabled="true" />
			<PerfmonCounter name="\Avg. Disk sec/Read" enabled="true" />
			<PerfmonCounter name="\Avg. Disk sec/Write" enabled="true" />
			<PerfmonCounter name="\Disk Transfers/sec" enabled="true" />
			<PerfmonCounter name="\Disk Reads/sec" enabled="true" />
			<PerfmonCounter name="\Disk Writes/sec" enabled="true" />
			<PerfmonCounter name="\Disk Bytes/sec" 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" />
			<PerfmonCounter name="\Avg. Disk Bytes/Read" enabled="true" />
			<PerfmonCounter name="\Avg. Disk Bytes/Write" enabled="true" />
			<PerfmonCounter name="\% Idle Time" enabled="true" />
			<PerfmonCounter name="\Split IO/Sec" enabled="true" />
			</PerfmonObject>
			<PerfmonObject name="\MSSQL$%s:Buffer Manager" enabled="true">
                <PerfmonCounter name="\Buffer cache hit ratio" enabled="true" />
                <PerfmonCounter name="\Buffer cache hit ratio base" enabled="true" />
                <PerfmonCounter name="\Page lookups/sec" enabled="true" />
                <PerfmonCounter name="\Free list stalls/sec" enabled="true" />
                <PerfmonCounter name="\Free pages" enabled="true" />
                <PerfmonCounter name="\Total pages" enabled="true" />
                <PerfmonCounter name="\Target pages" enabled="true" />
                <PerfmonCounter name="\Database pages" enabled="true" />
                <PerfmonCounter name="\Reserved pages" enabled="true" />
                <PerfmonCounter name="\Stolen pages" enabled="true" />
                <PerfmonCounter name="\Lazy writes/sec" enabled="true" />
                <PerfmonCounter name="\Readahead pages/sec" enabled="true" />
                <PerfmonCounter name="\Procedure cache pages" enabled="true" />
                <PerfmonCounter name="\Page reads/sec" enabled="true" />
                <PerfmonCounter name="\Page writes/sec" enabled="true" />
                <PerfmonCounter name="\Checkpoint pages/sec" enabled="true" />
                <PerfmonCounter name="\AWE lookup maps/sec" enabled="true" />
                <PerfmonCounter name="\AWE stolen maps/sec" enabled="true" />
                <PerfmonCounter name="\AWE write maps/sec" enabled="true" />
                <PerfmonCounter name="\AWE unmap calls/sec" enabled="true" />
                <PerfmonCounter name="\AWE unmap pages/sec" 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="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 &quot;%output_path%%server%_MSINFO32.TXT&quot; /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="&quot;%sspath%log\log*.trc&quot; &quot;%output_path%&quot;" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get SQLDumper log" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd="&quot;%sspath%log\SQLDUMPER_ERRORLOG.log&quot; &quot;%output_path%%server%_%instance%_SQLDUMPER_ERRORLOG.log&quot;" />
</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>

OK j'ai mis la réponse sur le blog mais je la rajoute ici: c'est une histoire de langue.
...
Tu peux voir tout simplement dans la log de perfmon (le fichier ##SQLDIAG.LOG):
Code:

1 2 2010/03/31 11:07:48.00 MS2K-2K5-WIN200\* Could not add counter: \\MS2K-2K5-WIN200\PhysicalDisk(*)\Current Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système.
En effet le nom du compteur est en français, je n'avais pas précisé sur l'article mais tous les tests se font en ENU. Pour connaître le nom exact des compteurs:
Code:

1 2 3 4 5 6 7 8 $ typeperf -qx | findstr "physique" | more \Disque logique(C:)\% espace libre \Disque logique(E:)\% espace libre \Disque logique(F:)\% espace libre \Disque logique(G:)\% espace libre \Disque logique(_Total)\% espace libre \Disque logique(C:)\M'gaoctets libres (...)
A+ David B.

Citation:

Envoyé par dbaffaleuf

OK j'ai mis la réponse sur le blog mais je la rajoute ici: c'est une histoire de langue.
...
Tu peux voir tout simplement dans la log de perfmon (le fichier ##SQLDIAG.LOG):

Code:

1
2
 
2010/03/31 11:07:48.00 MS2K-2K5-WIN200\* Could not add counter: \\MS2K-2K5-WIN200\PhysicalDisk(*)\Current Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système.

En effet le nom du compteur est en français, je n'avais pas précisé sur l'article mais tous les tests se font en ENU. Pour connaître le nom exact des compteurs:

Code:

1
2
3
4
5
6
7
8
$ typeperf -qx | findstr  "physique" | more
\Disque logique(C:)\% espace libre
\Disque logique(E:)\% espace libre
\Disque logique(F:)\% espace libre
\Disque logique(G:)\% espace libre
\Disque logique(_Total)\% espace libre
\Disque logique(C:)\M'gaoctets libres
(...)

A+ David B.

Je suis sous Windows XP Pro (FR) SP3
Et mon fichier de config ci-dessous marche bien.
Et pourtant il contient la balise.

Code:

<PerfmonObject name="\PhysicalDisk(*)" enabled="true">

Il me semble que l'explication n'est pas à ce niveau. Je continue de chercher la cause de l'erreur renvoyée. Sinon le fichier de config ci-dessous marche très bien

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
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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
 
<?xml version="1.0" standalone="yes"?>
<dsConfig>
<Collection setupver="3.0.1.7" casenumber="SRX000000000000">
<Machines>
<Machine name=".">
<MachineCollectors>
<EventlogCollector enabled="true" startup="false" shutdown="true" />
<PerfmonCollector enabled="true" pollinginterval="5" maxfilesize="256">
<PerfmonCounters>
<PerfmonObject name="\PhysicalDisk(*)" enabled="true">
<PerfmonCounter name="\Current Disk Queue Length" enabled="true" />
<PerfmonCounter name="\% Disk Time" enabled="true" />
<PerfmonCounter name="\Avg. Disk Queue Length" enabled="true" />
<PerfmonCounter name="\% Disk Read Time" enabled="true" />
<PerfmonCounter name="\Avg. Disk Read Queue Length" enabled="true" />
<PerfmonCounter name="\% Disk Write Time" enabled="true" />
<PerfmonCounter name="\Avg. Disk Write Queue Length" enabled="true" />
<PerfmonCounter name="\Avg. Disk sec/Transfer" enabled="true" />
<PerfmonCounter name="\Avg. Disk sec/Read" enabled="true" />
<PerfmonCounter name="\Avg. Disk sec/Write" enabled="true" />
<PerfmonCounter name="\Disk Transfers/sec" enabled="true" />
<PerfmonCounter name="\Disk Reads/sec" enabled="true" />
<PerfmonCounter name="\Disk Writes/sec" enabled="true" />
<PerfmonCounter name="\Disk Bytes/sec" 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" />
<PerfmonCounter name="\Avg. Disk Bytes/Read" enabled="true" />
<PerfmonCounter name="\Avg. Disk Bytes/Write" enabled="true" />
<PerfmonCounter name="\% Idle Time" enabled="true" />
<PerfmonCounter name="\Split IO/Sec" enabled="true" />
</PerfmonObject>
<PerfmonObject name="\MSSQL$%s:Buffer Manager" enabled="true">
<PerfmonCounter name="\Buffer cache hit ratio" enabled="true" />
<PerfmonCounter name="\Buffer cache hit ratio base" enabled="true" />
<PerfmonCounter name="\Page lookups/sec" enabled="true" />
<PerfmonCounter name="\Free list stalls/sec" enabled="true" />
<PerfmonCounter name="\Free pages" enabled="true" />
<PerfmonCounter name="\Total pages" enabled="true" />
<PerfmonCounter name="\Target pages" enabled="true" />
<PerfmonCounter name="\Database pages" enabled="true" />
<PerfmonCounter name="\Reserved pages" enabled="true" />
<PerfmonCounter name="\Stolen pages" enabled="true" />
<PerfmonCounter name="\Lazy writes/sec" enabled="true" />
<PerfmonCounter name="\Readahead pages/sec" enabled="true" />
<PerfmonCounter name="\Procedure cache pages" enabled="true" />
<PerfmonCounter name="\Page reads/sec" enabled="true" />
<PerfmonCounter name="\Page writes/sec" enabled="true" />
<PerfmonCounter name="\Checkpoint pages/sec" enabled="true" />
<PerfmonCounter name="\AWE lookup maps/sec" enabled="true" />
<PerfmonCounter name="\AWE stolen maps/sec" enabled="true" />
<PerfmonCounter name="\AWE write maps/sec" enabled="true" />
<PerfmonCounter name="\AWE unmap calls/sec" enabled="true" />
<PerfmonCounter name="\AWE unmap pages/sec" 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="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 &quot;%output_path%%server%_MSINFO32.TXT&quot; /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="&quot;%sspath%log\log*.trc&quot; &quot;%output_path%&quot;" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get SQLDumper log" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd="&quot;%sspath%log\SQLDUMPER_ERRORLOG.log&quot; &quot;%output_path%%server%_%instance%_SQLDUMPER_ERRORLOG.log&quot;" />
</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>

A+

Etienne

31/03/2010, 17h04
dbaffaleuf

Etienne,

Postes-nous le contenu du fichier ##SQLDIAG.LOG lorsque l'erreur se produit.

merci

David B.

Citation:

Envoyé par dbaffaleuf

Etienne,

Postes-nous le contenu du fichier ##SQLDIAG.LOG lorsque l'erreur se produit.

merci

David B.

##SQLDIAG.LOG en cas d'erreur

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
 
2010/03/31 17:26:37.12 SQLDIAG Command line parameter sqldiag 
2010/03/31 17:26:37.12 SQLDIAG Command line parameter /I 
2010/03/31 17:26:37.12 SQLDIAG Command line parameter E:\traceSQLDIAG\EZ_SQLDIAG6.xml 
2010/03/31 17:26:37.12 SQLDIAG Command line parameter /O 
2010/03/31 17:26:37.12 SQLDIAG Command line parameter E:\TraceSQLDIAG\testToday7 
2010/03/31 17:26:37.12 SQLDIAG Collector version  
2010/03/31 17:26:37.12 SQLDIAG 
IMPORTANT:  Please wait until you see "Collection started" before attempting to reproduce your issue 
2010/03/31 17:26:37.12 SQLDIAG Output path: E:\TraceSQLDIAG\testToday7\ 
2010/03/31 17:26:37.16 SQLDIAG Collecting from 1 logical machine(s) 
2010/03/31 17:26:37.18 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:26:37.18 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:26:37.18 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:26:37.18 SQLDIAG Invalid node fetched. (null) 
2010/03/31 17:26:37.18 SQLDIAG Invalid node fetched. (null) 
2010/03/31 17:26:37.21 DPAW-ZINZINDOHU\* SQL Server version: 10 
2010/03/31 17:26:37.21 DPAW-ZINZINDOHU\* Machine name: DPAW-ZINZINDOHU (this machine)  
2010/03/31 17:26:37.21 DPAW-ZINZINDOHU\* Target machine is not a cluster 
2010/03/31 17:26:37.21 DPAW-ZINZINDOHU\* Instance: (Default) (32-bit) 
2010/03/31 17:26:39.16 SQLDIAG Initialization starting... 
2010/03/31 17:26:40.59 DPAW-ZINZINDOHU\* Starting Profiler trace 
2010/03/31 17:26:41.18 DPAW-ZINZINDOHU\* Starting Blocking script 
2010/03/31 17:26:42.07 DPAW-ZINZINDOHU\* MsInfo: Get MSINFO32
2010/03/31 17:26:42.20 DPAW-ZINZINDOHU\* MsInfo: Get default traces
2010/03/31 17:26:42.29 DPAW-ZINZINDOHU\* MsInfo: Get SQLDumper log
2010/03/31 17:26:42.43 DPAW-ZINZINDOHU\* Adding Perfmon counters... 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\* . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Current Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Read Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Read Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Write Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Write Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Transfer . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Read . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Write . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Transfers/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Reads/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Writes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Read Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Write Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Transfer . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Read . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Write . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Idle Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Split IO/Sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\* . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% Processor Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% User Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% Privileged Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\Interrupts/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% DPC Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% Interrupt Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\DPCs Queued/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\DPC Rate . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% Idle Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% C1 Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% C2 Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\% C3 Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\C1 Transitions/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\C2 Transitions/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\Processor(*)\C3 Transitions/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:27:11.74 SQLDIAG 0 counters added 
2010/03/31 17:27:12.21 SQLDIAG Initialization complete 
2010/03/31 17:27:12.21 DPAW-ZINZINDOHU\* Starting Perfmon 
2010/03/31 17:27:12.35 DPAW-ZINZINDOHU\* Perfmon started 
2010/03/31 17:27:12.35 DPAW-ZINZINDOHU\* Collecting diagnostic data 
2010/03/31 17:27:12.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:13.21 SQLDIAG Collection started.  Press Ctrl+C to stop. 
2010/03/31 17:27:17.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:22.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:27.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:32.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:37.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:42.35 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:47.37 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:52.37 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:27:57.37 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:28:02.37 DPAW-ZINZINDOHU\* Error updating perfmon log  . Function result: -2147481643. Message: Aucune donnée à renvoyer. 
2010/03/31 17:28:03.46 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:28:04.70 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:28:07.37 DPAW-ZINZINDOHU\* Shutting down the collector 
2010/03/31 17:28:10.21 SQLDIAG Ending data collection.  Please wait while the process shuts down and files are compressed (this may take several minutes)

##SQLDIAG.LOG Sans Erreur lors de l'exécution mais dans le log on voit qu'il ne prend pas en compte le
PhysicalDisk(*) par exemple !

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
89
 
2010/03/31 17:46:43.07 SQLDIAG Command line parameter sqldiag 
2010/03/31 17:46:43.07 SQLDIAG Command line parameter /I 
2010/03/31 17:46:43.07 SQLDIAG Command line parameter E:\traceSQLDIAG\EZ_SQLDIAG_ok.xml 
2010/03/31 17:46:43.07 SQLDIAG Command line parameter /O 
2010/03/31 17:46:43.07 SQLDIAG Command line parameter E:\TraceSQLDIAG\testToday_ok 
2010/03/31 17:46:43.07 SQLDIAG Collector version  
2010/03/31 17:46:43.07 SQLDIAG 
IMPORTANT:  Please wait until you see "Collection started" before attempting to reproduce your issue 
2010/03/31 17:46:43.07 SQLDIAG Output path: E:\TraceSQLDIAG\testToday_ok\ 
2010/03/31 17:46:43.16 SQLDIAG Collecting from 1 logical machine(s) 
2010/03/31 17:46:43.16 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:46:43.18 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:46:43.18 DPAW-ZINZINDOHU\* Instances registry value not found (you can usually safely ignore this) . Function result: 259. Message: Aucune donnée n'est disponible. 
2010/03/31 17:46:43.18 SQLDIAG Invalid node fetched. (null) 
2010/03/31 17:46:43.18 SQLDIAG Invalid node fetched. (null) 
2010/03/31 17:46:43.24 DPAW-ZINZINDOHU\* SQL Server version: 10 
2010/03/31 17:46:43.24 DPAW-ZINZINDOHU\* Machine name: DPAW-ZINZINDOHU (this machine)  
2010/03/31 17:46:43.24 DPAW-ZINZINDOHU\* Target machine is not a cluster 
2010/03/31 17:46:43.24 DPAW-ZINZINDOHU\* Instance: (Default) (32-bit) 
2010/03/31 17:46:44.16 SQLDIAG Initialization starting... 
2010/03/31 17:46:45.49 DPAW-ZINZINDOHU\* Starting Profiler trace 
2010/03/31 17:46:46.04 DPAW-ZINZINDOHU\* Starting Blocking script 
2010/03/31 17:46:46.96 DPAW-ZINZINDOHU\* MsInfo: Get MSINFO32
2010/03/31 17:46:47.10 DPAW-ZINZINDOHU\* MsInfo: Get default traces
2010/03/31 17:46:47.21 DPAW-ZINZINDOHU\* MsInfo: Get SQLDumper log
2010/03/31 17:46:47.38 DPAW-ZINZINDOHU\* Adding Perfmon counters... 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Current Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Read Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Read Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Disk Write Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Write Queue Length . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Transfer . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Read . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk sec/Write . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Transfers/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.73 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Reads/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Writes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Read Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Disk Write Bytes/sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Transfer . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Read . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Avg. Disk Bytes/Write . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\% Idle Time . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\Split IO/Sec . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Buffer cache hit ratio 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Buffer cache hit ratio base 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page lookups/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Free list stalls/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Free pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Total pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Target pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Database pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Reserved pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Stolen pages 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Lazy writes/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Readahead pages/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Could not add counter: \\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Procedure cache pages . Function result: -1073738823. Message: Le compteur spécifié n'a pas été trouvé. 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page reads/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page writes/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Checkpoint pages/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE lookup maps/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE stolen maps/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE write maps/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE unmap calls/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE unmap pages/sec 
2010/03/31 17:47:09.74 DPAW-ZINZINDOHU\* Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page life expectancy 
2010/03/31 17:47:09.74 SQLDIAG 21 counters added 
2010/03/31 17:47:10.20 DPAW-ZINZINDOHU\* Starting Perfmon 
2010/03/31 17:47:10.20 SQLDIAG Initialization complete 
2010/03/31 17:47:10.32 DPAW-ZINZINDOHU\* Perfmon started 
2010/03/31 17:47:10.32 DPAW-ZINZINDOHU\* Collecting diagnostic data 
2010/03/31 17:47:11.20 SQLDIAG Collection started.  Press Ctrl+C to stop. 
2010/03/31 17:47:33.57 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:33.99 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:34.15 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:34.31 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:35.18 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:35.34 DPAW-ZINZINDOHU\* Shutting down the collector 
2010/03/31 17:47:35.35 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:35.54 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:36.66 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:36.93 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:37.15 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:37.35 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/03/31 17:47:38.21 SQLDIAG Ending data collection.  Please wait while the process shuts down and files are compressed (this may take several minutes)

31/03/2010, 18h37
dbaffaleuf

Donc:

Code:

Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\* . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système.

Clairement perfmon te dit qu'il ne trouve pas le compteur PhysicalDisk(*). Même si sqldiag ne sort pas en erreur, le fichier BLG qui suit est inexploitable. Pour pouvoir lire le fichier BLG dans Profiler (ce qui était ton problème au départ), il faut retrouver le nom des compteurs en FRANCAIS. Dans une fenêtre de commande:

Code:

typeperf -qx

...retournera la liste de tous les compteurs disponibles sur la machine. Par exemple pour avoir les compteurs correspondant à "Disque physique":

Code:

typeperf -qx | findstr "physique"

David B.
31/03/2010, 23h29
zinzineti

Citation:

Envoyé par dbaffaleuf

Donc:

Code:

Could not add counter: \\DPAW-ZINZINDOHU\PhysicalDisk(*)\* . Function result: -1073738824. Message: L'objet spécifié n'a pas été trouvé sur le système.

Clairement perfmon te dit qu'il ne trouve pas le compteur PhysicalDisk(*). Même si sqldiag ne sort pas en erreur, le fichier BLG qui suit est inexploitable. Pour pouvoir lire le fichier BLG dans Profiler (ce qui était ton problème au départ), il faut retrouver le nom des compteurs en FRANCAIS. Dans une fenêtre de commande:

Code:

typeperf -qx

...retournera la liste de tous les compteurs disponibles sur la machine. Par exemple pour avoir les compteurs correspondant à "Disque physique":

Code:

typeperf -qx | findstr "physique"

David B.

Ok, Je regarde ça demain.
A+

Citation:

Envoyé par zinzineti

Ok, Je regarde ça demain.
A+

J'ai francisé les compteurs perfmon "Disque physique" en faisant bien sûr attention aux caractères accentués (ça fait perdre du temps :() et il n'y a plus d'erreur dans le fichier ##SQLDIAG.LOG

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
2010/04/01 14:41:34.01 SQLDIAG Command line parameter sqldiag 
2010/04/01 14:41:34.01 SQLDIAG Command line parameter /I 
2010/04/01 14:41:34.01 SQLDIAG Command line parameter E:\TraceSQLDIAG\EZ_SQLDIAG_ok1.xml 
2010/04/01 14:41:34.01 SQLDIAG Command line parameter /O 
2010/04/01 14:41:34.01 SQLDIAG Command line parameter E:\TraceSQLDIAG\today 
2010/04/01 14:41:34.01 SQLDIAG Collector version  
2010/04/01 14:41:34.01 SQLDIAG 
IMPORTANT:  Please wait until you see "Collection started" before attempting to reproduce your issue 
2010/04/01 14:41:34.03 SQLDIAG Output path: E:\TraceSQLDIAG\today\ 
2010/04/01 14:41:34.04 SQLDIAG Collecting from 1 logical machine(s) 
2010/04/01 14:41:34.04 SQLDIAG Invalid node fetched. (null) 
2010/04/01 14:41:34.04 SQLDIAG Invalid node fetched. (null) 
2010/04/01 14:41:34.04 DPAW-ZINZINDOHU\MSSQLSERVER SQL Server version: 10 
2010/04/01 14:41:34.04 DPAW-ZINZINDOHU\MSSQLSERVER Machine name: DPAW-ZINZINDOHU (this machine)  
2010/04/01 14:41:34.04 DPAW-ZINZINDOHU\MSSQLSERVER Target machine is not a cluster 
2010/04/01 14:41:34.06 DPAW-ZINZINDOHU\MSSQLSERVER Instance: (Default) (32-bit) 
2010/04/01 14:41:35.04 SQLDIAG Initialization starting... 
2010/04/01 14:41:36.28 DPAW-ZINZINDOHU\MSSQLSERVER Starting Profiler trace 
2010/04/01 14:41:36.73 DPAW-ZINZINDOHU\MSSQLSERVER Starting Blocking script 
2010/04/01 14:41:37.50 DPAW-ZINZINDOHU\MSSQLSERVER MsInfo: Get MSINFO32
2010/04/01 14:41:37.59 DPAW-ZINZINDOHU\MSSQLSERVER MsInfo: Get default traces
2010/04/01 14:41:37.68 DPAW-ZINZINDOHU\MSSQLSERVER MsInfo: Get SQLDumper log
2010/04/01 14:41:37.79 DPAW-ZINZINDOHU\MSSQLSERVER Adding Perfmon counters... 
2010/04/01 14:41:37.85 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\Long. moy. de file d'attente du disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\Long. moy. de file d'attente lecture disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\Long. moy. de file d'attente Écriture disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\% Temps du disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\% Temps lecture du disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\% Temps Écriture du disque 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\Moy. disque s/lecture 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\Moy. disque s/Écriture 
2010/04/01 14:41:37.87 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\Disque physique(*)\E/S partagÉes/s 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Buffer cache hit ratio 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Buffer cache hit ratio base 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page lookups/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Free list stalls/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Free pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Total pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Target pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Database pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Reserved pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Stolen pages 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Lazy writes/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Readahead pages/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page reads/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page writes/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Checkpoint pages/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE lookup maps/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE stolen maps/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE write maps/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE unmap calls/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\AWE unmap pages/sec 
2010/04/01 14:41:38.01 DPAW-ZINZINDOHU\MSSQLSERVER Counter=\\DPAW-ZINZINDOHU\SQLServer:Buffer Manager\Page life expectancy 
2010/04/01 14:41:38.01 SQLDIAG 30 counters added 
2010/04/01 14:41:38.04 SQLDIAG Initialization complete 
2010/04/01 14:41:38.04 DPAW-ZINZINDOHU\MSSQLSERVER Starting Perfmon 
2010/04/01 14:41:38.18 DPAW-ZINZINDOHU\MSSQLSERVER Perfmon started 
2010/04/01 14:41:38.18 DPAW-ZINZINDOHU\MSSQLSERVER Collecting diagnostic data 
2010/04/01 14:41:39.04 SQLDIAG Collection started.  Press Ctrl+C to stop. 
2010/04/01 14:42:28.23 SQLDIAG Ctrl+C pressed.  Shutting down the collector 
2010/04/01 14:42:33.21 DPAW-ZINZINDOHU\MSSQLSERVER Shutting down the collector 
2010/04/01 14:42:33.21 DPAW-ZINZINDOHU\MSSQLSERVER Getting SQLConfig report(s) 
2010/04/01 14:42:42.59 DPAW-ZINZINDOHU\MSSQLSERVER Dumping the Application Eventlog... 
2010/04/01 14:42:42.59 DPAW-ZINZINDOHU\MSSQLSERVER Dumping the Security Eventlog... 
2010/04/01 14:42:42.59 DPAW-ZINZINDOHU\MSSQLSERVER Dumping the System Eventlog... 
2010/04/01 14:42:45.06 SQLDIAG Ending data collection.  Please wait while the process shuts down and files are compressed (this may take several minutes) 
2010/04/01 14:42:45.06 SQLDIAG Waiting on MsInfo: Get MSINFO32 
2010/04/01 14:43:15.06 SQLDIAG Waiting on MsInfo: Get MSINFO32

Ce qui est curieux et qui engendre une perte de temps c'est que : il y a des compteurs FRANCISés et d'autres NON Francisé tu peux le vérifier en exécutant

Code:

typeperf -qx|more

Voici le fichier de config

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
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
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
 
<?xml version="1.0" standalone="yes"?>
<dsConfig>
<Collection setupver="3.0.1.7" casenumber="SRX000000000000">
    <Machines>
      <Machine name=".">
        <MachineCollectors>
          <EventlogCollector enabled="true" startup="false" shutdown="true" />
          <PerfmonCollector enabled="true" pollinginterval="5" maxfilesize="256">
            <PerfmonCounters>
			<PerfmonObject name="\Disque physique(*)" enabled="true">
			    <PerfmonCounter name="\Long. moy. de file d'attente du disque" enabled="true" />
				<PerfmonCounter name="\Long. moy. de file d'attente lecture disque" enabled="true" />
				<PerfmonCounter name="\Long. moy. de file d'attente Écriture disque" enabled="true" />
				<PerfmonCounter name="\% Temps du disque" enabled="true" />
				<PerfmonCounter name="\% Temps lecture du disque" enabled="true" />
				<PerfmonCounter name="\% Temps Écriture du disque" enabled="true" />
				<PerfmonCounter name="\Moy. disque s/lecture" enabled="true" />
			    <PerfmonCounter name="\Moy. disque s/Écriture" enabled="true" />
				<PerfmonCounter name="\E/S partagÉes/s" enabled="true" />
			</PerfmonObject>
			<PerfmonObject name="\MSSQL$%s:Buffer Manager" enabled="true">
				<PerfmonCounter name="\Buffer cache hit ratio" enabled="true" />
				<PerfmonCounter name="\Buffer cache hit ratio base" enabled="true" />
				<PerfmonCounter name="\Page lookups/sec" enabled="true" />
				<PerfmonCounter name="\Free list stalls/sec" enabled="true" />
				<PerfmonCounter name="\Free pages" enabled="true" />
				<PerfmonCounter name="\Total pages" enabled="true" />
				<PerfmonCounter name="\Target pages" enabled="true" />
				<PerfmonCounter name="\Database pages" enabled="true" />
				<PerfmonCounter name="\Reserved pages" enabled="true" />
				<PerfmonCounter name="\Stolen pages" enabled="true" />
				<PerfmonCounter name="\Lazy writes/sec" enabled="true" />
				<PerfmonCounter name="\Readahead pages/sec" enabled="true" />
				<PerfmonCounter name="\Page reads/sec" enabled="true" />
				<PerfmonCounter name="\Page writes/sec" enabled="true" />
				<PerfmonCounter name="\Checkpoint pages/sec" enabled="true" />
				<PerfmonCounter name="\AWE lookup maps/sec" enabled="true" />
				<PerfmonCounter name="\AWE stolen maps/sec" enabled="true" />
				<PerfmonCounter name="\AWE write maps/sec" enabled="true" />
				<PerfmonCounter name="\AWE unmap calls/sec" enabled="true" />
				<PerfmonCounter name="\AWE unmap pages/sec" enabled="true" />
				<PerfmonCounter name="\Page life expectancy" enabled="true" />
              </PerfmonObject>
</PerfmonCounters>
</PerfmonCollector>
</MachineCollectors>
<Instances>
<Instance name="MSSQLSERVER" 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 &quot;%output_path%%server%_MSINFO32.TXT&quot; /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="&quot;%sspath%log\log*.trc&quot; &quot;%output_path%&quot;" />
<CustomTask enabled="true" groupname="MsInfo" taskname="Get SQLDumper log" type="Copy_File" point="Startup" wait="OnlyOnShutdown" cmd="&quot;%sspath%log\SQLDUMPER_ERRORLOG.log&quot; &quot;%output_path%%server%_%instance%_SQLDUMPER_ERRORLOG.log&quot;" />
</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>

Enfin pour résumé :
1. SQLDIAG s'exécute sans erreur ;)
2. La mise en perspective des fichier .BLG et .trc se fait bien via SQLProfiler ;)
3. L'utilisation du fichier .BLG dans le logiciel PAL (Performance Analysis of Log) v1.3.6 ne marche pas :(
Voici l'erreur renvoyée par PAL

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
E:\TraceSQLDIAG\today>CScript "E:\Program Files\PAL\PAL v1.3.6\PAL.vbs" /LOG:"E:\TraceSQLDIAG\today\SQLDIAG.BLG" /THRESHOLDFILE:"E:\Program Files\PAL\PAL
v1.3.6\SystemOverview.xml" /INTERVAL:"AUTO" /ISOUTPUTHTML:True /ISOUTPUTXML:False /OUTPUTDIR:"C:\Documents and Settings\e.zinzindohoue\Bureau" /HTMLOUTPUT
FILENAME:"reeeee.htm" /NumberOfProcessors:1 /ThreeGBSwitch:False /SixtyFourBit:False /TotalMemory:2 /KernelDumpOnCDrive:True
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation 1996-2001. Tous droits réservés.
 
PAL.vbs v1.3.6
 
Creating the resource directory: "C:\Documents and Settings\e.zinzindohoue\Bureau\reeeee"...
Created user defined resource directory: "C:\Documents and Settings\e.zinzindohoue\Bureau\reeeee"
Determining if counters are in the Perfmon log...
 Using Relog to create a counter list...
Executing: ReLog.exe "E:\TraceSQLDIAG\today\SQLDIAG.BLG" -f CSV -y -o C:\DOCUME~1\E53C3~1.ZIN\LOCALS~1\Temp\{60521165-4C7B-469B-94AC-6215D31DEFF8}\_Filter
edLogForCounterlist.csv
 
Entr'e
----------------
Fichier(s) :
     E:\TraceSQLDIAG\today\SQLDIAG.BLG (binaire)
 
D'marrer :    1/4/2010 14:41:38
Arr^ter :      1/4/2010 14:42:28
?chantillons :  11
 
Sortie
----------------
Fichier :     C:\DOCUME~1\E53C3~1.ZIN\LOCALS~1\Temp\{60521165-4C7B-469B-94AC-6215D31DEFF8}\_FilteredLogForCounterlist.csv
 
D'marrer :    1/4/2010 14:41:38
Arr^ter :      1/4/2010 14:42:28
?chantillons :  11
 
L'op'ration a bien 't' effectu'e.
 
 Done using Relog to create a counter list.
ERROR: [DetermineIfCountersAreInThePerfmonLog] Unable to create a counter list from C:\DOCUME~1\E53C3~1.ZIN\LOCALS~1\Temp\{60521165-4C7B-469B-94AC-6215D31
DEFF8}\_FilteredPerfmonLog.csv
 
E:\TraceSQLDIAG\today>

Est ce que tu utilises PAL ?

A+

Etienne

01/04/2010, 15h35
dbaffaleuf

Hello,

Tu as aussi des compteurs en anglais parce que ton SQL Server est probablement en anglais.

Je ne connais pas PAL.

David B.
01/04/2010, 15h46
mikedavem

Que vous arrive t'il avec PAL ?

(Performance Analysis of Logs ... un outil pour générer de jolis rapports HTML concernant les compteurs de performance et autres ... ). Il m'est arrivé de l'utiliser avec les RML utilies de microsoft

++
01/04/2010, 23h30
zinzineti

Citation:

Envoyé par dbaffaleuf

Hello,

Tu as aussi des compteurs en anglais parce que ton SQL Server est probablement en anglais.

Je ne connais pas PAL.

David B.

Salut David,

Mon SQL Server est en français ! Voir pièce jointe

A+