INFORMANT-SQLSERVER-V2 DEFINITIONS ::= BEGIN

IMPORTS
    MODULE-IDENTITY, OBJECT-TYPE, Gauge32, Integer32
        FROM SNMPv2-SMI
    InstanceName, informant
        FROM WTCS;

sqlServerV2 MODULE-IDENTITY
    LAST-UPDATED "200804270606Z"
    ORGANIZATION "Informant Systems, Inc."
    CONTACT-INFO
            "Garth Williams
             11135-23A Ave
             Edmonton, AB  T6J4W5  Canada
             Tel: +1 780 434 4113
             E-mail: garth.williams@wtcs.org"
    DESCRIPTION
            "The MIB module for informant SQL Server V2
             entries. This module supports SQL Server
             2005 and SQL Server 2008."
    REVISION      "200804270606Z"
    DESCRIPTION
            "The initial revision of this MIB module."
    ::= { informant 13 }

analysisServicesV2 OBJECT IDENTIFIER
    ::= { sqlServerV2 1 }

as2NameTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesNameEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "This table contains the list of Analysis
	    Services instance names installed. The
	    as2NameIndex is used to refer to all other
	    Analysis Services SNMP entries."
    ::= { analysisServicesV2 1 }

as2NameEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesNameEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one Analysis
	    Services name instance."
    INDEX      { as2NameIndex }
    ::= { as2NameTable 1 }

AnalysisServicesNameEntry ::= SEQUENCE {
    as2NameIndex Integer32,
    as2NameInstance InstanceName
}

as2NameIndex OBJECT-TYPE
    SYNTAX     Integer32 (1..2147483647)
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The index number associated with the instance
	    name"
    ::= { as2NameEntry 1 }

as2NameInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The name of the Analysis Services installed
	    instance."
    ::= { as2NameEntry 2 }

as2CacheTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesCacheEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services aggregation cache."
    ::= { analysisServicesV2 2 }

as2CacheEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesCacheEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2CacheTable 1 }

AnalysisServicesCacheEntry ::= SEQUENCE {
    as2CacheCurrentKB Gauge32,
    as2CacheCurrentEntries Gauge32,
    as2CacheDirectHitRatio Gauge32,
    as2CacheDirectHitsPerSec Gauge32,
    as2CacheEvictionsPerSec Gauge32,
    as2CacheInsertsPerSec Gauge32,
    as2CacheKBAddedPerSec Gauge32,
    as2CacheLookupsPerSec Gauge32,
    as2CacheMissesPerSec Gauge32,
    as2CacheTotalDirectHits Gauge32,
    as2CacheTotalEvictions Gauge32,
    as2CacheTotalFiltIteratorCachHit Gauge32,
    as2CacheTotalFiltIteratorCachMis Gauge32,
    as2CacheTotalInserts Gauge32,
    as2CacheTotalLookups Gauge32,
    as2CacheTotalMisses Gauge32
}

as2CacheCurrentKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory used by the aggregation cache,
	    in KB."
    ::= { as2CacheEntry 1 }

as2CacheCurrentEntries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of cache entries."
    ::= { as2CacheEntry 2 }

as2CacheDirectHitRatio OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Ratio of cache direct hits to cache lookups,
	    for the period between obtaining counter
	    values."
    ::= { as2CacheEntry 3 }

as2CacheDirectHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of cache direct hits.  Queries were
	    answered from an existing cache entry."
    ::= { as2CacheEntry 4 }

as2CacheEvictionsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of evictions from the cache.	This is per
	    partition per cube per database.  Typically due
	    to background cleaner."
    ::= { as2CacheEntry 5 }

as2CacheInsertsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of insertions into the cache.  This is
	    per partition per cube per database."
    ::= { as2CacheEntry 6 }

as2CacheKBAddedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of memory added to the cache, KB/sec."
    ::= { as2CacheEntry 7 }

as2CacheLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of cache lookups."
    ::= { as2CacheEntry 8 }

as2CacheMissesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of cache misses."
    ::= { as2CacheEntry 9 }

as2CacheTotalDirectHits OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total count of direct cache hits.	Queries
	    were answered from existing cache entries."
    ::= { as2CacheEntry 10 }

as2CacheTotalEvictions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Evictions from the cache.	This is per
	    partition per cube per database.  Typically due
	    to background cleaner."
    ::= { as2CacheEntry 11 }

as2CacheTotalFiltIteratorCachHit OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cache hits that returned an
	    indexed iterator over the filtered results"
    ::= { as2CacheEntry 12 }

as2CacheTotalFiltIteratorCachMis OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cache hits that were unable to
	    build an indexed iterator over the filtered
	    results and had to build a new cache with the
	    filtered results"
    ::= { as2CacheEntry 13 }

as2CacheTotalInserts OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Insertions into the cache.  This is per
	    partition per cube per database."
    ::= { as2CacheEntry 14 }

as2CacheTotalLookups OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of lookups into the cache."
    ::= { as2CacheEntry 15 }

as2CacheTotalMisses OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total count of cache misses."
    ::= { as2CacheEntry 16 }

as2ConnectionTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesConnectionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services connections."
    ::= { analysisServicesV2 3 }

as2ConnectionEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesConnectionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ConnectionTable 1 }

AnalysisServicesConnectionEntry ::= SEQUENCE {
    as2ConnectionCurrentConnections Gauge32,
    as2ConnectionCurrentUserSessions Gauge32,
    as2ConnectionFailuresPerSec Gauge32,
    as2ConnectionRequestsPerSec Gauge32,
    as2ConnectionSuccessesPerSec Gauge32,
    as2ConnectionTotalFailures Gauge32,
    as2ConnectionTotalRequests Gauge32,
    as2ConnectionTotalSuccesses Gauge32
}

as2ConnectionCurrentConnections OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of client connections
	    established."
    ::= { as2ConnectionEntry 1 }

as2ConnectionCurrentUserSessions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of user sessions established."
    ::= { as2ConnectionEntry 2 }

as2ConnectionFailuresPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of connection failures."
    ::= { as2ConnectionEntry 3 }

as2ConnectionRequestsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of connection requests.  These are
	    arrivals."
    ::= { as2ConnectionEntry 4 }

as2ConnectionSuccessesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of successful connection completions."
    ::= { as2ConnectionEntry 5 }

as2ConnectionTotalFailures OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total failed connection attempts."
    ::= { as2ConnectionEntry 6 }

as2ConnectionTotalRequests OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total connection requests.  These are
	    arrivals."
    ::= { as2ConnectionEntry 7 }

as2ConnectionTotalSuccesses OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total successful connections."
    ::= { as2ConnectionEntry 8 }

as2DataMiningModelProcessTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF DataMiningModelProcessingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services Data Mining model processing."
    ::= { analysisServicesV2 4 }

as2DataMiningModelProcessEntry OBJECT-TYPE
    SYNTAX     DataMiningModelProcessingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2DataMiningModelProcessTable 1 }

DataMiningModelProcessingEntry ::= SEQUENCE {
    as2dmmpCasesPerSec Gauge32,
    as2dmmpCurrentModelsProcessing Gauge32
}

as2dmmpCasesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of processing cases."
    ::= { as2DataMiningModelProcessEntry 1 }

as2dmmpCurrentModelsProcessing OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of models being processed"
    ::= { as2DataMiningModelProcessEntry 2 }

as2DataMiningPredictionTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF DataMiningPredictionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services Data Mining prediction."
    ::= { analysisServicesV2 5 }

as2DataMiningPredictionEntry OBJECT-TYPE
    SYNTAX     DataMiningPredictionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2DataMiningPredictionTable 1 }

DataMiningPredictionEntry ::= SEQUENCE {
    as2dmpConcurrentDMQueries Gauge32,
    as2dmpPredictionsPerSec Gauge32,
    as2dmpQueriesPerSec Gauge32,
    as2dmpRowsPerSec Gauge32,
    as2dmpTotalPredictions Gauge32,
    as2dmpTotalQueries Gauge32,
    as2dmpTotalRows Gauge32
}

as2dmpConcurrentDMQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of Data Mining queries being
	    actively worked on."
    ::= { as2DataMiningPredictionEntry 1 }

as2dmpPredictionsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of Data Mining prediction queries"
    ::= { as2DataMiningPredictionEntry 2 }

as2dmpQueriesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of Data Mining queries"
    ::= { as2DataMiningPredictionEntry 3 }

as2dmpRowsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of predicting rows"
    ::= { as2DataMiningPredictionEntry 4 }

as2dmpTotalPredictions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total Data Mining Prediction Queries received
	    by the server"
    ::= { as2DataMiningPredictionEntry 5 }

as2dmpTotalQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total Data Mining Queries received by the
	    server"
    ::= { as2DataMiningPredictionEntry 6 }

as2dmpTotalRows OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total Rows returned by Data Mining queries"
    ::= { as2DataMiningPredictionEntry 7 }

as2LocksTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesLocksEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services internal server locks."
    ::= { analysisServicesV2 6 }

as2LocksEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesLocksEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2LocksTable 1 }

AnalysisServicesLocksEntry ::= SEQUENCE {
    as2LocksCurrentLatchWaits Gauge32,
    as2LocksCurrentLockWaits Gauge32,
    as2LocksCurrentLocks Gauge32,
    as2LocksLatchWaitsPerSec Gauge32,
    as2LocksLockDenialsPerSec Gauge32,
    as2LocksLockGrantsPerSec Gauge32,
    as2LocksLockRequestsPerSec Gauge32,
    as2LocksLockWaitsPerSec Gauge32,
    as2LocksTotalDeadlocksDetected Gauge32,
    as2LocksUnlockRequestsPerSec Gauge32
}

as2LocksCurrentLatchWaits OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of threads waiting for a latch.
	     These are latch requests that could not be
	    given immediate grants and are in a wait
	    state."
    ::= { as2LocksEntry 1 }

as2LocksCurrentLockWaits OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of clients waiting for a lock."
    ::= { as2LocksEntry 2 }

as2LocksCurrentLocks OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of locked objects."
    ::= { as2LocksEntry 3 }

as2LocksLatchWaitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of latch requests that could not be
	    granted immediately and had to wait before
	    being granted."
    ::= { as2LocksEntry 4 }

as2LocksLockDenialsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of lock denials."
    ::= { as2LocksEntry 5 }

as2LocksLockGrantsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of lock grants per second."
    ::= { as2LocksEntry 6 }

as2LocksLockRequestsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of lock requests per second."
    ::= { as2LocksEntry 7 }

as2LocksLockWaitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of lock waits per second.  These are
	    lock requests that could not be given immediate
	    lock grants and were put in a wait state."
    ::= { as2LocksEntry 8 }

as2LocksTotalDeadlocksDetected OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of deadlocks detected."
    ::= { as2LocksEntry 9 }

as2LocksUnlockRequestsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of unlock requests per second."
    ::= { as2LocksEntry 10 }

as2MDXTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesMDXEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services MDX Calculations."
    ::= { analysisServicesV2 7 }

as2MDXEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesMDXEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2MDXTable 1 }

