INFORMANT-SQLSERVER-V2 DEFINITIONS ::= BEGIN

IMPORTS
    OBJECT-TYPE
        FROM RFC-1212
    Gauge
        FROM RFC1155-SMI
    InstanceName, informant
        FROM WTCS;

sqlServerV2 OBJECT IDENTIFIER
    ::= { informant 13 }

-- 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 As2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      As2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one Analysis
         Services name instance."
    INDEX       { as2NameIndex }
    ::= { as2NameTable 1 }

As2NameEntry ::= SEQUENCE {
    as2NameIndex        INTEGER,
    as2NameInstance     InstanceName
}

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

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

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

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

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

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

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

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

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

as2CacheEvictionsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Rate of insertions into the cache.  This is
         per partition per cube per database."
    ::= { as2CacheEntry 6 }

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

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

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

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

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

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

as2CacheTotalFiltIteratorCachMis OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Insertions into the cache.  This is per
         partition per cube per database."
    ::= { as2CacheEntry 14 }

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

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

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

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

As2ConnectionEntry ::= SEQUENCE {
    as2ConnectionCurrentConnections     Gauge,
    as2ConnectionCurrentUserSessions    Gauge,
    as2ConnectionFailuresPerSec         Gauge,
    as2ConnectionRequestsPerSec         Gauge,
    as2ConnectionSuccessesPerSec        Gauge,
    as2ConnectionTotalFailures          Gauge,
    as2ConnectionTotalRequests          Gauge,
    as2ConnectionTotalSuccesses         Gauge
}

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

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

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

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

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

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

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

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

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

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

As2DataMiningModelProcessEntry ::= SEQUENCE {
    as2dmmpCasesPerSec              Gauge,
    as2dmmpCurrentModelsProcessing  Gauge
}

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

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

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

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

As2DataMiningPredictionEntry ::= SEQUENCE {
    as2dmpConcurrentDMQueries   Gauge,
    as2dmpPredictionsPerSec     Gauge,
    as2dmpQueriesPerSec         Gauge,
    as2dmpRowsPerSec            Gauge,
    as2dmpTotalPredictions      Gauge,
    as2dmpTotalQueries          Gauge,
    as2dmpTotalRows             Gauge
}

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

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

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

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

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

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

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

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

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

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

as2LocksCurrentLatchWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current number of clients waiting for a lock."
    ::= { as2LocksEntry 2 }

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

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

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

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

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

as2LocksLockWaitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of deadlocks detected."
    ::= { as2LocksEntry 9 }

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

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

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

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

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

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

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

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

as2MDXNumOfCachedotherEvalNode OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cached Storage Engine
         evaluation nodes built by MDX execution plans"
    ::= { as2MDXEntry 6 }

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

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

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

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

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

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

as2MDXNumEvalNodeCalcSameGranula OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache evictions of evaluation
         nodes due to collisions"
    ::= { as2MDXEntry 14 }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

as2memPagePool1AllocKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current memory in 8KB lookaside list, in KB. 
         (Memory pages ready to be used.)"
    ::= { as2MemoryEntry 51 }

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

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

as2memPagePool8AllocKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current memory in 8KB lookaside list, in KB. 
         (Memory pages ready to be used.)"
    ::= { as2MemoryEntry 55 }

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

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

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

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

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

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

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

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

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

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

as2memQuotaKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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 As2ProactiveCachingEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Statistics related to Microsoft Analysis
         Services Proactive Caching."
    ::= { analysisServicesV2 9 }

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

As2ProactiveCachingEntry ::= SEQUENCE {
    as2pcNotificationsPerSec            Gauge,
    as2pcProactiveCachingBeginPerSec    Gauge,
    as2pcProactiveCachCompSec           Gauge,
    as2pcProcessCancellationsSec        Gauge
}

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

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

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

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

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

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

As2ProcAggregationsEntry ::= SEQUENCE {
    as2paCurrentPartitions              Gauge,
    as2paMemorySizeBytes                Gauge,
    as2paMemorySizeRows                 Gauge,
    as2paRowsCreatedPerSec              Gauge,
    as2paRowsMergedPerSec               Gauge,
    as2paTempFileBytesWrittenPerSec     Gauge,
    as2paTempFileRowsWrittenPerSec      Gauge,
    as2paTotalPartitions                Gauge
}

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

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

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

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

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

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

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

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

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

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

As2ProcIndexesEntry ::= SEQUENCE {
    as2ProcIndexesCurrentPartitions     Gauge,
    as2ProcIndexesRowsPerSec            Gauge,
    as2ProcIndexesTotalPartitions       Gauge,
    as2ProcIndexesTotalRows             Gauge
}

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

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

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

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

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

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

As2ProcessingEntry ::= SEQUENCE {
    as2ProcessingRowsConvertedPerSec    Gauge,
    as2ProcessingRowsReadPerSec         Gauge,
    as2ProcessingRowsWrittenPerSec      Gauge,
    as2ProcessingTotalRowsConverted     Gauge,
    as2ProcessingTotalRowsRead          Gauge,
    as2ProcessingTotalRowsWritten       Gauge
}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

sqlServerEngineV2 OBJECT IDENTIFIER
    ::= { sqlServerV2 2 }

ss2NameTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         name instance."
    INDEX       { ss2NameIndex }
    ::= { ss2NameTable 1 }

Ss2NameEntry ::= SEQUENCE {
    ss2NameIndex        INTEGER,
    ss2NameInstance     InstanceName
}

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

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

