Databases Reference
In-Depth Information
Analysis Services Custom Collectors
The Diag Manager provides four different types of collectors for Analysis Services. Three collectors
are specii c to a given Analysis Services version, and the fourth is a shared collector that collects
general diagnostics from an Analysis Services instance:
➤
Analysis Services 2000
➤
Analysis Services 2005
➤
Analysis Services 2008
➤
Analysis Services Shared
The Analysis Services 2008 and Analysis Services
Shared works for SQL Server 2012 Analysis Services
installed in the multi-dimensional model. If you are
interested in viewing what these collectors collect, you
can i nd details by right-clicking on the collector and
selecting the Details option as shown in Figure 11-9.
Feature-Specifi c Custom Diagnostics
The Diag Manager also provides you with some
feature-specii c custom collectors that can be very
helpful when you are troubleshooting a particular
SQL Server scenario or feature.
FIGURE 11-9
The
Database Mirroring
custom collector collects information from various system DMVs and
catalogs for the database mirroring coni guration and status of the mirrored databases. In addi-
tion, the database mirroring collector connects the database mirroring partner and witness to col-
lect the coni guration data that it collected from the target instance on which SQLdiag is running.
To ensure that all the data is collected, you would need to ensure that the account running the
SQLdiag has permissions to collect the database mirroring coni guration information from the mir-
ror and witness. Note that there are no new custom collectors available for collecting data specii c
to Availability Groups for SQL Server 2012 as yet. However, you can write your own collector by
dei ning a new custom collector under the
_MyCollectors
option discussed later in this chapter.
WARNING
The collector assumes that the account running SQLdiag will be
able to log into all the SQL Server instances as a sysadmin using Windows
authentication.
The
Full Text Search
custom collector collects the full-text search coni guration and the full-text
catalog details for each database that is full-text enabled.
The
Linked Server Coni guration
custom collector collects information about the available linked
server providers on the target machine, and coni guration information about all the linked servers
coni gured on the target SQL Server instance.
Search WWH ::
Custom Search