AnalysisServicesMDXEntry ::= SEQUENCE {
    as2MDXCurrentNumOfCachedEvalNode Gauge32,
    as2MDXCurrentNumOfEvalNode Gauge32,
    as2MDXNumOfStorageEngineEvalNode Gauge32,
    as2MDXNumOfBulkModeEvalNode Gauge32,
    as2MDXNumOfCachedotherEvalNode Gauge32,
    as2MDXNumCacheStorEngineEvalNode Gauge32,
    as2MDXNumOfCacheBulkModeEvalNode Gauge32,
    as2MDXNumberOfCalculationCovers Gauge32,
    as2MDXNumOfCellByCellEvalNode Gauge32,
    as2MDXNumCellCellHitCacheEvalNod Gauge32,
    as2MDXNumCellCellMissCachEvalNod Gauge32,
    as2MDXNumEvalNodThatCovASglCell Gauge32,
    as2MDXNumEvalNodeCalcSameGranula Gauge32,
    as2MDXNumEvictionsEvalNode Gauge32,
    as2MDXNumHashdexHitsCacheEvalNod Gauge32,
    as2MDXNumSubcubeHitsCacheEvalNod Gauge32,
    as2MDXNumSubcubeMissCacheEvalNod Gauge32,
    as2MDXTotalAutoexist Gauge32,
    as2MDXTotalEXISTING Gauge32,
    as2MDXTotalNONEMPTY Gauge32,
    as2MDXTotalNONEMPTYCalculatMemb Gauge32,
    as2MDXTotalNONEMPTYUnoptimized Gauge32,
    as2MDXTotalSonarSubcubes Gauge32,
    as2MDXTotalCellsCalculated Gauge32,
    as2MDXTotalFlatCacheInserts Gauge32,
    as2MDXTotalRecomputes Gauge32
}

as2MDXCurrentNumOfCachedEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current (approximate) number of cached
	    evaluation nodes built by MDX execution plans"
    ::= { as2MDXEntry 1 }

as2MDXCurrentNumOfEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current (approximate) number of evaluation
	    nodes built by MDX execution plans including
	    active and cached"
    ::= { as2MDXEntry 2 }

as2MDXNumOfStorageEngineEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of Storage Engine evaluation
	    nodes built by MDX execution plans"
    ::= { as2MDXEntry 3 }

as2MDXNumOfBulkModeEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of bulk-mode evaluation nodes
	    built by MDX execution plans"
    ::= { as2MDXEntry 4 }

as2MDXNumOfCachedotherEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cached evaluation nodes built
	    by MDX execution plans that are neither Storage
	    Engine nor Bulk-mode"
    ::= { as2MDXEntry 5 }

as2MDXNumCacheStorEngineEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cached Storage Engine
	    evaluation nodes built by MDX execution plans"
    ::= { as2MDXEntry 6 }

as2MDXNumOfCacheBulkModeEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cached bulk-mode evaluation
	    nodes built by MDX execution plans"
    ::= { as2MDXEntry 7 }

as2MDXNumberOfCalculationCovers OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of evaluation nodes built by MDX
	    execution plans including active and cached"
    ::= { as2MDXEntry 8 }

as2MDXNumOfCellByCellEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cell-by-cell evaluation nodes
	    built by MDX execution plans"
    ::= { as2MDXEntry 9 }

as2MDXNumCellCellHitCacheEvalNod OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cell-by-cell hits in the cache
	    of evaluation nodes"
    ::= { as2MDXEntry 10 }

as2MDXNumCellCellMissCachEvalNod OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cell-by-cell misses in the
	    cache of evaluation nodes"
    ::= { as2MDXEntry 11 }

as2MDXNumEvalNodThatCovASglCell OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of evaluation nodes built by MDX
	    execution plans that covered only one cell"
    ::= { as2MDXEntry 12 }

as2MDXNumEvalNodeCalcSameGranula OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of evaluation nodes built by MDX
	    execution plans for which the calculations were
	    at the same granularity as the evaluation node"
    ::= { as2MDXEntry 13 }

as2MDXNumEvictionsEvalNode OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cache evictions of evaluation
	    nodes due to collisions"
    ::= { as2MDXEntry 14 }

as2MDXNumHashdexHitsCacheEvalNod OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of hits in the cache of
	    evaluation nodes that were satisfied by the
	    hash index"
    ::= { as2MDXEntry 15 }

as2MDXNumSubcubeHitsCacheEvalNod OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of subcube hits in the cache of
	    evaluation nodes"
    ::= { as2MDXEntry 16 }

as2MDXNumSubcubeMissCacheEvalNod OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of subcube misses in the cache of
	    evaluation nodes"
    ::= { as2MDXEntry 17 }

as2MDXTotalAutoexist OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of times autoexist performed"
    ::= { as2MDXEntry 18 }

as2MDXTotalEXISTING OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of times EXISTING set operator
	    performed"
    ::= { as2MDXEntry 19 }

as2MDXTotalNONEMPTY OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of times NON EMPTY algorithms is
	    used"
    ::= { as2MDXEntry 20 }

as2MDXTotalNONEMPTYCalculatMemb OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of times NON EMPTY algorithm was
	    looping over calculated members"
    ::= { as2MDXEntry 21 }

as2MDXTotalNONEMPTYUnoptimized OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of times unoptimized NON EMPTY
	    algorithm is used"
    ::= { as2MDXEntry 22 }

as2MDXTotalSonarSubcubes OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of subcubes that query optimizer
	    generated"
    ::= { as2MDXEntry 23 }

as2MDXTotalCellsCalculated OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cell properties calculated"
    ::= { as2MDXEntry 24 }

as2MDXTotalFlatCacheInserts OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cell values inserted into flat
	    calculation cache"
    ::= { as2MDXEntry 25 }

as2MDXTotalRecomputes OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of cells recomputed due to error"
    ::= { as2MDXEntry 26 }

as2MemoryTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesMemoryEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services internal server memory."
    ::= { analysisServicesV2 8 }

as2MemoryEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesMemoryEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2MemoryTable 1 }

AnalysisServicesMemoryEntry ::= SEQUENCE {
    as2memAggCacheKB Gauge32,
    as2memAggregationMapFiles Gauge32,
    as2memCleanerBalancePerSec Gauge32,
    as2memCleanerCurrentPrice Gauge32,
    as2memCleanerMemoryKB Gauge32,
    as2memCleanerMemNonshrinkableKB Gauge32,
    as2memCleanerMemoryShrinkableKB Gauge32,
    as2memCleanerMemShrunkKBSec Gauge32,
    as2memDimensionIndexHashFiles Gauge32,
    as2memDimensionPropertyFiles Gauge32,
    as2memDimensionStringFiles Gauge32,
    as2memFactAggregationFiles Gauge32,
    as2memFactDataFiles Gauge32,
    as2memFactStringFiles Gauge32,
    as2memFilestoreClockPgExamineSec Gauge32,
    as2memFilestoreClockPgHaveRefSec Gauge32,
    as2memFilestoreClockPgValidSec Gauge32,
    as2memFilestoreIOErrors Gauge32,
    as2memFilestoreIOErrorsPerSec Gauge32,
    as2memFilestoreKB Gauge32,
    as2memFilestoreKBReadsPerSec Gauge32,
    as2memFilestoreKBWritePerSec Gauge32,
    as2memFilestoreMemoryPinnedKB Gauge32,
    as2memFilestorePageFaultsPerSec Gauge32,
    as2memFilestoreReadsPerSec Gauge32,
    as2memFilestoreWritesPerSec Gauge32,
    as2memInMemAggregationMapFileKB Gauge32,
    as2memInMemAggregateMapFileKBSec Gauge32,
    as2memInMemDimenIndexHashFileKB Gauge32,
    as2memInMemDimenIndHashFileKBSec Gauge32,
    as2memInMemDimenProtyFileKB Gauge32,
    as2memInMemDimenProtyFileKBSec Gauge32,
    as2memInMemDimenStringFileKB Gauge32,
    as2memInMemDimenStringFileKBSec Gauge32,
    as2memInMemFactAggregationFileKB Gauge32,
    as2memInMemFactAggregatFileKBSec Gauge32,
    as2memInMemoryFactDataFileKB Gauge32,
    as2memInMemFactDataFileKBSec Gauge32,
    as2memInMemoryFactStringFileKB Gauge32,
    as2memInMemFactStringFileKBSec Gauge32,
    as2memInMemoryMapFileKB Gauge32,
    as2memInMemoryMapFileKBPerSec Gauge32,
    as2memInMemoryOtherFileKB Gauge32,
    as2memInMemoryOtherFileKBPerSec Gauge32,
    as2memMapFiles Gauge32,
    as2memMemoryLimitHighKB Gauge32,
    as2memMemoryLimitLowKB Gauge32,
    as2memMemoryUsageKB Gauge32,
    as2memOtherFiles Gauge32,
    as2memPagePool1AllocKB Gauge32,
    as2memPagePool1LookasideKB Gauge32,
    as2memPagePool64AllocKB Gauge32,
    as2memPagePool64LookasideKB Gauge32,
    as2memPagePool8AllocKB Gauge32,
    as2memPagePool8LookasideKB Gauge32,
    as2memPotenMemAggregatMapFileKB Gauge32,
    as2memPotenMemDimenIndHashFilKB Gauge32,
    as2memPotenMemDimenProFileKB Gauge32,
    as2memPotenMemDimenStringFileKB Gauge32,
    as2memPotenMemFactAggregFileKB Gauge32,
    as2memPotenMemFactDataFileKB Gauge32,
    as2memPotenMemFactStringFileKB Gauge32,
    as2memPotentialInMemoryMapFileKB Gauge32,
    as2memPotenMemOtherFileKB Gauge32,
    as2memQuotaBlocked Gauge32,
    as2memQuotaKB Gauge32
}

as2memAggCacheKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory allocated to filestore (file
	    cache), in KB."
    ::= { as2MemoryEntry 1 }

as2memAggregationMapFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of aggregation map files."
    ::= { as2MemoryEntry 2 }

as2memCleanerBalancePerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of balance+shrink operations."
    ::= { as2MemoryEntry 3 }

as2memCleanerCurrentPrice OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current price of memory, $/byte/time,
	    normalized to 1000."
    ::= { as2MemoryEntry 4 }

as2memCleanerMemoryKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Amount of memory, in KB, known to the
	    background cleaner.  (Cleaner memory shrinkable
	    + Cleaner memory nonshrinkable.)"
    ::= { as2MemoryEntry 5 }

as2memCleanerMemNonshrinkableKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Amount of memory, in KB, not subject to
	    purging by the background cleaner."
    ::= { as2MemoryEntry 6 }

as2memCleanerMemoryShrinkableKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Amount of memory, in KB, subject to purging by
	    the background cleaner."
    ::= { as2MemoryEntry 7 }

as2memCleanerMemShrunkKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of shrinking, in KB/sec."
    ::= { as2MemoryEntry 8 }

as2memDimensionIndexHashFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of dimension index (hash) files."
    ::= { as2MemoryEntry 9 }

as2memDimensionPropertyFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of dimension property files."
    ::= { as2MemoryEntry 10 }

as2memDimensionStringFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of dimension string files."
    ::= { as2MemoryEntry 11 }

as2memFactAggregationFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of fact aggregation files."
    ::= { as2MemoryEntry 12 }

