Databases Reference
In-Depth Information
Space' type='Utility' point='Shutdown' wait='OnlyOnShutdown' cmd='powershell.exe -File
".\space.ps1" -NoLogo -NonInteractive > "PShell_DiskSpace.OUT" '
pollinginterval='0' />
</CustomDiagnostics>
NOTE Before saving the package coni guration, you must add your custom
scripts (in the preceding example, space.ps1 ) to the C:\Program Files\
Microsoft\Pssdiag\CustomDiagnostics\_MyCollectors folder.
Saving and Using a SQLdiag Confi guration
Now that you know how to coni gure the SQLdiag collection based on the data you need to collect,
this section describes how to save the coni guration package, as this tool was released to work with
SQL Server 2008 R2, 2008, and 2005 versions. When
you click the Save button, the dialog shown in
Figure 11-14 will appear, providing the location of the
cabinet (.cab) i le and the XML coni guration i le. You
can change the path of the two i les as appropriate.
When you click OK, the dialog shown in Figure 11-15
will appear for selecting either SQL Server 2008 R2
or SQL Server 2008, in case you were coni guring the
data collection using the SQL Server 2008 tab in
the Diag Manager.
FIGURE 11-14
FIGURE 11-15
NOTE The preceding coni guration steps work for all releases of SQL Server
2005 and later. Because we are discussing data collection coni guration for SQL
Server 2012 instances, you should select the SQL Server 2008 tab when you start
your coni guration. When the dialog is provided for choosing the SQL Server
version while saving the cabinet i le, choose the SQL Server 2008 R2 option.
Search WWH ::




Custom Search