ss2AccessMethodsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2AccessMethodsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2AccessMethodsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         AccessMethods instance."
    INDEX       { ss2NameIndex }
    ::= { ss2AccessMethodsTable 1 }

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

ss2amAUCleanupBatchesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Count of lob pages on which readahead was
         issued."
    ::= { ss2AccessMethodsEntry 5 }

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

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

ss2amDeferredDroppedRowsets OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of extents deallocated per second in
         all databases in this SQL Server instance."
    ::= { ss2AccessMethodsEntry 12 }

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

ss2amFailedAUCleanupBatchesSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of records fetched through forwarded
         record pointers."
    ::= { ss2AccessMethodsEntry 17 }

ss2amFreeSpacePageFetchesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of unrestricted full scans. These can
         either be base table or full index scans."
    ::= { ss2AccessMethodsEntry 20 }

ss2amIndexSearchesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Count of temporary LOBs created."
    ::= { ss2AccessMethodsEntry 22 }

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

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

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

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

ss2amMixedPageAllocationsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of page splits per second that occur as
         a result of overflowing index pages."
    ::= { ss2AccessMethodsEntry 29 }

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

ss2amPagesAllocatedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times a database page was
         compressed"
    ::= { ss2AccessMethodsEntry 32 }

ss2amProbeScansPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of qualified range scans through
         indexes per second."
    ::= { ss2AccessMethodsEntry 34 }

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

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

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

ss2amUsedLeafPageCookie OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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 Ss2BackupDeviceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2BackupDeviceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Backup Device' object."
    INDEX       { ss2NameIndex, ss2BackupDeviceInstance }
    ::= { ss2BackupDeviceTable 1 }

Ss2BackupDeviceEntry ::= SEQUENCE {
    ss2BackupDeviceInstance             InstanceName,
    ss2BackupDeviceDeviceputBytesSec    Gauge
}

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

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

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

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

Ss2BrokerActivationEntry ::= SEQUENCE {
    ss2baInstance                       InstanceName,
    ss2baStoredProceduresInvokedSec     Gauge,
    ss2baTaskLimitReached               Gauge,
    ss2baTaskLimitReachedPerSec         Gauge,
    ss2baTasksAbortedPerSec             Gauge,
    ss2baTasksRunning                   Gauge,
    ss2baTasksStartedPerSec             Gauge
}

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

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

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

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

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

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

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

ss2BrokerStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2BrokerStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2BrokerStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         BrokerStatistics instance."
    INDEX       { ss2NameIndex }
    ::= { ss2BrokerStatisticsTable 1 }

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

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

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

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

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

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

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

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

ss2bsEnqueuedLocalMessagesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of messages that have been placed
         into the broker transmission queue	second."
    ::= { ss2BrokerStatisticsEntry 21 }

ss2bsEnqueuedTransportMsgFragTot OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of forwarded messages
         successfully sent."
    ::= { ss2BrokerStatisticsEntry 26 }

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

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

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

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

ss2bsForwardedMsgsDiscardedSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of forwarded message bytes that
         have not been successfully sent yet."
    ::= { ss2BrokerStatisticsEntry 32 }

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

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

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

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

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

ss2BrokerTOStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2BrokerTOStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2BrokerTOStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         BrokerTOStatistics instance."
    INDEX       { ss2NameIndex }
    ::= { ss2BrokerTOStatisticsTable 1 }

Ss2BrokerTOStatisticsEntry ::= SEQUENCE {
    ss2btosAvgLengthOfBatchedWrites     Gauge,
    ss2btosAvgTimeBetweenBatchesMs      Gauge,
    ss2btosAvgTimeToWriteBatchMs        Gauge,
    ss2btosTransmissionObjGetsPerSec    Gauge,
    ss2btosTransmissionObjSetDirtSec    Gauge,
    ss2btosTransmissionObjWritesSec     Gauge
}

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

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

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

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

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

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

ss2BrokerPerDBMTransportTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2BrokerPerDBMTransportEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2BrokerPerDBMTransportEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         BrokerPerDBMTransport instance."
    INDEX       { ss2NameIndex }
    ::= { ss2BrokerPerDBMTransportTable 1 }

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

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

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

ss2bdtCurrentMsgFragForSendIO OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of priority 1 message fragments
         sent  second in transport send I/O oations."
    ::= { ss2BrokerPerDBMTransportEntry 4 }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ss2bdtPendingBytesForRecvIPerO OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The average byte length of transport receive
         I/O operations."
    ::= { ss2BrokerPerDBMTransportEntry 23 }

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

ss2bdtReceiveIPerOsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of times when transport receive I/O
         operations had to move buffer fragments in
         memory."
    ::= { ss2BrokerPerDBMTransportEntry 26 }

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

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

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

ss2bdtSendIPerOsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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 Ss2BufferManagerEntry
    ACCESS      not-accessible
    STATUS      mandatory
    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      Ss2BufferManagerEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         BufferManager instance."
    INDEX       { ss2NameIndex }
    ::= { ss2BufferManagerTable 1 }

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

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

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

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

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

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

ss2bmBufferCacheHitRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    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      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of pages flushed by checkpoint or other
         operations that require all dirty pages to be
         flushed."
    ::= { ss2BufferManagerEntry 7 }

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

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

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

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

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

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

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

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

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

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

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

ss2bmTargetPages OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Ideal