as2memFactDataFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of fact data files."
    ::= { as2MemoryEntry 13 }

as2memFactStringFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of fact string files."
    ::= { as2MemoryEntry 14 }

as2memFilestoreClockPgExamineSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of background cleaner examining pages for
	    eviction consideration."
    ::= { as2MemoryEntry 15 }

as2memFilestoreClockPgHaveRefSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of background cleaner examining pages
	    that have a current reference count (are
	    currently in use)."
    ::= { as2MemoryEntry 16 }

as2memFilestoreClockPgValidSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of background cleaner examining pages
	    that are valid candidates for eviction."
    ::= { as2MemoryEntry 17 }

as2memFilestoreIOErrors OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore IO Errors total."
    ::= { as2MemoryEntry 18 }

as2memFilestoreIOErrorsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore IO Error rate."
    ::= { as2MemoryEntry 19 }

as2memFilestoreKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory allocated to filestore (file
	    cache), in KB."
    ::= { as2MemoryEntry 20 }

as2memFilestoreKBReadsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore KB read/sec."
    ::= { as2MemoryEntry 21 }

as2memFilestoreKBWritePerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore KB written/sec.	The writes are
	    asynchronous."
    ::= { as2MemoryEntry 22 }

as2memFilestoreMemoryPinnedKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current filestore memory pinned KB."
    ::= { as2MemoryEntry 23 }

as2memFilestorePageFaultsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore page fault rate."
    ::= { as2MemoryEntry 24 }

as2memFilestoreReadsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore pages read/sec."
    ::= { as2MemoryEntry 25 }

as2memFilestoreWritesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Filestore pages written/sec.  The writes are
	    asynchronous."
    ::= { as2MemoryEntry 26 }

as2memInMemAggregationMapFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory aggregation map file KB."
    ::= { as2MemoryEntry 27 }

as2memInMemAggregateMapFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory aggregation map file KB rate."
    ::= { as2MemoryEntry 28 }

as2memInMemDimenIndexHashFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory dimension index (hash) file
	    KB."
    ::= { as2MemoryEntry 29 }

as2memInMemDimenIndHashFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory dimension index (hash) file KB
	    rate."
    ::= { as2MemoryEntry 30 }

as2memInMemDimenProtyFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory dimension proty file KB."
    ::= { as2MemoryEntry 31 }

as2memInMemDimenProtyFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory dimension proty file KB rate."
    ::= { as2MemoryEntry 32 }

as2memInMemDimenStringFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory dimension string file KB."
    ::= { as2MemoryEntry 33 }

as2memInMemDimenStringFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory dimension string file KB rate."
    ::= { as2MemoryEntry 34 }

as2memInMemFactAggregationFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory fact aggregation file KB."
    ::= { as2MemoryEntry 35 }

as2memInMemFactAggregatFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory fact aggregation file KB rate."
    ::= { as2MemoryEntry 36 }

as2memInMemoryFactDataFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory fact data file KB."
    ::= { as2MemoryEntry 37 }

as2memInMemFactDataFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory fact data file KB rate."
    ::= { as2MemoryEntry 38 }

as2memInMemoryFactStringFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory fact string file KB."
    ::= { as2MemoryEntry 39 }

as2memInMemFactStringFileKBSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory fact string file KB rate."
    ::= { as2MemoryEntry 40 }

as2memInMemoryMapFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory map file KB."
    ::= { as2MemoryEntry 41 }

as2memInMemoryMapFileKBPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory map file KB rate."
    ::= { as2MemoryEntry 42 }

as2memInMemoryOtherFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current in-memory other file KB."
    ::= { as2MemoryEntry 43 }

as2memInMemoryOtherFileKBPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "In-memory other file KB rate."
    ::= { as2MemoryEntry 44 }

as2memMapFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of map files."
    ::= { as2MemoryEntry 45 }

as2memMemoryLimitHighKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "High memory limit, from configuration file."
    ::= { as2MemoryEntry 46 }

as2memMemoryLimitLowKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Low memory limit, from configuration file."
    ::= { as2MemoryEntry 47 }

as2memMemoryUsageKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Memory usage of the server process.  Same as
	    perfmon counter for Process\PrivateBytes."
    ::= { as2MemoryEntry 48 }

as2memOtherFiles OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of other files."
    ::= { as2MemoryEntry 49 }

as2memPagePool1AllocKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Memory borrowed from 64KB page pool, in KB. 
	    This memory is given away to other parts of the
	    server."
    ::= { as2MemoryEntry 50 }

as2memPagePool1LookasideKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory in 8KB lookaside list, in KB. 
	    (Memory pages ready to be used.)"
    ::= { as2MemoryEntry 51 }

as2memPagePool64AllocKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Memory borrowed from system, in KB.  This
	    memory is given away to other parts of the
	    server."
    ::= { as2MemoryEntry 52 }

as2memPagePool64LookasideKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory in 64KB lookaside list, in KB. 
	    (Memory pages ready to be used.)"
    ::= { as2MemoryEntry 53 }

as2memPagePool8AllocKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Memory borrowed from 64KB page pool, in KB. 
	    This memory is given away to other parts of the
	    server."
    ::= { as2MemoryEntry 54 }

as2memPagePool8LookasideKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory in 8KB lookaside list, in KB. 
	    (Memory pages ready to be used.)"
    ::= { as2MemoryEntry 55 }

as2memPotenMemAggregatMapFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory aggregation map file KB."
    ::= { as2MemoryEntry 56 }

as2memPotenMemDimenIndHashFilKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory dimension index (hash)
	    file KB."
    ::= { as2MemoryEntry 57 }

as2memPotenMemDimenProFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory dimension proty file KB."
    ::= { as2MemoryEntry 58 }

as2memPotenMemDimenStringFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory dimension string file KB."
    ::= { as2MemoryEntry 59 }

as2memPotenMemFactAggregFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory fact aggregation file KB."
    ::= { as2MemoryEntry 60 }

as2memPotenMemFactDataFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory fact data file KB."
    ::= { as2MemoryEntry 61 }

as2memPotenMemFactStringFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory fact string file KB."
    ::= { as2MemoryEntry 62 }

as2memPotentialInMemoryMapFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory map file KB."
    ::= { as2MemoryEntry 63 }

as2memPotenMemOtherFileKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Potential in-memory other file KB."
    ::= { as2MemoryEntry 64 }

as2memQuotaBlocked OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of quota requests that are
	    blocked until other memory quotas are freed."
    ::= { as2MemoryEntry 65 }

as2memQuotaKB OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current memory quota, in KB.  Memory quota is
	    also known as a memory grant or memory
	    reservation."
    ::= { as2MemoryEntry 66 }

as2ProactiveCachingTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF ProactiveCachingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services Proactive Caching."
    ::= { analysisServicesV2 9 }

as2ProactiveCachingEntry OBJECT-TYPE
    SYNTAX     ProactiveCachingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ProactiveCachingTable 1 }

ProactiveCachingEntry ::= SEQUENCE {
    as2pcNotificationsPerSec Gauge32,
    as2pcProactiveCachingBeginPerSec Gauge32,
    as2pcProactiveCachCompSec Gauge32,
    as2pcProcessCancellationsSec Gauge32
}

as2pcNotificationsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of notifications from relational
	    database."
    ::= { as2ProactiveCachingEntry 1 }

as2pcProactiveCachingBeginPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of proactive caching begin."
    ::= { as2ProactiveCachingEntry 2 }

as2pcProactiveCachCompSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of proactive caching completion."
    ::= { as2ProactiveCachingEntry 3 }

as2pcProcessCancellationsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of processing cancellations caused by
	    notifications."
    ::= { as2ProactiveCachingEntry 4 }

as2ProcAggregationsTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF ProcAggregationsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services processing of aggregations in MOLAP
	    data files."
    ::= { analysisServicesV2 10 }

as2ProcAggregationsEntry OBJECT-TYPE
    SYNTAX     ProcAggregationsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ProcAggregationsTable 1 }

ProcAggregationsEntry ::= SEQUENCE {
    as2paCurrentPartitions Gauge32,
    as2paMemorySizeBytes Gauge32,
    as2paMemorySizeRows Gauge32,
    as2paRowsCreatedPerSec Gauge32,
    as2paRowsMergedPerSec Gauge32,
    as2paTempFileBytesWrittenPerSec Gauge32,
    as2paTempFileRowsWrittenPerSec Gauge32,
    as2paTotalPartitions Gauge32
}

as2paCurrentPartitions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of partitions being processed."
    ::= { as2ProcAggregationsEntry 1 }

as2paMemorySizeBytes OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Size of current aggregations in memory.  This
	    count is an estimate."
    ::= { as2ProcAggregationsEntry 2 }

as2paMemorySizeRows OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Size of current aggregations in memory.  This
	    count is an estimate."
    ::= { as2ProcAggregationsEntry 3 }

as2paRowsCreatedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of aggregation rows created."
    ::= { as2ProcAggregationsEntry 4 }

as2paRowsMergedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows merged or inserted into an
	    aggregation."
    ::= { as2ProcAggregationsEntry 5 }

as2paTempFileBytesWrittenPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of writing bytes to a temporary file. 
	    Temporary files are written when aggregations
	    exceed memory limits."
    ::= { as2ProcAggregationsEntry 6 }

as2paTempFileRowsWrittenPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of writing rows to a temporary file. 
	    Temporary files are written when aggregations
	    exceed memory limits."
    ::= { as2ProcAggregationsEntry 7 }

as2paTotalPartitions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of partitions processed
	    (successfully or otherwise)."
    ::= { as2ProcAggregationsEntry 8 }

as2ProcIndexesTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesProcIndexesEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services processing of indexes for MOLAP data
	    files."
    ::= { analysisServicesV2 11 }

as2ProcIndexesEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesProcIndexesEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ProcIndexesTable 1 }

AnalysisServicesProcIndexesEntry ::= SEQUENCE {
    as2ProcIndexesCurrentPartitions Gauge32,
    as2ProcIndexesRowsPerSec Gauge32,
    as2ProcIndexesTotalPartitions Gauge32,
    as2ProcIndexesTotalRows Gauge32
}

as2ProcIndexesCurrentPartitions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of partitions being processed."
    ::= { as2ProcIndexesEntry 1 }

as2ProcIndexesRowsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows from MOLAP files used to create
	    indexes."
    ::= { as2ProcIndexesEntry 2 }

as2ProcIndexesTotalPartitions OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of partitions processed
	    (successfully or otherwise)."
    ::= { as2ProcIndexesEntry 3 }

as2ProcIndexesTotalRows OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total rows from MOLAP files used to create
	    indexes."
    ::= { as2ProcIndexesEntry 4 }

as2ProcessingTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesProcessingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services processing of data."
    ::= { analysisServicesV2 12 }

as2ProcessingEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesProcessingEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ProcessingTable 1 }

AnalysisServicesProcessingEntry ::= SEQUENCE {
    as2ProcessingRowsConvertedPerSec Gauge32,
    as2ProcessingRowsReadPerSec Gauge32,
    as2ProcessingRowsWrittenPerSec Gauge32,
    as2ProcessingTotalRowsConverted Gauge32,
    as2ProcessingTotalRowsRead Gauge32,
    as2ProcessingTotalRowsWritten Gauge32
}

as2ProcessingRowsConvertedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows converted during processing."
    ::= { as2ProcessingEntry 1 }

as2ProcessingRowsReadPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows read from all relational
	    databases."
    ::= { as2ProcessingEntry 2 }

as2ProcessingRowsWrittenPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows written during processing."
    ::= { as2ProcessingEntry 3 }

as2ProcessingTotalRowsConverted OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of rows converted during processing."
    ::= { as2ProcessingEntry 4 }

as2ProcessingTotalRowsRead OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of rows read from all relational
	    databases."
    ::= { as2ProcessingEntry 5 }

as2ProcessingTotalRowsWritten OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of rows written during processing."
    ::= { as2ProcessingEntry 6 }

as2StorageEngineQueryTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF StorageEngineQueryEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services storage engine queries."
    ::= { analysisServicesV2 13 }

as2StorageEngineQueryEntry OBJECT-TYPE
    SYNTAX     StorageEngineQueryEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2StorageEngineQueryTable 1 }

StorageEngineQueryEntry ::= SEQUENCE {
    as2seqAggregationHitsPerSec Gauge32,
    as2seqAggregationLookupsPerSec Gauge32,
    as2seqAvgTimePerQuery Gauge32,
    as2seqBytesSentPerSec Gauge32,
    as2seqCalculationCacheHitsPerSec Gauge32,
    as2seqCalculationCacheLookupsSec Gauge32,
    as2seqCurrentDimensionQueries Gauge32,
    as2seqCurrentMeasureGroupQueries Gauge32,
    as2seqDataBytesPerSec Gauge32,
    as2seqDataReadsPerSec Gauge32,
    as2seqDimensionCacheHitsPerSec Gauge32,
    as2seqDimensionCacheLookupSec Gauge32,
    as2seqDimensionQueriesPerSec Gauge32,
    as2seqFlatCacheHitsPerSec Gauge32,
    as2seqFlatCacheLookupsPerSec Gauge32,
    as2seqMapBytesPerSec Gauge32,
    as2seqMapReadsPerSec Gauge32,
    as2seqMeasureGroupCacheHitsSec Gauge32,
    as2seqMeasureGroupCacheLookupSec Gauge32,
    as2seqMeasureGroupQueriesPerSec Gauge32,
    as2seqNetworkRoundTripsPerSec Gauge32,
    as2seqPersistedCacheHitsPerSec Gauge32,
    as2seqsistedCacheLookupsSec Gauge32,
    as2seqQueriesAnsweredPerSec Gauge32,
    as2seqQueryFromCacheDirectSec Gauge32,
    as2seqQueryFromCacheFilteredSec Gauge32,
    as2seqQueriesFromFilePerSec Gauge32,
    as2seqRowsSentPerSec Gauge32,
    as2seqTotalBytesSent Gauge32,
    as2seqTotalDimensionQueries Gauge32,
    as2seqTotalMeasureGroupQueries Gauge32,
    as2seqTotalNetworkRoundTrips Gauge32,
    as2seqTotalQueriesAnswered Gauge32,
    as2seqTotalQueryFromCacheDirect Gauge32,
    as2seqTotalQueryFromCachFiltered Gauge32,
    as2seqTotalQueriesFromFile Gauge32,
    as2seqTotalRowsSent Gauge32
}

as2seqAggregationHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of aggregation hits."
    ::= { as2StorageEngineQueryEntry 1 }

as2seqAggregationLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of aggregation lookups."
    ::= { as2StorageEngineQueryEntry 2 }

as2seqAvgTimePerQuery OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Average time per query, in milliseconds. 
	    Response time based on queries answered since
	    the last counter measurement."
    ::= { as2StorageEngineQueryEntry 3 }

as2seqBytesSentPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of bytes sent by server to clients, in
	    response to queries."
    ::= { as2StorageEngineQueryEntry 4 }

as2seqCalculationCacheHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of calculation cache hits.  This includes
	    global, session, and query scope calculation
	    caches."
    ::= { as2StorageEngineQueryEntry 5 }

as2seqCalculationCacheLookupsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of calculation cache lookups.  This
	    includes global, session, and query scope
	    calculation caches."
    ::= { as2StorageEngineQueryEntry 6 }

as2seqCurrentDimensionQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of dimension queries being
	    actively worked on."
    ::= { as2StorageEngineQueryEntry 7 }

as2seqCurrentMeasureGroupQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Current number of measure group queries being
	    actively worked on."
    ::= { as2StorageEngineQueryEntry 8 }

as2seqDataBytesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Bytes read from the Data file."
    ::= { as2StorageEngineQueryEntry 9 }

as2seqDataReadsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of logical read operations using the
	    Data file."
    ::= { as2StorageEngineQueryEntry 10 }

as2seqDimensionCacheHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of dimension cache hits."
    ::= { as2StorageEngineQueryEntry 11 }

as2seqDimensionCacheLookupSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of dimension cache lookups."
    ::= { as2StorageEngineQueryEntry 12 }

as2seqDimensionQueriesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of dimension queries"
    ::= { as2StorageEngineQueryEntry 13 }

as2seqFlatCacheHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of flat cache hits.  This includes
	    global, session, and query scope flat caches."
    ::= { as2StorageEngineQueryEntry 14 }

as2seqFlatCacheLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of flat cache lookups.  This includes
	    global, session, and query scope flat caches."
    ::= { as2StorageEngineQueryEntry 15 }

as2seqMapBytesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Bytes read from the Map file."
    ::= { as2StorageEngineQueryEntry 16 }

as2seqMapReadsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of logical read operations using the
	    Map file."
    ::= { as2StorageEngineQueryEntry 17 }

as2seqMeasureGroupCacheHitsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of measure group cache hits."
    ::= { as2StorageEngineQueryEntry 18 }

as2seqMeasureGroupCacheLookupSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of measure group cache lookups."
    ::= { as2StorageEngineQueryEntry 19 }

as2seqMeasureGroupQueriesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of measure group queries"
    ::= { as2StorageEngineQueryEntry 20 }

as2seqNetworkRoundTripsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of network round trips.  This includes
	    all client/server communication."
    ::= { as2StorageEngineQueryEntry 21 }

as2seqPersistedCacheHitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of persisted cache hits.  Persisted
	    caches are created by the MDX script CACHE
	    statement."
    ::= { as2StorageEngineQueryEntry 22 }

as2seqsistedCacheLookupsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of sisted cache lookups.  sisted caches
	    are created by the MDX script CACHE statement."
    ::= { as2StorageEngineQueryEntry 23 }

as2seqQueriesAnsweredPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of queries answered."
    ::= { as2StorageEngineQueryEntry 24 }

as2seqQueryFromCacheDirectSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of queries answered from cache directly."
    ::= { as2StorageEngineQueryEntry 25 }

as2seqQueryFromCacheFilteredSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of queries answered by filtering existing
	    cache entry."
    ::= { as2StorageEngineQueryEntry 26 }

as2seqQueriesFromFilePerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of queries answered from files."
    ::= { as2StorageEngineQueryEntry 27 }

as2seqRowsSentPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of rows sent by server to clients."
    ::= { as2StorageEngineQueryEntry 28 }

as2seqTotalBytesSent OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total bytes sent by server to clients, in
	    response to queries."
    ::= { as2StorageEngineQueryEntry 29 }

as2seqTotalDimensionQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of dimension queries."
    ::= { as2StorageEngineQueryEntry 30 }

as2seqTotalMeasureGroupQueries OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of queries to measure group."
    ::= { as2StorageEngineQueryEntry 31 }

as2seqTotalNetworkRoundTrips OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total network round trips.  This includes all
	    client/server communication."
    ::= { as2StorageEngineQueryEntry 32 }

as2seqTotalQueriesAnswered OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of queries answered."
    ::= { as2StorageEngineQueryEntry 33 }

as2seqTotalQueryFromCacheDirect OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of queries derived directly from
	    cache.  Note that this is  partition."
    ::= { as2StorageEngineQueryEntry 34 }

as2seqTotalQueryFromCachFiltered OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total queries answered by filtering existing
	    cache entries."
    ::= { as2StorageEngineQueryEntry 35 }

as2seqTotalQueriesFromFile OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of queries answered from files."
    ::= { as2StorageEngineQueryEntry 36 }

as2seqTotalRowsSent OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total rows sent by server to clients."
    ::= { as2StorageEngineQueryEntry 37 }

as2ThreadsTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF AnalysisServicesThreadsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Statistics related to Microsoft Analysis
	    Services threads."
    ::= { analysisServicesV2 14 }

as2ThreadsEntry OBJECT-TYPE
    SYNTAX     AnalysisServicesThreadsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { as2NameIndex }
    ::= { as2ThreadsTable 1 }

AnalysisServicesThreadsEntry ::= SEQUENCE {
    as2ThdsLongParsingBusyThreads Gauge32,
    as2ThdsLongParsingIdleThreads Gauge32,
    as2ThdsLongParsingJobQueueLength Gauge32,
    as2ThdsLongParsingJobRate Gauge32,
    as2ThdsProcessingPoolBusyThreads Gauge32,
    as2ThdsProcessingPoolIdleThreads Gauge32,
    as2ThdsProcessPoolJobQueueLength Gauge32,
    as2ThdsProcessingPoolJobRate Gauge32,
    as2ThdsQueryPoolBusyThreads Gauge32,
    as2ThdsQueryPoolIdleThreads Gauge32,
    as2ThdsQueryPoolJobQueueLength Gauge32,
    as2ThdsQueryPoolJobRate Gauge32,
    as2ThdsShortParsingBusyThreads Gauge32,
    as2ThdsShortParsingIdleThreads Gauge32,
    as2ThdsShortParsingJobQueueLeng Gauge32,
    as2ThdsShortParsingJobRate Gauge32
}

as2ThdsLongParsingBusyThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of busy threads in the long parsing
	    thread pool."
    ::= { as2ThreadsEntry 1 }

as2ThdsLongParsingIdleThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of idle threads in the long parsing
	    thread pool."
    ::= { as2ThreadsEntry 2 }

as2ThdsLongParsingJobQueueLength OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of jobs in the queue of the long
	    parsing thread pool."
    ::= { as2ThreadsEntry 3 }

as2ThdsLongParsingJobRate OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of jobs through the long parsing thread
	    pool."
    ::= { as2ThreadsEntry 4 }

as2ThdsProcessingPoolBusyThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of busy threads in the processing
	    thread pool."
    ::= { as2ThreadsEntry 5 }

as2ThdsProcessingPoolIdleThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of idle threads in the processing
	    thread pool."
    ::= { as2ThreadsEntry 6 }

as2ThdsProcessPoolJobQueueLength OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of jobs in the queue of the processing
	    thread pool."
    ::= { as2ThreadsEntry 7 }

as2ThdsProcessingPoolJobRate OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of jobs through the processing thread
	    pool."
    ::= { as2ThreadsEntry 8 }

as2ThdsQueryPoolBusyThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of busy threads in the query thread
	    pool."
    ::= { as2ThreadsEntry 9 }

as2ThdsQueryPoolIdleThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of idle threads in the query thread
	    pool."
    ::= { as2ThreadsEntry 10 }

as2ThdsQueryPoolJobQueueLength OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of jobs in the queue of the query
	    thread pool."
    ::= { as2ThreadsEntry 11 }

as2ThdsQueryPoolJobRate OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of jobs through the query thread pool."
    ::= { as2ThreadsEntry 12 }

as2ThdsShortParsingBusyThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of busy threads in the short parsing
	    thread pool."
    ::= { as2ThreadsEntry 13 }

as2ThdsShortParsingIdleThreads OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of idle threads in the short parsing
	    thread pool."
    ::= { as2ThreadsEntry 14 }

as2ThdsShortParsingJobQueueLeng OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of jobs in the queue of the short
	    parsing thread pool."
    ::= { as2ThreadsEntry 15 }

as2ThdsShortParsingJobRate OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Rate of jobs through the short parsing thread
	    pool."
    ::= { as2ThreadsEntry 16 }

sqlServerEngineV2 OBJECT IDENTIFIER
    ::= { sqlServerV2 2 }

ss2NameTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerNameEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "This table contains the list of SQL Server
	    instance names installed. The ss2NameIndex is
	    used to refer to all other SQL Server SNMP
	    entries."
    ::= { sqlServerEngineV2 1 }

ss2NameEntry OBJECT-TYPE
    SYNTAX      SQLServerNameEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    name instance."
    INDEX      { ss2NameIndex }
    ::= { ss2NameTable 1 }

 SQLServerNameEntry ::= SEQUENCE {
    ss2NameIndex Integer32,
    ss2NameInstance InstanceName
}

ss2NameIndex OBJECT-TYPE
    SYNTAX     Integer32 (1..2147483647)
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The index number associated with the instance
	    name"
    ::= { ss2NameEntry 1 }

ss2NameInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The name of the SQL Server installed
	    instance."
    ::= { ss2NameEntry 2 }

ss2AccessMethodsTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerAccessMethodsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Access Methods object in SQL Server
	    provides counters to monitor how the logical
	    data within the database is accessed. Physical
	    access to the database pages on disk is
	    monitored using the Buffer Manager counters.
	    Monitoring the methods used to access data
	    stored in the database can help you to
	    determine whether query performance can be
	    improved by adding or modifying indexes, adding
	    or moving partitions, adding files or file
	    groups, defragmenting indexes, or by rewriting
	    queries. The Access Methods counters can also
	    be used to monitor the amount of data, indexes,
	    and free space within the database, thereby
	    indicating data volume and fragmentation for
	    each server instance. Excessive index
	    fragmentation can impair performance."
    ::= { sqlServerEngineV2 2 }

ss2AccessMethodsEntry OBJECT-TYPE
    SYNTAX      SQLServerAccessMethodsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    AccessMethods instance."
    INDEX      { ss2NameIndex }
    ::= { ss2AccessMethodsTable 1 }

 SQLServerAccessMethodsEntry ::= SEQUENCE {
    ss2amAUCleanupBatchesPerSec Gauge32,
    ss2amAUCleanupsPerSec Gauge32,
    ss2amByReferenceLobCreateCount Gauge32,
    ss2amByReferenceLobUseCount Gauge32,
    ss2amCountLobReadahead Gauge32,
    ss2amCountPullInRow Gauge32,
    ss2amCountPushOffRow Gauge32,
    ss2amDeferredDroppedRowsets Gauge32,
    ss2amDeferredDroppedAUs Gauge32,
    ss2amDroppedRowsetCleanupsPerSec Gauge32,
    ss2amDroppedRowsetsSkippedPerSec Gauge32,
    ss2amExtentDeallocationsPerSec Gauge32,
    ss2amExtentsAllocatedPerSec Gauge32,
    ss2amFailedAUCleanupBatchesSec Gauge32,
    ss2amFailedLeafPageCookie Gauge32,
    ss2amFailedTreePageCookie Gauge32,
    ss2amForwardedRecordsPerSec Gauge32,
    ss2amFreeSpacePageFetchesPerSec Gauge32,
    ss2amFreeSpaceScansPerSec Gauge32,
    ss2amFullScansPerSec Gauge32,
    ss2amIndexSearchesPerSec Gauge32,
    ss2amLobHandleCreateCount Gauge32,
    ss2amLobHandleDestroyCount Gauge32,
    ss2amLobSSProviderCreateCount Gauge32,
    ss2amLobSSProviderDestroyCount Gauge32,
    ss2amLobSSProvideTruncationCount Gauge32,
    ss2amMixedPageAllocationsPerSec Gauge32,
    ss2amPageDeallocationsPerSec Gauge32,
    ss2amPageSplitsPerSec Gauge32,
    ss2amPageCompressionAttemptsSec Gauge32,
    ss2amPagesAllocatedPerSec Gauge32,
    ss2amPagesCompressedPerSec Gauge32,
    ss2amProbeScansPerSec Gauge32,
    ss2amRangeScansPerSec Gauge32,
    ss2amScanPointRevalidationsSec Gauge32,
    ss2amSkippedGhostedRecordsPerSec Gauge32,
    ss2amTableLockEscalationsPerSec Gauge32,
    ss2amUsedLeafPageCookie Gauge32,
    ss2amUsedTreePageCookie Gauge32,
    ss2amWorkfilesCreatedPerSec Gauge32,
    ss2amWorktablesCreatedPerSec Gauge32,
    ss2amWorktablesFromCacheRatio Gauge32
}

ss2amAUCleanupBatchesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of batches that completed
	    successfully per second by the background task
	    that cleans up deferred dropped allocation
	    units."
    ::= { ss2AccessMethodsEntry 1 }

ss2amAUCleanupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of allocation units per second that
	    were successfully dropped by the background
	    task that cleans up deferred dropped allocation
	    units. Each allocation unit drop requires
	    multiple batches."
    ::= { ss2AccessMethodsEntry 2 }

ss2amByReferenceLobCreateCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of large object (LOB) values that were
	    passed by reference. By-reference lobs are used
	    in certain bulk operations to avoid the cost of
	    passing them by value."
    ::= { ss2AccessMethodsEntry 3 }

ss2amByReferenceLobUseCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of by-reference lob values that were
	    used. By-reference lobs are used in certain
	    bulk operations to avoid the cost of passing
	    them by value."
    ::= { ss2AccessMethodsEntry 4 }

ss2amCountLobReadahead OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of lob pages on which readahead was
	    issued."
    ::= { ss2AccessMethodsEntry 5 }

ss2amCountPullInRow OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of values that were pulled in-row from
	    off-row."
    ::= { ss2AccessMethodsEntry 6 }

ss2amCountPushOffRow OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of values that were pushed from in-row
	    to off-row."
    ::= { ss2AccessMethodsEntry 7 }

ss2amDeferredDroppedRowsets OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of rowsets created as a result of
	    aborted online index build operations that are
	    waiting to be dropped by the background task
	    that cleans up deferred dropped rowsets."
    ::= { ss2AccessMethodsEntry 8 }

ss2amDeferredDroppedAUs OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of allocation units waiting to be
	    dropped by the background task that cleans up
	    deferred dropped allocation units."
    ::= { ss2AccessMethodsEntry 9 }

ss2amDroppedRowsetCleanupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of rowsets per second created as a
	    result of aborted online index build operations
	    that were successfully dropped by the
	    background task that cleans up deferred dropped
	    rowsets."
    ::= { ss2AccessMethodsEntry 10 }

ss2amDroppedRowsetsSkippedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of rowsets per second created as a
	    result of aborted online index build operations
	    that were skipped by the background task that
	    cleans up deferred dropped rowsets created."
    ::= { ss2AccessMethodsEntry 11 }

ss2amExtentDeallocationsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of extents deallocated per second in
	    all databases in this SQL Server instance."
    ::= { ss2AccessMethodsEntry 12 }

ss2amExtentsAllocatedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of extents allocated per second in all
	    databases in this SQL Server instance."
    ::= { ss2AccessMethodsEntry 13 }

ss2amFailedAUCleanupBatchesSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of batches  second that failed and
	    required retry, by the background task that
	    cleans up deferred dropped allocation units.
	    Failure could be due to lack of memory or disk
	    space, hardware failure and other reasons."
    ::= { ss2AccessMethodsEntry 14 }

ss2amFailedLeafPageCookie OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times that a leaf page cookie
	    could not be used during an index search since
	    changes happened on the leaf page. The cookie
	    is used to speed up index search."
    ::= { ss2AccessMethodsEntry 15 }

ss2amFailedTreePageCookie OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times that a tree page cookie
	    could not be used during an index search since
	    changes happened on the parent pages of those
	    tree pages. The cookie is used to speed up
	    index search."
    ::= { ss2AccessMethodsEntry 16 }

ss2amForwardedRecordsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of records fetched through forwarded
	    record pointers."
    ::= { ss2AccessMethodsEntry 17 }

ss2amFreeSpacePageFetchesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages fetched per second by free
	    space scans. These scans search for free space
	    within pages already allocated to an allocation
	    unit, to satisfy requests to insert or modify
	    record fragments."
    ::= { ss2AccessMethodsEntry 18 }

ss2amFreeSpaceScansPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of scans per second that were initiated
	    to search for free space within pages already
	    allocated to an allocation unit to insert or
	    modify record fragments. Each scan may find
	    multiple pages."
    ::= { ss2AccessMethodsEntry 19 }

ss2amFullScansPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of unrestricted full scans. These can
	    either be base table or full index scans."
    ::= { ss2AccessMethodsEntry 20 }

ss2amIndexSearchesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of index searches. Index searches are
	    used to start range scans, single index record
	    fetches, and to reposition within an index."
    ::= { ss2AccessMethodsEntry 21 }

ss2amLobHandleCreateCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of temporary LOBs created."
    ::= { ss2AccessMethodsEntry 22 }

ss2amLobHandleDestroyCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of temporary LOBs destroyed."
    ::= { ss2AccessMethodsEntry 23 }

ss2amLobSSProviderCreateCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of LOB Storage Service Providers
	    created. One worktable created per LOB Storage
	    Service Provider."
    ::= { ss2AccessMethodsEntry 24 }

ss2amLobSSProviderDestroyCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of LOB Storage Service Providers
	    destroyed."
    ::= { ss2AccessMethodsEntry 25 }

ss2amLobSSProvideTruncationCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Count of LOB Storage Service Providers
	    truncated."
    ::= { ss2AccessMethodsEntry 26 }

ss2amMixedPageAllocationsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages allocated per second from
	    mixed extents. These could be used for storing
	    the IAM pages and the first eight pages that
	    are allocated to an allocation unit."
    ::= { ss2AccessMethodsEntry 27 }

ss2amPageDeallocationsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages deallocated per second in all
	    databases in this SQL Server instance. These
	    include pages from mixed extents and uniform
	    extents."
    ::= { ss2AccessMethodsEntry 28 }

ss2amPageSplitsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of page splits per second that occur as
	    a result of overflowing index pages."
    ::= { ss2AccessMethodsEntry 29 }

ss2amPageCompressionAttemptsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of attempts to compress a database page
	     second"
    ::= { ss2AccessMethodsEntry 30 }

ss2amPagesAllocatedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages allocated per second in all
	    databases in this SQL Server instance. These
	    include pages allocations from both mixed
	    extents and uniform extents."
    ::= { ss2AccessMethodsEntry 31 }

ss2amPagesCompressedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times a database page was
	    compressed"
    ::= { ss2AccessMethodsEntry 32 }

ss2amProbeScansPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of probe scans per second that are used
	    to find at most one single qualified row in an
	    index or base table directly."
    ::= { ss2AccessMethodsEntry 33 }

ss2amRangeScansPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of qualified range scans through
	    indexes per second."
    ::= { ss2AccessMethodsEntry 34 }

ss2amScanPointRevalidationsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times the scan point had to be
	    revalidated to continue the scan."
    ::= { ss2AccessMethodsEntry 35 }

ss2amSkippedGhostedRecordsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of ghosted records per second skipped
	    during scans."
    ::= { ss2AccessMethodsEntry 36 }

ss2amTableLockEscalationsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times locks on a table were
	    escalated."
    ::= { ss2AccessMethodsEntry 37 }

ss2amUsedLeafPageCookie OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times a leaf page cookie was used
	    successfully during an index search since no
	    change happened on the leaf page. The cookie is
	    used to speed up index search."
    ::= { ss2AccessMethodsEntry 38 }

ss2amUsedTreePageCookie OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times a tree page cookie was used
	    successfully during an index search since no
	    change happened on the parent page of the tree
	    page. The cookie is used to speed up index
	    search."
    ::= { ss2AccessMethodsEntry 39 }

ss2amWorkfilesCreatedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of work files created per second. For
	    example, work files could be used to store
	    temporary results for hash joins and hash
	    aggregates."
    ::= { ss2AccessMethodsEntry 40 }

ss2amWorktablesCreatedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of work tables created per second. For
	    example, work tables could be used to store
	    temporary results for query spool, LOB
	    variables, XML variables, and cursors."
    ::= { ss2AccessMethodsEntry 41 }

ss2amWorktablesFromCacheRatio OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Percentage of work tables created where the
	    initial two pages of the work table were not
	    allocated but were immediately available from
	    the work table cache."
    ::= { ss2AccessMethodsEntry 42 }

ss2BackupDeviceTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBackupDeviceEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Backup Device object provides counters to
	    monitor Microsoft SQL Server backup devices
	    used for backup and restore operations. Monitor
	    backup devices when you want to determine the
	    throughput or the progress and performance of
	    your backup and restore operations on a per
	    device basis. To monitor the throughput of the
	    entire database backup or restore operation,
	    use the Backup/Restore Throughput/sec counter
	    of the SQL Server Databases object."
    ::= { sqlServerEngineV2 3 }

ss2BackupDeviceEntry OBJECT-TYPE
    SYNTAX     SQLServerBackupDeviceEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one particular
	    instance of 'Backup Device' object."
    INDEX      { ss2NameIndex, ss2BackupDeviceInstance }
    ::= { ss2BackupDeviceTable 1 }

SQLServerBackupDeviceEntry ::= SEQUENCE {
    ss2BackupDeviceInstance InstanceName,
    ss2BackupDeviceDeviceputBytesSec Gauge32
}

ss2BackupDeviceInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Instance name."
    ::= { ss2BackupDeviceEntry 1 }

ss2BackupDeviceDeviceputBytesSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Read/write throughput for a backup device."
    ::= { ss2BackupDeviceEntry 2 }

ss2BrokerActivationTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBrokerActivationEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The BrokerActivation performance object
	    contains performance counters that report
	    information on stored procedure activation. "
    ::= { sqlServerEngineV2 4 }

ss2BrokerActivationEntry OBJECT-TYPE
    SYNTAX     SQLServerBrokerActivationEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one particular
	    instance of 'Broker Activation' object."
    INDEX      { ss2NameIndex, ss2baInstance }
    ::= { ss2BrokerActivationTable 1 }

SQLServerBrokerActivationEntry ::= SEQUENCE {
    ss2baInstance InstanceName,
    ss2baStoredProceduresInvokedSec Gauge32,
    ss2baTaskLimitReached Gauge32,
    ss2baTaskLimitReachedPerSec Gauge32,
    ss2baTasksAbortedPerSec Gauge32,
    ss2baTasksRunning Gauge32,
    ss2baTasksStartedPerSec Gauge32
}

ss2baInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Instance name."
    ::= { ss2BrokerActivationEntry 1 }

ss2baStoredProceduresInvokedSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of stored procedures that are being
	    invoked  second."
    ::= { ss2BrokerActivationEntry 2 }

ss2baTaskLimitReached OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The total number of times the activated task
	    limit on a queue has been reached."
    ::= { ss2BrokerActivationEntry 3 }

ss2baTaskLimitReachedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times the activated task limit
	    on a queue has been reached per second."
    ::= { ss2BrokerActivationEntry 4 }

ss2baTasksAbortedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of activated tasks that are being
	    aborted per second."
    ::= { ss2BrokerActivationEntry 5 }

ss2baTasksRunning OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The total number of activated tasks that are
	    currently running."
    ::= { ss2BrokerActivationEntry 6 }

ss2baTasksStartedPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of activated tasks that are being
	    started per second."
    ::= { ss2BrokerActivationEntry 7 }

ss2BrokerStatisticsTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBrokerStatisticsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Broker Statistics performance object
	    contains performance counters that report
	    general Service Broker information for an
	    instance of the Database Engine."
    ::= { sqlServerEngineV2 5 }

ss2BrokerStatisticsEntry OBJECT-TYPE
    SYNTAX      SQLServerBrokerStatisticsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    BrokerStatistics instance."
    INDEX      { ss2NameIndex }
    ::= { ss2BrokerStatisticsTable 1 }

 SQLServerBrokerStatisticsEntry ::= SEQUENCE {
    ss2bsActivationErrorsTotal Gauge32,
    ss2bsBrokerTransactionRollbacks Gauge32,
    ss2bsCorruptedMessagesTotal Gauge32,
    ss2bsDequeuedTransmissionQMsgSec Gauge32,
    ss2bsDialogTimerEventCount Gauge32,
    ss2bsDroppedMessagesTotal Gauge32,
    ss2bsEnqueuedLocalMessagesTotal Gauge32,
    ss2bsEnqueuedLocalMessagesPerSec Gauge32,
    ss2bsEnqueuedMessagesTotal Gauge32,
    ss2bsEnqueuedMessagesPerSec Gauge32,
    ss2bsEnqueuedP1MessagesPerSec Gauge32,
    ss2bsEnqueuedP10MessagesPerSec Gauge32,
    ss2bsEnqueuedP2MessagesPerSec Gauge32,
    ss2bsEnqueuedP3MessagesPerSec Gauge32,
    ss2bsEnqueuedP4MessagesPerSec Gauge32,
    ss2bsEnqueuedP5MessagesPerSec Gauge32,
    ss2bsEnqueuedP6MessagesPerSec Gauge32,
    ss2bsEnqueuedP7MessagesPerSec Gauge32,
    ss2bsEnqueuedP8MessagesPerSec Gauge32,
    ss2bsEnqueuedP9MessagesPerSec Gauge32,
    ss2bsEnqueuedTransmissionQMsgSec Gauge32,
    ss2bsEnqueuedTransportMsgFragTot Gauge32,
    ss2bsEnqueuedTransportMsgFragSec Gauge32,
    ss2bsEnqueuedTransportMsgsTotal Gauge32,
    ss2bsEnqueuedTransportMsgsPerSec Gauge32,
    ss2bsForwardedMessagesTotal Gauge32,
    ss2bsForwardedMessagesPerSec Gauge32,
    ss2bsForwardedMsgByteTotal Gauge32,
    ss2bsForwardedMsgBytesPerSec Gauge32,
    ss2bsForwardedMsgDiscardedTotal Gauge32,
    ss2bsForwardedMsgsDiscardedSec Gauge32,
    ss2bsForwardedPendingMsgBytes Gauge32,
    ss2bsForwardedPendingMsgCount Gauge32,
    ss2bsSQLReceiveTotal Gauge32,
    ss2bsSQLReceivesPerSec Gauge32,
    ss2bsSQLSendTotal Gauge32,
    ss2bsSQLSendsPerSec Gauge32
}

ss2bsActivationErrorsTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times an activation stored
	    procedure exited with an error."
    ::= { ss2BrokerStatisticsEntry 1 }

ss2bsBrokerTransactionRollbacks OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of Service Broker related
	    transactions that have rolled back."
    ::= { ss2BrokerStatisticsEntry 2 }

ss2bsCorruptedMessagesTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of corrupted messages that were
	    received in the instance."
    ::= { ss2BrokerStatisticsEntry 3 }

ss2bsDequeuedTransmissionQMsgSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages that have been removed
	    from the broker transmission queue	second."
    ::= { ss2BrokerStatisticsEntry 4 }

ss2bsDialogTimerEventCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of dialog endpoint related timer
	    events in the Broker."
    ::= { ss2BrokerStatisticsEntry 5 }

ss2bsDroppedMessagesTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages that were received in
	    the instance but could not be delivered."
    ::= { ss2BrokerStatisticsEntry 6 }

ss2bsEnqueuedLocalMessagesTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of messages from local endpoints
	    that are successfully delivered directly into
	    local target queues."
    ::= { ss2BrokerStatisticsEntry 7 }

ss2bsEnqueuedLocalMessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages from local endpoints
	    that are successfully delivered directly into
	    local target queues per second."
    ::= { ss2BrokerStatisticsEntry 8 }

ss2bsEnqueuedMessagesTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of messages from local endpoints
	    and the transport that are successfully
	    delivered into local target queues."
    ::= { ss2BrokerStatisticsEntry 9 }

ss2bsEnqueuedMessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages from local endpoints
	    and the transport that are successfully
	    delivered into local target queues per second."
    ::= { ss2BrokerStatisticsEntry 10 }

ss2bsEnqueuedP1MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 1 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 11 }

ss2bsEnqueuedP10MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 10 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 12 }

ss2bsEnqueuedP2MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 2 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 13 }

ss2bsEnqueuedP3MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 3 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 14 }

ss2bsEnqueuedP4MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 4 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 15 }

ss2bsEnqueuedP5MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 5 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 16 }

ss2bsEnqueuedP6MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 6 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 17 }

ss2bsEnqueuedP7MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 7 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 18 }

ss2bsEnqueuedP8MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 8 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 19 }

ss2bsEnqueuedP9MessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 9 messages from local
	    endpoints and the transport that are
	    successfully delivered into local target queues
	    per second."
    ::= { ss2BrokerStatisticsEntry 20 }

ss2bsEnqueuedTransmissionQMsgSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages that have been placed
	    into the broker transmission queue	second."
    ::= { ss2BrokerStatisticsEntry 21 }

ss2bsEnqueuedTransportMsgFragTot OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of message fragments from the
	    transport that are successfully delivered into
	    local target queues. Note that the message can
	    be marked as disabled if it is incomplete
	    and/or out of order."
    ::= { ss2BrokerStatisticsEntry 22 }

ss2bsEnqueuedTransportMsgFragSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of message fragments from the
	    transport that are successfully delivered into
	    local target queues  second. Note that the
	    message can be marked as disabled if it is
	    incomplete and/or out of order."
    ::= { ss2BrokerStatisticsEntry 23 }

ss2bsEnqueuedTransportMsgsTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of messages from the transport
	    that are successfully delivered into local
	    target queues. This includes all messages from
	    remote endpoints and messages from local
	    endpoints which go through the transport."
    ::= { ss2BrokerStatisticsEntry 24 }

ss2bsEnqueuedTransportMsgsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of messages from the transport that
	    are successfully delivered into local target
	    queues per second. This includes all messages
	    from remote endpoints and messages from local
	    endpoints which go through the transport."
    ::= { ss2BrokerStatisticsEntry 25 }

ss2bsForwardedMessagesTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of forwarded messages
	    successfully sent."
    ::= { ss2BrokerStatisticsEntry 26 }

ss2bsForwardedMessagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of forwarded messages successfully
	    sent per second."
    ::= { ss2BrokerStatisticsEntry 27 }

ss2bsForwardedMsgByteTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of forwarded message bytes
	    successfully sent."
    ::= { ss2BrokerStatisticsEntry 28 }

ss2bsForwardedMsgBytesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of forwarded message bytes
	    successfully sent per second."
    ::= { ss2BrokerStatisticsEntry 29 }

ss2bsForwardedMsgDiscardedTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of forwarded messages discarded
	    due to forwarded message memory limits, age
	    limits, etc."
    ::= { ss2BrokerStatisticsEntry 30 }

ss2bsForwardedMsgsDiscardedSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of forwarded messages that were
	    discarded  second due to forwarded message
	    memory limits, age limits, etc."
    ::= { ss2BrokerStatisticsEntry 31 }

ss2bsForwardedPendingMsgBytes OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of forwarded message bytes that
	    have not been successfully sent yet."
    ::= { ss2BrokerStatisticsEntry 32 }

ss2bsForwardedPendingMsgCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of forwarded messages that have not
	    been successfully sent yet."
    ::= { ss2BrokerStatisticsEntry 33 }

ss2bsSQLReceiveTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of SQL RECEIVE commands processed
	    by the Broker."
    ::= { ss2BrokerStatisticsEntry 34 }

ss2bsSQLReceivesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of SQL RECEIVE commands processed
	    by the Broker per second."
    ::= { ss2BrokerStatisticsEntry 35 }

ss2bsSQLSendTotal OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of SQL SEND commands processed by
	    the Broker."
    ::= { ss2BrokerStatisticsEntry 36 }

ss2bsSQLSendsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of SQL SEND commands processed by
	    the Broker per second."
    ::= { ss2BrokerStatisticsEntry 37 }

ss2BrokerTOStatisticsTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF BrokerTOStatisticsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Broker TO Statistics performance object
	    reports information about how many times
	    Service Broker dialogs request transmission
	    objects, and how often transmission objects are
	    written to tempdb.
	    
	    Transmission objects record the state of
	    message transmissions for a Service Broker
	    dialog. They are stored in memory. To free
	    memory, Service Broker periodically writes
	    batches of inactive transmission objects to
	    work tables in tempdb."
    ::= { sqlServerEngineV2 6 }

ss2BrokerTOStatisticsEntry OBJECT-TYPE
    SYNTAX     BrokerTOStatisticsEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    BrokerTOStatistics instance."
    INDEX      { ss2NameIndex }
    ::= { ss2BrokerTOStatisticsTable 1 }

BrokerTOStatisticsEntry ::= SEQUENCE {
    ss2btosAvgLengthOfBatchedWrites Gauge32,
    ss2btosAvgTimeBetweenBatchesMs Gauge32,
    ss2btosAvgTimeToWriteBatchMs Gauge32,
    ss2btosTransmissionObjGetsPerSec Gauge32,
    ss2btosTransmissionObjSetDirtSec Gauge32,
    ss2btosTransmissionObjWritesSec Gauge32
}

ss2btosAvgLengthOfBatchedWrites OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Average Number of Transmission Objects saved
	    in a batch."
    ::= { ss2BrokerTOStatisticsEntry 1 }

ss2btosAvgTimeBetweenBatchesMs OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Average time between Transmission Object batch
	    flushes."
    ::= { ss2BrokerTOStatisticsEntry 2 }

ss2btosAvgTimeToWriteBatchMs OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Average time to save a Transmission Object
	    batch."
    ::= { ss2BrokerTOStatisticsEntry 3 }

ss2btosTransmissionObjGetsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of Transmission Objects requested
	    per second."
    ::= { ss2BrokerTOStatisticsEntry 4 }

ss2btosTransmissionObjSetDirtSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of Transmission Objects marked
	    dirty  second."
    ::= { ss2BrokerTOStatisticsEntry 5 }

ss2btosTransmissionObjWritesSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of Transmission Objects saved 
	    second."
    ::= { ss2BrokerTOStatisticsEntry 6 }

ss2BrokerPerDBMTransportTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF BrokerPerDBMTransportEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Broker / DBM Transport performance object
	    contains performance counters that report
	    networking information for Service Broker and
	    database mirroring."
    ::= { sqlServerEngineV2 7 }

ss2BrokerPerDBMTransportEntry OBJECT-TYPE
    SYNTAX     BrokerPerDBMTransportEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    BrokerPerDBMTransport instance."
    INDEX      { ss2NameIndex }
    ::= { ss2BrokerPerDBMTransportTable 1 }

BrokerPerDBMTransportEntry ::= SEQUENCE {
    ss2bdtCurrentBytesForRecvIPerO Gauge32,
    ss2bdtCurrentBytesForSendIPerO Gauge32,
    ss2bdtCurrentMsgFragForSendIO Gauge32,
    ss2bdtMessageFragmentP1SenSec Gauge32,
    ss2bdtMsgFragmentP10SendsSec Gauge32,
    ss2bdtMsgFragmentP2SendsSec Gauge32,
    ss2bdtMsgFragmentP3SendsSec Gauge32,
    ss2bdtMsgFragmentP4SendsSec Gauge32,
    ss2bdtMsgFragmentP5SendsSec Gauge32,
    ss2bdtMsgFragmentP6SendsSec Gauge32,
    ss2bdtMsgFragmentP7SendsSec Gauge32,
    ss2bdtMsgFragmentP8SendsSec Gauge32,
    ss2bdtMsgFragmentP9SendsSec Gauge32,
    ss2bdtMsgFragmentReceivesSec Gauge32,
    ss2bdtMessageFragmentSendsPerSec Gauge32,
    ss2bdtMsgFragmentRecvSizeAvg Gauge32,
    ss2bdtMsgFragmentSendSizeAvg Gauge32,
    ss2bdtOpenConnectionCount Gauge32,
    ss2bdtPendingBytesForRecvIPerO Gauge32,
    ss2bdtPendingBytesForSendIPerO Gauge32,
    ss2bdtPendingMsgFragForRecvIO Gauge32,
    ss2bdtPendingMsgFragForSendIO Gauge32,
    ss2bdtReceiveIPerOLenAvg Gauge32,
    ss2bdtReceiveIPerOBytesPerSec Gauge32,
    ss2bdtReceiveIPerOsPerSec Gauge32,
    ss2bdtRecvIPerOBufferCopiesCount Gauge32,
    ss2bdtRecvIOBufferCopiesBytesSec Gauge32,
    ss2bdtSendIPerOLenAvg Gauge32,
    ss2bdtSendIPerOBytesPerSec Gauge32,
    ss2bdtSendIPerOsPerSec Gauge32
}

ss2bdtCurrentBytesForRecvIPerO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of bytes associated with current
	    transport receive I/O operations that haven't
	    completed."
    ::= { ss2BrokerPerDBMTransportEntry 1 }

ss2bdtCurrentBytesForSendIPerO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of buffer bytes associated with
	    current transport send I/O operations that
	    haven't completed."
    ::= { ss2BrokerPerDBMTransportEntry 2 }

ss2bdtCurrentMsgFragForSendIO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The current number of message fragments
	    associated with current transport send I/O
	    oations that haven't completed."
    ::= { ss2BrokerPerDBMTransportEntry 3 }

ss2bdtMessageFragmentP1SenSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 1 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 4 }

ss2bdtMsgFragmentP10SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 10 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 5 }

ss2bdtMsgFragmentP2SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 2 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 6 }

ss2bdtMsgFragmentP3SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 3 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 7 }

ss2bdtMsgFragmentP4SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 4 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 8 }

ss2bdtMsgFragmentP5SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 5 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 9 }

ss2bdtMsgFragmentP6SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 6 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 10 }

ss2bdtMsgFragmentP7SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 7 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 11 }

ss2bdtMsgFragmentP8SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 8 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 12 }

ss2bdtMsgFragmentP9SendsSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of priority 9 message fragments
	    sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 13 }

ss2bdtMsgFragmentReceivesSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of message fragments received 
	    second in transport receive I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 14 }

ss2bdtMessageFragmentSendsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of message fragments sent per
	    second in transport send I/O operations."
    ::= { ss2BrokerPerDBMTransportEntry 15 }

ss2bdtMsgFragmentRecvSizeAvg OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The average byte size of message fragments
	    received in transport receive I/O operations."
    ::= { ss2BrokerPerDBMTransportEntry 16 }

ss2bdtMsgFragmentSendSizeAvg OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The average byte size of message fragments
	    sent in transport send I/O operations."
    ::= { ss2BrokerPerDBMTransportEntry 17 }

ss2bdtOpenConnectionCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The total number of transport connections
	    currently open."
    ::= { ss2BrokerPerDBMTransportEntry 18 }

ss2bdtPendingBytesForRecvIPerO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of bytes associated with in
	    completed transport receive I/O operations
	    whose message fragments haven't been enqueued
	    (or rejected) yet."
    ::= { ss2BrokerPerDBMTransportEntry 19 }

ss2bdtPendingBytesForSendIPerO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of buffer bytes associated with
	    message fragments being marshalled, or
	    marshalled and ready to be sent with send I/O
	    operations."
    ::= { ss2BrokerPerDBMTransportEntry 20 }

ss2bdtPendingMsgFragForRecvIO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The current number of message fragments
	    received in transport receive I/O oations that
	    have not been enqueued (or rejected) yet."
    ::= { ss2BrokerPerDBMTransportEntry 21 }

ss2bdtPendingMsgFragForSendIO OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The current number of message fragments that
	    are being marshalled, or marshalled and ready
	    to be sent via the transport layer."
    ::= { ss2BrokerPerDBMTransportEntry 22 }

ss2bdtReceiveIPerOLenAvg OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The average byte length of transport receive
	    I/O operations."
    ::= { ss2BrokerPerDBMTransportEntry 23 }

ss2bdtReceiveIPerOBytesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of transport receive I/O bytes per
	    second."
    ::= { ss2BrokerPerDBMTransportEntry 24 }

ss2bdtReceiveIPerOsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of transport receives I/O per
	    second. Note that a transport receive I/O may
	    contain more than one message fragment."
    ::= { ss2BrokerPerDBMTransportEntry 25 }

ss2bdtRecvIPerOBufferCopiesCount OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of times when transport receive I/O
	    operations had to move buffer fragments in
	    memory."
    ::= { ss2BrokerPerDBMTransportEntry 26 }

ss2bdtRecvIOBufferCopiesBytesSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The rate at which transport receive I/O
	    oations had to move buffer fragments in
	    memory."
    ::= { ss2BrokerPerDBMTransportEntry 27 }

ss2bdtSendIPerOLenAvg OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The average byte length of transport send I/O
	    operations."
    ::= { ss2BrokerPerDBMTransportEntry 28 }

ss2bdtSendIPerOBytesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of transport send I/O bytes per
	    second."
    ::= { ss2BrokerPerDBMTransportEntry 29 }

ss2bdtSendIPerOsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "The number of transport send I/Os per second.
	    Note that a transport send I/O may contain more
	    than one message fragment."
    ::= { ss2BrokerPerDBMTransportEntry 30 }

ss2BufferManagerTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBufferManagerEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Buffer Manager object provides counters to
	    monitor how SQL Server uses:
	    
		* Memory to store data pages, internal data
	    structures, and the procedure cache.
		* Counters to monitor the physical I/O as
	    SQL Server reads and writes database pages.
	    
	    Monitoring the memory and the counters used by
	    SQL Server helps you determine:
	    
		* If bottlenecks exist from inadequate
	    physical memory. If it cannot store frequently
	    accessed data in cache, SQL Server must
	    retrieve the data from disk.
		* If query performance can be improved by
	    adding more memory, or by making more memory
	    available to the data cache or SQL Server
	    internal structures.
		* How often SQL Server needs to read data
	    from disk. Compared with other operations, such
	    as memory access, physical I/O consumes a lot
	    of time. Minimizing physical I/O can improve
	    query performance.
	    
	    You can also monitor Address Windowing
	    Extensions (AWE) activity in SQL Server with
	    the AWE counters. For example, you can make
	    sure that SQL Server has enough memory
	    allocated for AWE to run properly."
    ::= { sqlServerEngineV2 8 }

ss2BufferManagerEntry OBJECT-TYPE
    SYNTAX      SQLServerBufferManagerEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server
	    BufferManager instance."
    INDEX      { ss2NameIndex }
    ::= { ss2BufferManagerTable 1 }

 SQLServerBufferManagerEntry ::= SEQUENCE {
    ss2bmAWELookupMapsPerSec Gauge32,
    ss2bmAWEStolenMapsPerSec Gauge32,
    ss2bmAWEUnmapCallsPerSec Gauge32,
    ss2bmAWEUnmapPagesPerSec Gauge32,
    ss2bmAWEWriteMapsPerSec Gauge32,
    ss2bmBufferCacheHitRatio Gauge32,
    ss2bmCheckpointPagesPerSec Gauge32,
    ss2bmDatabasePages Gauge32,
    ss2bmFreeListStallsPerSec Gauge32,
    ss2bmFreePages Gauge32,
    ss2bmLazyWritesPerSec Gauge32,
    ss2bmPageLifeExpectancy Gauge32,
    ss2bmPageLookupsPerSec Gauge32,
    ss2bmPageReadsPerSec Gauge32,
    ss2bmPageWritesPerSec Gauge32,
    ss2bmReadaheadPagesPerSec Gauge32,
    ss2bmReservedPages Gauge32,
    ss2bmStolenPages Gauge32,
    ss2bmTargetPages Gauge32,
    ss2bmTotalPages Gauge32
}

ss2bmAWELookupMapsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of AWE map calls made for pages found
	    in the buffer pool."
    ::= { ss2BufferManagerEntry 1 }

ss2bmAWEStolenMapsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of AWE map calls made for pages stolen
	    from the buffer pool."
    ::= { ss2BufferManagerEntry 2 }

ss2bmAWEUnmapCallsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of AWE unmap calls."
    ::= { ss2BufferManagerEntry 3 }

ss2bmAWEUnmapPagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of AWE pages unmapped."
    ::= { ss2BufferManagerEntry 4 }

ss2bmAWEWriteMapsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of AWE map calls made for pages to be
	    written to disk."
    ::= { ss2BufferManagerEntry 5 }

ss2bmBufferCacheHitRatio OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Percentage of pages that were found in the
	    buffer pool without having to incur a read from
	    disk."
    ::= { ss2BufferManagerEntry 6 }

ss2bmCheckpointPagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages flushed by checkpoint or other
	    operations that require all dirty pages to be
	    flushed."
    ::= { ss2BufferManagerEntry 7 }

ss2bmDatabasePages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages in the buffer pool with
	    database content."
    ::= { ss2BufferManagerEntry 8 }

ss2bmFreeListStallsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of requests that had to wait for a free
	    page."
    ::= { ss2BufferManagerEntry 9 }

ss2bmFreePages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of pages on all free lists."
    ::= { ss2BufferManagerEntry 10 }

ss2bmLazyWritesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of buffers written by buffer manager's
	    lazy writer."
    ::= { ss2BufferManagerEntry 11 }

ss2bmPageLifeExpectancy OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of seconds a page will stay in the
	    buffer pool without references."
    ::= { ss2BufferManagerEntry 12 }

ss2bmPageLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of requests to find a page in the
	    buffer pool."
    ::= { ss2BufferManagerEntry 13 }

ss2bmPageReadsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of physical database page reads
	    issued."
    ::= { ss2BufferManagerEntry 14 }

ss2bmPageWritesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of physical database page writes
	    issued."
    ::= { ss2BufferManagerEntry 15 }

ss2bmReadaheadPagesPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages read in anticipation of use."
    ::= { ss2BufferManagerEntry 16 }

ss2bmReservedPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of buffer pool reserved pages."
    ::= { ss2BufferManagerEntry 17 }

ss2bmStolenPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages used for miscellaneous server
	    purposes (including procedure cache)."
    ::= { ss2BufferManagerEntry 18 }

ss2bmTargetPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Ideal number of pages in the buffer pool."
    ::= { ss2BufferManagerEntry 19 }

ss2bmTotalPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages in the buffer pool (includes
	    database, free, and stolen)."
    ::= { ss2BufferManagerEntry 20 }

ss2BufferNodeTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBufferNodeEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Buffer Node object provides counters that
	    complement counters provided by the Buffer
	    Manager object. It allows you to monitor the
	    SQL Server buffer pool page distribution for
	    each non-uniform memory access (NUMA) node.
	    There is an instance of the Buffer Node object
	    for each NUMA node in use. On non-NUMA
	    architecture there will be a single instance of
	    the Buffer Node object."
    ::= { sqlServerEngineV2 9 }

ss2BufferNodeEntry OBJECT-TYPE
    SYNTAX     SQLServerBufferNodeEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one particular
	    instance of 'Buffer Node' object."
    INDEX      { ss2NameIndex, ss2bnInstance }
    ::= { ss2BufferNodeTable 1 }

SQLServerBufferNodeEntry ::= SEQUENCE {
    ss2bnInstance InstanceName,
    ss2bnDatabasePages Gauge32,
    ss2bnForeignPages Gauge32,
    ss2bnFreePages Gauge32,
    ss2bnLocalNodePageLookupsPerSec Gauge32,
    ss2bnPageLifeExpectancy Gauge32,
    ss2bnRemoteNodePageLookupsPerSec Gauge32,
    ss2bnStolenPages Gauge32,
    ss2bnTargetPages Gauge32,
    ss2bnTotalPages Gauge32
}

ss2bnInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Instance name."
    ::= { ss2BufferNodeEntry 1 }

ss2bnDatabasePages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages in the buffer pool with
	    database content."
    ::= { ss2BufferNodeEntry 2 }

ss2bnForeignPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages which are not from NUMA-local
	    memory."
    ::= { ss2BufferNodeEntry 3 }

ss2bnFreePages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of pages on all free lists."
    ::= { ss2BufferNodeEntry 4 }

ss2bnLocalNodePageLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of lookup requests from this node which
	    were satisfied from this node."
    ::= { ss2BufferNodeEntry 5 }

ss2bnPageLifeExpectancy OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of seconds a page will stay in the
	    buffer pool without references."
    ::= { ss2BufferNodeEntry 6 }

ss2bnRemoteNodePageLookupsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of lookup requests from this node which
	    were satisfied from other nodes."
    ::= { ss2BufferNodeEntry 7 }

ss2bnStolenPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages used for miscellaneous server
	    purposes (including procedure cache)."
    ::= { ss2BufferNodeEntry 8 }

ss2bnTargetPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Ideal number of pages in the buffer pool."
    ::= { ss2BufferNodeEntry 9 }

ss2bnTotalPages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of pages in the buffer pool (includes
	    database, free, and stolen)."
    ::= { ss2BufferNodeEntry 10 }

ss2BufferPartitionTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerBufferPartitionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The Buffer Partition object provides counters
	    to monitor how SQL Server uses free pages."
    ::= { sqlServerEngineV2 10 }

ss2BufferPartitionEntry OBJECT-TYPE
    SYNTAX     SQLServerBufferPartitionEntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one particular
	    instance of 'Buffer Partition' object."
    INDEX      { ss2NameIndex, ss2bpInstance }
    ::= { ss2BufferPartitionTable 1 }

SQLServerBufferPartitionEntry ::= SEQUENCE {
    ss2bpInstance InstanceName,
    ss2bpFreeListEmptyPerSec Gauge32,
    ss2bpFreeListRequestsPerSec Gauge32,
    ss2bpFreePages Gauge32
}

ss2bpInstance OBJECT-TYPE
    SYNTAX     InstanceName
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Instance name."
    ::= { ss2BufferPartitionEntry 1 }

ss2bpFreeListEmptyPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times a free page was requested and
	    none were available."
    ::= { ss2BufferPartitionEntry 2 }

ss2bpFreeListRequestsPerSec OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Number of times a free page was requested."
    ::= { ss2BufferPartitionEntry 3 }

ss2bpFreePages OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total number of pages on all free lists."
    ::= { ss2BufferPartitionEntry 4 }

ss2CLRTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerCLREntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "The CLR object provides counters to monitor
	    common language runtime (CLR) execution in
	    Microsoft SQL Server."
    ::= { sqlServerEngineV2 11 }

ss2CLREntry OBJECT-TYPE
    SYNTAX      SQLServerCLREntry
    MAX-ACCESS not-accessible
    STATUS     current
    DESCRIPTION
	    "Performance information for one SQL Server CLR
	    instance."
    INDEX      { ss2NameIndex }
    ::= { ss2CLRTable 1 }

 SQLServerCLREntry ::= SEQUENCE {
    ss2CLRCLRExecution Gauge32
}

ss2CLRCLRExecution OBJECT-TYPE
    SYNTAX     Gauge32
    MAX-ACCESS read-only
    STATUS     current
    DESCRIPTION
	    "Total Execution time in CLR ( microseconds )."
    ::= { ss2CLREntry 1 }

ss2CatalogMetadataTable OBJECT-TYPE
    SYNTAX     SEQUENCE OF SQLServerCatalogMetadataEntry
    MAX-ACCESS not-acces