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 number of pages in the buffer pool."
    ::= { ss2BufferManagerEntry 19 }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Ss2BufferPartitionEntry ::= SEQUENCE {
    ss2bpInstance                   InstanceName,
    ss2bpFreeListEmptyPerSec        Gauge,
    ss2bpFreeListRequestsPerSec     Gauge,
    ss2bpFreePages                  Gauge
}

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

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

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

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

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

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

Ss2CLREntry ::= SEQUENCE {
    ss2CLRCLRExecution  Gauge
}

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

ss2CatalogMetadataTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2CatalogMetadataEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Catalog Metadata' objects."
    ::= { sqlServerEngineV2 12 }

ss2CatalogMetadataEntry OBJECT-TYPE
    SYNTAX      Ss2CatalogMetadataEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Catalog Metadata' object."
    INDEX       { ss2NameIndex, ss2cmdInstance }
    ::= { ss2CatalogMetadataTable 1 }

Ss2CatalogMetadataEntry ::= SEQUENCE {
    ss2cmdInstance                  InstanceName,
    ss2cmdCacheEntriesCount         Gauge,
    ss2cmdCacheEntriesPinnedCount   Gauge,
    ss2cmdCacheHitRatio             Gauge
}

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

ss2cmdCacheEntriesCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of entries in the catalog metadata
         cache"
    ::= { ss2CatalogMetadataEntry 2 }

ss2cmdCacheEntriesPinnedCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of catalog metadata cache entries that
         are pinned"
    ::= { ss2CatalogMetadataEntry 3 }

ss2cmdCacheHitRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Ratio between cache hits and lookups"
    ::= { ss2CatalogMetadataEntry 4 }

ss2CursorManagerTotalTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2CursorManagerTotalEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Cursor Manager Total object provides
         counters to monitor cursors."
    ::= { sqlServerEngineV2 13 }

ss2CursorManagerTotalEntry OBJECT-TYPE
    SYNTAX      Ss2CursorManagerTotalEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Cursor Manager by Type' object."
    INDEX       { ss2NameIndex }
    ::= { ss2CursorManagerTotalTable 1 }

Ss2CursorManagerTotalEntry ::= SEQUENCE {
    ss2cmtAsyncPopulationCount  Gauge,
    ss2cmtCursorConversionRate  Gauge,
    ss2cmtCursorFlushes         Gauge
}

ss2cmtAsyncPopulationCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cursors being populated
         asynchronously."
    ::= { ss2CursorManagerTotalEntry 1 }

ss2cmtCursorConversionRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cursor conversions/sec."
    ::= { ss2CursorManagerTotalEntry 2 }

ss2cmtCursorFlushes OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of times a flush for a cursor
         xstmt occured."
    ::= { ss2CursorManagerTotalEntry 3 }

ss2CursorManagerByTypeTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2CursorManagerByTypeEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Cursor Manager by Type object provides
         counters to monitor cursors, grouped by type."
    ::= { sqlServerEngineV2 14 }

ss2CursorManagerByTypeEntry OBJECT-TYPE
    SYNTAX      Ss2CursorManagerByTypeEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Cursor Manager by Type' object."
    INDEX       { ss2NameIndex, ss2cmbtInstance }
    ::= { ss2CursorManagerByTypeTable 1 }

Ss2CursorManagerByTypeEntry ::= SEQUENCE {
    ss2cmbtInstance                     InstanceName,
    ss2cmbtActiveCursors                Gauge,
    ss2cmbtCacheHitRatio                Gauge,
    ss2cmbtCachedCursorCounts           Gauge,
    ss2cmbtCursorCacheUseCountsSec      Gauge,
    ss2cmbtCursorRequestsPerSec         Gauge,
    ss2cmbtCursorMemoryUsage            Gauge,
    ss2cmbtCursorWorktableUsage         Gauge,
    ss2cmbtNumberOfActiveCursorPlans    Gauge
}

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

ss2cmbtActiveCursors OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active cursors."
    ::= { ss2CursorManagerByTypeEntry 2 }

ss2cmbtCacheHitRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Ratio between cache hits and lookups"
    ::= { ss2CursorManagerByTypeEntry 3 }

ss2cmbtCachedCursorCounts OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cursors of a given type in the
         cache"
    ::= { ss2CursorManagerByTypeEntry 4 }

ss2cmbtCursorCacheUseCountsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Times each type of cached cursor has been
         used"
    ::= { ss2CursorManagerByTypeEntry 5 }

ss2cmbtCursorRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SQL cursor requests received by
         server."
    ::= { ss2CursorManagerByTypeEntry 6 }

ss2cmbtCursorMemoryUsage OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Amount of memory consumed by cursors (KB)."
    ::= { ss2CursorManagerByTypeEntry 7 }

ss2cmbtCursorWorktableUsage OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of worktables used by cursors."
    ::= { ss2CursorManagerByTypeEntry 8 }

ss2cmbtNumberOfActiveCursorPlans OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cursor plans."
    ::= { ss2CursorManagerByTypeEntry 9 }

ss2DatabaseMirroringTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2DatabaseMirroringEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Database Mirroring performance object
         contains performance counters that report
         information about SQL Server database
         mirroring."
    ::= { sqlServerEngineV2 15 }

ss2DatabaseMirroringEntry OBJECT-TYPE
    SYNTAX      Ss2DatabaseMirroringEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Database Mirroring' object."
    INDEX       { ss2NameIndex, ss2dmInstance }
    ::= { ss2DatabaseMirroringTable 1 }

Ss2DatabaseMirroringEntry ::= SEQUENCE {
    ss2dmInstance                       InstanceName,
    ss2dmBytesReceivedPerSec            Gauge,
    ss2dmBytesSentPerSec                Gauge,
    ss2dmLogBytesReceivedPerSec         Gauge,
    ss2dmLogBytesRedoneFromCacheSec     Gauge,
    ss2dmLogBytesSentFromCachePerSec    Gauge,
    ss2dmLogBytesSentPerSec             Gauge,
    ss2dmLogCompressedBytesRcvdSec      Gauge,
    ss2dmLogCompressedBytesSentSec      Gauge,
    ss2dmLogHardenTimeMs                Gauge,
    ss2dmLogRemainingForUndoKB          Gauge,
    ss2dmLogScannedForUndoKB            Gauge,
    ss2dmLogSendFlowControlTimeMs       Gauge,
    ss2dmLogSendQueueKB                 Gauge,
    ss2dmMirroredWritTransactionsSec    Gauge,
    ss2dmPagesSentPerSec                Gauge,
    ss2dmReceivesPerSec                 Gauge,
    ss2dmRedoBytesPerSec                Gauge,
    ss2dmRedoQueueKB                    Gauge,
    ss2dmSendPerReceiveAckTime          Gauge,
    ss2dmSendsPerSec                    Gauge,
    ss2dmTransactionDelay               Gauge
}

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

ss2dmBytesReceivedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of bytes received per second"
    ::= { ss2DatabaseMirroringEntry 2 }

ss2dmBytesSentPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of bytes sent per second"
    ::= { ss2DatabaseMirroringEntry 3 }

ss2dmLogBytesReceivedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of bytes of log received per second"
    ::= { ss2DatabaseMirroringEntry 4 }

ss2dmLogBytesRedoneFromCacheSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of log bytes which were redone from the
         Database Mirroring log cache  second."
    ::= { ss2DatabaseMirroringEntry 5 }

ss2dmLogBytesSentFromCachePerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of sent log bytes which were sent from
         the Database Mirroring log cache in the last
         second."
    ::= { ss2DatabaseMirroringEntry 6 }

ss2dmLogBytesSentPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of bytes of log sent per second"
    ::= { ss2DatabaseMirroringEntry 7 }

ss2dmLogCompressedBytesRcvdSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of compressed bytes of log received in
         the last second."
    ::= { ss2DatabaseMirroringEntry 8 }

ss2dmLogCompressedBytesSentSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of compressed bytes of log sent in the
         last second."
    ::= { ss2DatabaseMirroringEntry 9 }

ss2dmLogHardenTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Milliseconds log blocks waited to be hardened
         to disk in the last second."
    ::= { ss2DatabaseMirroringEntry 10 }

ss2dmLogRemainingForUndoKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of kilobytes of log that remain
         to be scanned by the new mirror server after
         failover."
    ::= { ss2DatabaseMirroringEntry 11 }

ss2dmLogScannedForUndoKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of kilobytes of log that have
         been scanned by the new mirror server after
         failover."
    ::= { ss2DatabaseMirroringEntry 12 }

ss2dmLogSendFlowControlTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Milliseconds log stream messages waited for
         send flow control in the last second."
    ::= { ss2DatabaseMirroringEntry 13 }

ss2dmLogSendQueueKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of kilobytes of log that have not
         been sent to the mirror server"
    ::= { ss2DatabaseMirroringEntry 14 }

ss2dmMirroredWritTransactionsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of transactions which wrote to the
         mirrored database in the last second, that
         waited for log to be sent to the mirror."
    ::= { ss2DatabaseMirroringEntry 15 }

ss2dmPagesSentPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of pages sent per second"
    ::= { ss2DatabaseMirroringEntry 16 }

ss2dmReceivesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of mirroring message receives per
         second"
    ::= { ss2DatabaseMirroringEntry 17 }

ss2dmRedoBytesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of bytes of log redone by the mirror
         database per second"
    ::= { ss2DatabaseMirroringEntry 18 }

ss2dmRedoQueueKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of kilobytes that redo on the
         mirror database is behind the hardened log"
    ::= { ss2DatabaseMirroringEntry 19 }

ss2dmSendPerReceiveAckTime OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Milliseconds messages waited for
         acknowledgement from the partner per second."
    ::= { ss2DatabaseMirroringEntry 20 }

ss2dmSendsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of sends initiated per second"
    ::= { ss2DatabaseMirroringEntry 21 }

ss2dmTransactionDelay OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of milliseconds transaction termination
         waited for acknowledgement per second."
    ::= { ss2DatabaseMirroringEntry 22 }

ss2DatabasesTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2DatabasesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Databases object in SQL Server provides
         counters to monitor bulk copy operations,
         backup and restore throughput, and transaction
         log activities. Monitor transactions and the
         transaction log to determine how much user
         activity is occurring in the database and how
         full the transaction log is becoming. The
         amount of user activity can determine the
         performance of the database and affect log
         size, locking, and replication. Monitoring
         low-level log activity to gauge user activity
         and resource usage can help you to identify
         performance bottlenecks.
         
         Multiple instances of the Databases object,
         each representing a single database, can be
         monitored at the same time."
    ::= { sqlServerEngineV2 16 }

ss2DatabasesEntry OBJECT-TYPE
    SYNTAX      Ss2DatabasesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Databases' object."
    INDEX       { ss2NameIndex, ss2dbInstance }
    ::= { ss2DatabasesTable 1 }

Ss2DatabasesEntry ::= SEQUENCE {
    ss2dbInstance                       InstanceName,
    ss2dbActiveTransactions             Gauge,
    ss2dbBackupRestoreThroughputSec     Gauge,
    ss2dbBulkCopyRowsPerSec             Gauge,
    ss2dbBulkCopyThroughputPerSec       Gauge,
    ss2dbCommitTableEntries             Gauge,
    ss2dbDBCCLogicalScanBytesPerSec     Gauge,
    ss2dbDataFileSSizeKB                Gauge,
    ss2dbLogBytesFlushedPerSec          Gauge,
    ss2dbLogCacheHitRatio               Gauge,
    ss2dbLogCacheReadsPerSec            Gauge,
    ss2dbLogFileSSizeKB                 Gauge,
    ss2dbLogFileSUsedSizeKB             Gauge,
    ss2dbLogFlushWaitTime               Gauge,
    ss2dbLogFlushWaitsPerSec            Gauge,
    ss2dbLogFlushesPerSec               Gauge,
    ss2dbLogGrowths                     Gauge,
    ss2dbLogShrinks                     Gauge,
    ss2dbLogTruncations                 Gauge,
    ss2dbPercentLogUsed                 Gauge,
    ss2dbReplPendingXacts               Gauge,
    ss2dbReplTransRate                  Gauge,
    ss2dbShrinkDataMovementBytesSec     Gauge,
    ss2dbTrackedTransactionsPerSec      Gauge,
    ss2dbTransactionsPerSec             Gauge,
    ss2dbWriteTransactionsPerSec        Gauge
}

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

ss2dbActiveTransactions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active update transactions for the
         database."
    ::= { ss2DatabasesEntry 2 }

ss2dbBackupRestoreThroughputSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Read/write throughput for backup/restore of a
         database."
    ::= { ss2DatabasesEntry 3 }

ss2dbBulkCopyRowsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of rows bulk copied."
    ::= { ss2DatabasesEntry 4 }

ss2dbBulkCopyThroughputPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "KiloBytes bulk copied."
    ::= { ss2DatabasesEntry 5 }

ss2dbCommitTableEntries OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The size of the in-memory part of the commit
         table for the database."
    ::= { ss2DatabasesEntry 6 }

ss2dbDBCCLogicalScanBytesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Logical read scan rate for DBCC commands"
    ::= { ss2DatabasesEntry 7 }

ss2dbDataFileSSizeKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The cumulative size of all the data files in
         the database."
    ::= { ss2DatabasesEntry 8 }

ss2dbLogBytesFlushedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of log bytes flushed."
    ::= { ss2DatabasesEntry 9 }

ss2dbLogCacheHitRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Percentage of log cache reads that were
         satisfied from the log cache."
    ::= { ss2DatabasesEntry 10 }

ss2dbLogCacheReadsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Reads performed through the log manager
         cache."
    ::= { ss2DatabasesEntry 11 }

ss2dbLogFileSSizeKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The cumulative size of all the log files in
         the database."
    ::= { ss2DatabasesEntry 12 }

ss2dbLogFileSUsedSizeKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The cumulative used size of all the log files
         in the database."
    ::= { ss2DatabasesEntry 13 }

ss2dbLogFlushWaitTime OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total wait time (milliseconds)."
    ::= { ss2DatabasesEntry 14 }

ss2dbLogFlushWaitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of commits waiting on log flush."
    ::= { ss2DatabasesEntry 15 }

ss2dbLogFlushesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of log flushes."
    ::= { ss2DatabasesEntry 16 }

ss2dbLogGrowths OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of log growths for this
         database."
    ::= { ss2DatabasesEntry 17 }

ss2dbLogShrinks OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of log shrinks for this
         database."
    ::= { ss2DatabasesEntry 18 }

ss2dbLogTruncations OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of log truncations for this
         database."
    ::= { ss2DatabasesEntry 19 }

ss2dbPercentLogUsed OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The percent of space in the log that is in
         use."
    ::= { ss2DatabasesEntry 20 }

ss2dbReplPendingXacts OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of pending replication transactions in
         the database."
    ::= { ss2DatabasesEntry 21 }

ss2dbReplTransRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Replication transaction rate (replicated
         transactions/sec.)."
    ::= { ss2DatabasesEntry 22 }

ss2dbShrinkDataMovementBytesSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The rate data is being moved by Autoshrink,
         DBCC SHRINKDATABASE or SHRINKFILE."
    ::= { ss2DatabasesEntry 23 }

ss2dbTrackedTransactionsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of committed transactions recorded in
         the commit table for the database."
    ::= { ss2DatabasesEntry 24 }

ss2dbTransactionsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of transactions started for the
         database."
    ::= { ss2DatabasesEntry 25 }

ss2dbWriteTransactionsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of transactions which wrote to the
         database in the last second."
    ::= { ss2DatabasesEntry 26 }

ss2DeprecatedFeaturesTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2DeprecatedFeaturesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Deprecated Features object in SQL Server
         provides a counter to monitor the features
         designated as deprecated. In each case the
         counter provides a usage count that lists the
         number of times the deprecated feature was
         encountered since SQL Server last started."
    ::= { sqlServerEngineV2 17 }

ss2DeprecatedFeaturesEntry OBJECT-TYPE
    SYNTAX      Ss2DeprecatedFeaturesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Deprecated Features' object."
    INDEX       { ss2NameIndex, ss2DeprecatedFeaturesInstance }
    ::= { ss2DeprecatedFeaturesTable 1 }

Ss2DeprecatedFeaturesEntry ::= SEQUENCE {
    ss2DeprecatedFeaturesInstance   InstanceName,
    ss2DeprecatedFeaturesUsage      Gauge
}

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

ss2DeprecatedFeaturesUsage OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Feature usage since last SQL Server startup"
    ::= { ss2DeprecatedFeaturesEntry 2 }

ss2ExecStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ExecStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The ExecStatistics object in Microsoft SQL
         Server provides counters to monitor various
         executions."
    ::= { sqlServerEngineV2 18 }

ss2ExecStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2ExecStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Exec Statistics' object."
    INDEX       { ss2NameIndex, ss2ExecStatisticsInstance }
    ::= { ss2ExecStatisticsTable 1 }

Ss2ExecStatisticsEntry ::= SEQUENCE {
    ss2ExecStatisticsInstance           InstanceName,
    ss2ExecStatisticsDTCCalls           Gauge,
    ss2ExecStatisticDistributedQuery    Gauge,
    ss2ExecStatistExtendedProcedures    Gauge,
    ss2ExecStatisticsOLEDBCalls         Gauge
}

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

ss2ExecStatisticsDTCCalls OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to execution of DTC
         calls."
    ::= { ss2ExecStatisticsEntry 2 }

ss2ExecStatisticDistributedQuery OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to execution of
         distributed queries."
    ::= { ss2ExecStatisticsEntry 3 }

ss2ExecStatistExtendedProcedures OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to execution of XP calls."
    ::= { ss2ExecStatisticsEntry 4 }

ss2ExecStatisticsOLEDBCalls OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to execution of OLEDB
         calls."
    ::= { ss2ExecStatisticsEntry 5 }

ss2GeneralStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2GeneralStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The General Statistics object in Microsoft SQL
         Server provides counters to monitor general
         server-wide activity, such as the number of
         current connections and the number of users
         connecting and disconnecting per second from
         computers running an instance of SQL Server.
         This can be useful when you are working on
         large online transaction processing (OLTP) type
         systems where there are many clients connecting
         and disconnecting from an instance of SQL
         Server."
    ::= { sqlServerEngineV2 19 }

ss2GeneralStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2GeneralStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         GeneralStatistics instance."
    INDEX       { ss2NameIndex }
    ::= { ss2GeneralStatisticsTable 1 }

Ss2GeneralStatisticsEntry ::= SEQUENCE {
    ss2gsActiveTempTables               Gauge,
    ss2gsConnectionResetPerSec          Gauge,
    ss2gsEventNotificationsDelayDrop    Gauge,
    ss2gsHTTPAuthenticatedRequests      Gauge,
    ss2gsLogicalConnections             Gauge,
    ss2gsLoginsPerSec                   Gauge,
    ss2gsLogoutsPerSec                  Gauge,
    ss2gsMarsDeadlocks                  Gauge,
    ss2gsNonAtomicYieldRate             Gauge,
    ss2gsProcessesBlocked               Gauge,
    ss2gsSOAPEmptyRequests              Gauge,
    ss2gsSOAPMethodInvocations          Gauge,
    ss2gsSOAPSQLRequests                Gauge,
    ss2gsSOAPSessionInitiateRequests    Gauge,
    ss2gsSOAPSessionTerminateRequest    Gauge,
    ss2gsSOAPWSDLRequests               Gauge,
    ss2gsSQLTraceIOProviderLockWaits    Gauge,
    ss2gsTempTablesCreationRate         Gauge,
    ss2gsTempTablesForDestruction       Gauge,
    ss2gsTempdbRecoveryUnitId           Gauge,
    ss2gsTempdbRowsetId                 Gauge,
    ss2gsTraceEventNotificationQueue    Gauge,
    ss2gsTransactions                   Gauge,
    ss2gsUserConnections                Gauge
}

ss2gsActiveTempTables OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of temporary tables/table variables in
         use"
    ::= { ss2GeneralStatisticsEntry 1 }

ss2gsConnectionResetPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of connection resets per second."
    ::= { ss2GeneralStatisticsEntry 2 }

ss2gsEventNotificationsDelayDrop OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of event notifications waiting to be
         dropped by a system thread"
    ::= { ss2GeneralStatisticsEntry 3 }

ss2gsHTTPAuthenticatedRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of authenticated HTTP requests started
         per second."
    ::= { ss2GeneralStatisticsEntry 4 }

ss2gsLogicalConnections OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of logical connections to the system."
    ::= { ss2GeneralStatisticsEntry 5 }

ss2gsLoginsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of logins started per second."
    ::= { ss2GeneralStatisticsEntry 6 }

ss2gsLogoutsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of logouts started per second."
    ::= { ss2GeneralStatisticsEntry 7 }

ss2gsMarsDeadlocks OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of Mars Deadlocks detected."
    ::= { ss2GeneralStatisticsEntry 8 }

ss2gsNonAtomicYieldRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of non-atomic yields per second."
    ::= { ss2GeneralStatisticsEntry 9 }

ss2gsProcessesBlocked OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of currently blocked processes."
    ::= { ss2GeneralStatisticsEntry 10 }

ss2gsSOAPEmptyRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of empty SOAP requests started per
         second."
    ::= { ss2GeneralStatisticsEntry 11 }

ss2gsSOAPMethodInvocations OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SOAP method invocations started per
         second."
    ::= { ss2GeneralStatisticsEntry 12 }

ss2gsSOAPSQLRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SOAP SQL requests started per
         second."
    ::= { ss2GeneralStatisticsEntry 13 }

ss2gsSOAPSessionInitiateRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SOAP Session initiate requests
         started per second."
    ::= { ss2GeneralStatisticsEntry 14 }

ss2gsSOAPSessionTerminateRequest OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SOAP Session terminate requests
         started  second."
    ::= { ss2GeneralStatisticsEntry 15 }

ss2gsSOAPWSDLRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SOAP Web Service Description
         Language requests started per second."
    ::= { ss2GeneralStatisticsEntry 16 }

ss2gsSQLTraceIOProviderLockWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of waits for the File IO Provider lock
         per second"
    ::= { ss2GeneralStatisticsEntry 17 }

ss2gsTempTablesCreationRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of temporary tables/table variables
         created/sec"
    ::= { ss2GeneralStatisticsEntry 18 }

ss2gsTempTablesForDestruction OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of temporary tables/table variables
         waiting to be destroyed by the cleanup system
         thread"
    ::= { ss2GeneralStatisticsEntry 19 }

ss2gsTempdbRecoveryUnitId OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of duplicate tempdb recovery unit id
         generated"
    ::= { ss2GeneralStatisticsEntry 20 }

ss2gsTempdbRowsetId OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of duplicate tempdb rowset id
         generated"
    ::= { ss2GeneralStatisticsEntry 21 }

ss2gsTraceEventNotificationQueue OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of trace event notification instances
         waiting in the internal queue to be sent thru
         Service Broker"
    ::= { ss2GeneralStatisticsEntry 22 }

ss2gsTransactions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of transaction enlistments (local, dtc,
         and bound)."
    ::= { ss2GeneralStatisticsEntry 23 }

ss2gsUserConnections OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of users connected to the system."
    ::= { ss2GeneralStatisticsEntry 24 }

ss2LatchesTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2LatchesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Latches object in Microsoft SQL Server
         provides counters to monitor internal SQL
         Server resource locks called latches.
         Monitoring the latches to determine user
         activity and resource usage can help you to
         identify performance bottlenecks."
    ::= { sqlServerEngineV2 20 }

ss2LatchesEntry OBJECT-TYPE
    SYNTAX      Ss2LatchesEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         Latches instance."
    INDEX       { ss2NameIndex }
    ::= { ss2LatchesTable 1 }

Ss2LatchesEntry ::= SEQUENCE {
    ss2LatchesAverageLatchWaitTimeMs    Gauge,
    ss2LatchesLatchWaitsPerSec          Gauge,
    ss2LatchesNumberOfSuperLatches      Gauge,
    ss2LatchesSuLatchDemotionsSec       Gauge,
    ss2LatchesSuLatchPromotionsSec      Gauge,
    ss2LatchesTotalLatchWaitTimeMs      Gauge
}

ss2LatchesAverageLatchWaitTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Average latch wait time (milliseconds) for
         latch requests that had to wait."
    ::= { ss2LatchesEntry 1 }

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

ss2LatchesNumberOfSuperLatches OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of latches that are currently
         SuperLatches."
    ::= { ss2LatchesEntry 3 }

ss2LatchesSuLatchDemotionsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SuLatches that have been demoted to
         regular latches"
    ::= { ss2LatchesEntry 4 }

ss2LatchesSuLatchPromotionsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of latches that have been promoted to
         SuLatches"
    ::= { ss2LatchesEntry 5 }

ss2LatchesTotalLatchWaitTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total latch wait time (milliseconds) for latch
         requests that had to wait in the last second."
    ::= { ss2LatchesEntry 6 }

ss2LocksTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2LocksEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Locks object in Microsoft SQL Server
         provides information about SQL Server locks on
         individual resource types. Locks are held on
         SQL Server resources, such as rows read or
         modified during a transaction, to prevent
         concurrent use of resources by different
         transactions. For example, if an exclusive (X)
         lock is held on a row within a table by a
         transaction, no other transaction can modify
         that row until the lock is released. Minimizing
         locks increases concurrency, which can improve
         performance. Multiple instances of the Locks
         object can be monitored at the same time, with
         each instance representing a lock on a resource
         type."
    ::= { sqlServerEngineV2 21 }

ss2LocksEntry OBJECT-TYPE
    SYNTAX      Ss2LocksEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Locks' object."
    INDEX       { ss2NameIndex, ss2LocksInstance }
    ::= { ss2LocksTable 1 }

Ss2LocksEntry ::= SEQUENCE {
    ss2LocksInstance                    InstanceName,
    ss2LocksAverageWaitTimeMs           Gauge,
    ss2LocksLockRequestsPerSec          Gauge,
    ss2LocksTimeoutsGreaterThan0Sec     Gauge,
    ss2LocksLockTimeoutsPerSec          Gauge,
    ss2LocksLockWaitTimeMs              Gauge,
    ss2LocksLockWaitsPerSec             Gauge,
    ss2LocksNumberOfDeadlocksPerSec     Gauge
}

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

ss2LocksAverageWaitTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The average amount of wait time (milliseconds)
         for each lock request that resulted in a wait."
    ::= { ss2LocksEntry 2 }

ss2LocksLockRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of new locks and lock conversions
         requested from the lock manager."
    ::= { ss2LocksEntry 3 }

ss2LocksTimeoutsGreaterThan0Sec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of lock requests that timed out. This
         does not include requests for NOWAIT locks."
    ::= { ss2LocksEntry 4 }

ss2LocksLockTimeoutsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of lock requests that timed out. This
         includes requests for NOWAIT locks."
    ::= { ss2LocksEntry 5 }

ss2LocksLockWaitTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total wait time (milliseconds) for locks in
         the last second."
    ::= { ss2LocksEntry 6 }

ss2LocksLockWaitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of lock requests that could not be
         satisfied immediately and required the caller
         to wait before being granted the lock."
    ::= { ss2LocksEntry 7 }

ss2LocksNumberOfDeadlocksPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of lock requests that resulted in a
         deadlock."
    ::= { ss2LocksEntry 8 }

ss2MemoryManagerTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2MemoryManagerEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Memory Manager object in Microsoft SQL
         Server provides counters to monitor overall
         server memory usage. Monitoring overall server
         memory usage to gauge user activity and
         resource usage can help you to identify
         performance bottlenecks. Monitoring the memory
         used by an instance of SQL Server can help
         determine:
         
         	* If bottlenecks exist from inadequate
         physical memory for storing frequently accessed
         data in cache. If memory is inadequate, 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."
    ::= { sqlServerEngineV2 22 }

ss2MemoryManagerEntry OBJECT-TYPE
    SYNTAX      Ss2MemoryManagerEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         MemoryManager instance."
    INDEX       { ss2NameIndex }
    ::= { ss2MemoryManagerTable 1 }

Ss2MemoryManagerEntry ::= SEQUENCE {
    ss2mmConnectionMemoryKB         Gauge,
    ss2mmGrantedWorkspaceMemoryKB   Gauge,
    ss2mmLockBlocks                 Gauge,
    ss2mmLockBlocksAllocated        Gauge,
    ss2mmLockMemoryKB               Gauge,
    ss2mmLockOwnerBlocks            Gauge,
    ss2mmLockOwnerBlocksAllocated   Gauge,
    ss2mmMaximumWorkspaceMemoryKB   Gauge,
    ss2mmMemoryGrantsOutstanding    Gauge,
    ss2mmMemoryGrantsPending        Gauge,
    ss2mmOptimizerMemoryKB          Gauge,
    ss2mmSQLCacheMemoryKB           Gauge,
    ss2mmTargetServerMemoryKB       Gauge,
    ss2mmTotalServerMemoryKB        Gauge
}

ss2mmConnectionMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         using for maintaining connections"
    ::= { ss2MemoryManagerEntry 1 }

ss2mmGrantedWorkspaceMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of memory granted to executing
         processes. This memory is used for hash, sort
         and create index operations."
    ::= { ss2MemoryManagerEntry 2 }

ss2mmLockBlocks OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The current number of lock blocks that are in
         use on the server. Refreshed periodically."
    ::= { ss2MemoryManagerEntry 3 }

ss2mmLockBlocksAllocated OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The current number of allocated lock blocks."
    ::= { ss2MemoryManagerEntry 4 }

ss2mmLockMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         using for locks"
    ::= { ss2MemoryManagerEntry 5 }

ss2mmLockOwnerBlocks OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of lock owner blocks that are
         currently in use on the server. Refreshed
         periodically."
    ::= { ss2MemoryManagerEntry 6 }

ss2mmLockOwnerBlocksAllocated OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The current number of allocated lock owner
         blocks."
    ::= { ss2MemoryManagerEntry 7 }

ss2mmMaximumWorkspaceMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of memory granted to executing
         processes. This memory is used primarily for
         hash, sort and create index operations."
    ::= { ss2MemoryManagerEntry 8 }

ss2mmMemoryGrantsOutstanding OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current number of processes that have
         successfully acquired a workspace memory grant"
    ::= { ss2MemoryManagerEntry 9 }

ss2mmMemoryGrantsPending OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current number of processes waiting for a
         workspace memory grant"
    ::= { ss2MemoryManagerEntry 10 }

ss2mmOptimizerMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         using for query optimization"
    ::= { ss2MemoryManagerEntry 11 }

ss2mmSQLCacheMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         using for the dynamic SQL cache"
    ::= { ss2MemoryManagerEntry 12 }

ss2mmTargetServerMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         willing to consume"
    ::= { ss2MemoryManagerEntry 13 }

ss2mmTotalServerMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of dynamic memory the server is
         currently consuming"
    ::= { ss2MemoryManagerEntry 14 }

ss2PlanCacheTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2PlanCacheEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Plan Cache object provides counters to
         monitor how SQL Server uses memory to store
         objects such as stored procedures, ad hoc and
         prepared Transact-SQL statements, and triggers.
         Multiple instances of the Plan Cache object can
         be monitored at the same time, with each
         instance representing a different type of plan
         to monitor."
    ::= { sqlServerEngineV2 23 }

ss2PlanCacheEntry OBJECT-TYPE
    SYNTAX      Ss2PlanCacheEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Plan Cache' object."
    INDEX       { ss2NameIndex, ss2PlanCacheInstance }
    ::= { ss2PlanCacheTable 1 }

Ss2PlanCacheEntry ::= SEQUENCE {
    ss2PlanCacheInstance            InstanceName,
    ss2PlanCacheCacheHitRatio       Gauge,
    ss2PlanCacheCacheObjectCounts   Gauge,
    ss2PlanCacheCacheObjectsInUse   Gauge,
    ss2PlanCacheCachePages          Gauge
}

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

ss2PlanCacheCacheHitRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Ratio between cache hits and lookups"
    ::= { ss2PlanCacheEntry 2 }

ss2PlanCacheCacheObjectCounts OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cache objects in the cache"
    ::= { ss2PlanCacheEntry 3 }

ss2PlanCacheCacheObjectsInUse OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cache objects in use"
    ::= { ss2PlanCacheEntry 4 }

ss2PlanCacheCachePages OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of 8k pages used by cache objects"
    ::= { ss2PlanCacheEntry 5 }

ss2ReplicationAgentsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ReplicationAgentsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Replication Agents' objects."
    ::= { sqlServerEngineV2 24 }

ss2ReplicationAgentsEntry OBJECT-TYPE
    SYNTAX      Ss2ReplicationAgentsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Replication Agents' object."
    INDEX       { ss2NameIndex, ss2ReplicationAgentsInstance }
    ::= { ss2ReplicationAgentsTable 1 }

Ss2ReplicationAgentsEntry ::= SEQUENCE {
    ss2ReplicationAgentsInstance    InstanceName,
    ss2ReplicationAgentsRunning     Gauge
}

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

ss2ReplicationAgentsRunning OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of replication agents currently
         running."
    ::= { ss2ReplicationAgentsEntry 2 }

ss2ReplicationDistTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ReplicationDistEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Replication Dist.' objects."
    ::= { sqlServerEngineV2 25 }

ss2ReplicationDistEntry OBJECT-TYPE
    SYNTAX      Ss2ReplicationDistEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Replication Dist.' object."
    INDEX       { ss2NameIndex, ss2rdInstance }
    ::= { ss2ReplicationDistTable 1 }

Ss2ReplicationDistEntry ::= SEQUENCE {
    ss2rdInstance                   InstanceName,
    ss2rdDistDeliveredCmdsPerSec    Gauge,
    ss2rdDistDeliveredTransPerSec   Gauge,
    ss2rdDistDeliveryLatency        Gauge
}

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

ss2rdDistDeliveredCmdsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of commands per second delivered to
         the Subscriber."
    ::= { ss2ReplicationDistEntry 2 }

ss2rdDistDeliveredTransPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of transactions per second
         delivered to the Subscriber."
    ::= { ss2ReplicationDistEntry 3 }

ss2rdDistDeliveryLatency OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The current amount of time, in milliseconds,
         elapsed from when transactions are delivered to
         the Distributor to when they are applied at the
         Subscriber."
    ::= { ss2ReplicationDistEntry 4 }

ss2ReplicationLogreaderTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ReplicationLogreaderEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Replication Logreader' objects."
    ::= { sqlServerEngineV2 26 }

ss2ReplicationLogreaderEntry OBJECT-TYPE
    SYNTAX      Ss2ReplicationLogreaderEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Replication Logreader' object."
    INDEX       { ss2NameIndex, ss2rlInstance }
    ::= { ss2ReplicationLogreaderTable 1 }

Ss2ReplicationLogreaderEntry ::= SEQUENCE {
    ss2rlInstance                       InstanceName,
    ss2rlLogreaderDeliveredCmdsSec      Gauge,
    ss2rlLogreaderDeliveredTransSec     Gauge,
    ss2rlLogreaderDeliveryLatency       Gauge
}

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

ss2rlLogreaderDeliveredCmdsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of commands  second delivered to
         the Distributor."
    ::= { ss2ReplicationLogreaderEntry 2 }

ss2rlLogreaderDeliveredTransSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of transactions  second delivered
         to the Distributor."
    ::= { ss2ReplicationLogreaderEntry 3 }

ss2rlLogreaderDeliveryLatency OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The current amount of time, in milliseconds,
         elapsed from when transactions are applied at
         the Publisher to when they are delivered to the
         Distributor."
    ::= { ss2ReplicationLogreaderEntry 4 }

ss2ReplicationMergeTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ReplicationMergeEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Replication Merge' objects."
    ::= { sqlServerEngineV2 27 }

ss2ReplicationMergeEntry OBJECT-TYPE
    SYNTAX      Ss2ReplicationMergeEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Replication Merge' object."
    INDEX       { ss2NameIndex, ss2rmInstance }
    ::= { ss2ReplicationMergeTable 1 }

Ss2ReplicationMergeEntry ::= SEQUENCE {
    ss2rmInstance                   InstanceName,
    ss2rmConflictsPerSec            Gauge,
    ss2rmDownloadedChangesPerSec    Gauge,
    ss2rmUploadedChangesPerSec      Gauge
}

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

ss2rmConflictsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of conflicts per second occurring
         during the merge process."
    ::= { ss2ReplicationMergeEntry 2 }

ss2rmDownloadedChangesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of rows per second merged from the
         Publisher to the Subscriber."
    ::= { ss2ReplicationMergeEntry 3 }

ss2rmUploadedChangesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of rows per second merged from the
         Subscriber to the Publisher."
    ::= { ss2ReplicationMergeEntry 4 }

ss2ReplicationSnapshotTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ReplicationSnapshotEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Replication Snapshot' objects."
    ::= { sqlServerEngineV2 28 }

ss2ReplicationSnapshotEntry OBJECT-TYPE
    SYNTAX      Ss2ReplicationSnapshotEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Replication Snapshot' object."
    INDEX       { ss2NameIndex, ss2rsInstance }
    ::= { ss2ReplicationSnapshotTable 1 }

Ss2ReplicationSnapshotEntry ::= SEQUENCE {
    ss2rsInstance                       InstanceName,
    ss2rsSnapshotDeliveredCmdsPerSec    Gauge,
    ss2rsSnapshotDeliveredTransSec      Gauge
}

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

ss2rsSnapshotDeliveredCmdsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of commands per second delivered to
         the Distributor."
    ::= { ss2ReplicationSnapshotEntry 2 }

ss2rsSnapshotDeliveredTransSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of transactions  second delivered
         to the Distributor."
    ::= { ss2ReplicationSnapshotEntry 3 }

ss2ResourcePoolStatsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2ResourcePoolStatsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Resource Pool Stats' objects."
    ::= { sqlServerEngineV2 29 }

ss2ResourcePoolStatsEntry OBJECT-TYPE
    SYNTAX      Ss2ResourcePoolStatsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Resource Pool Stats' object."
    INDEX       { ss2NameIndex, ss2rpsInstance }
    ::= { ss2ResourcePoolStatsTable 1 }

Ss2ResourcePoolStatsEntry ::= SEQUENCE {
    ss2rpsInstance                      InstanceName,
    ss2rpsActiveMemoryGrantAmountKB     Gauge,
    ss2rpsActiveMemoryGrantsCount       Gauge,
    ss2rpsCPUControlEffectPercent       Gauge,
    ss2rpsCPUUsagePercent               Gauge,
    ss2rpsCPUUsageTargetPercent         Gauge,
    ss2rpsCacheMemoryTargetKB           Gauge,
    ss2rpsCompileMemoryTargetKB         Gauge,
    ss2rpsMaxMemoryKB                   Gauge,
    ss2rpsMemoryGrantTimeoutsPerSec     Gauge,
    ss2rpsMemoryGrantsPerSec            Gauge,
    ss2rpsPendingMemoryGrantsCount      Gauge,
    ss2rpsQueryExecMemoryTargetKB       Gauge,
    ss2rpsTargetMemoryKB                Gauge,
    ss2rpsUsedMemoryKB                  Gauge
}

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

ss2rpsActiveMemoryGrantAmountKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total amount of granted memory in kilobytes in
         the resource pool."
    ::= { ss2ResourcePoolStatsEntry 2 }

ss2rpsActiveMemoryGrantsCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of query memory grants in the resource
         pool."
    ::= { ss2ResourcePoolStatsEntry 3 }

ss2rpsCPUControlEffectPercent OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Effect of the resource governor on the
         resource pool calculated as (CPU usage %) /
         (CPU usage % without RG)."
    ::= { ss2ResourcePoolStatsEntry 4 }

ss2rpsCPUUsagePercent OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "System CPU usage by all requests in the
         specified instance of the performance object."
    ::= { ss2ResourcePoolStatsEntry 5 }

ss2rpsCPUUsageTargetPercent OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Target value of 'CPU usage %' for the resource
         pool based on the configuration settings and
         the system load."
    ::= { ss2ResourcePoolStatsEntry 6 }

ss2rpsCacheMemoryTargetKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current memory target for cache memory in
         kilobytes."
    ::= { ss2ResourcePoolStatsEntry 7 }

ss2rpsCompileMemoryTargetKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current memory target for query compile in
         kilobytes."
    ::= { ss2ResourcePoolStatsEntry 8 }

ss2rpsMaxMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Maximum amount of memory in kilobytes the
         resource pool can have based on the settings
         and server state."
    ::= { ss2ResourcePoolStatsEntry 9 }

ss2rpsMemoryGrantTimeoutsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of query memory grant timeouts per
         second occurring in the resource pool."
    ::= { ss2ResourcePoolStatsEntry 10 }

ss2rpsMemoryGrantsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of query memory grants per second
         occurring in the resource pool."
    ::= { ss2ResourcePoolStatsEntry 11 }

ss2rpsPendingMemoryGrantsCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of queries waiting for memory grants in
         the resource pool."
    ::= { ss2ResourcePoolStatsEntry 12 }

ss2rpsQueryExecMemoryTargetKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Current memory target for query execution
         memory grant in kilobytes."
    ::= { ss2ResourcePoolStatsEntry 13 }

ss2rpsTargetMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Target amount of memory in kilobytes the
         resource pool is trying to attain based on the
         settings and server state."
    ::= { ss2ResourcePoolStatsEntry 14 }

ss2rpsUsedMemoryKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Used amount of memory in kilobytes in the
         resource pool."
    ::= { ss2ResourcePoolStatsEntry 15 }

ss2SQLErrorsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2SQLErrorsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Errors object in Microsoft SQL Server
         provides counters to monitor SQL Errors."
    ::= { sqlServerEngineV2 30 }

ss2SQLErrorsEntry OBJECT-TYPE
    SYNTAX      Ss2SQLErrorsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'SQL Errors' object."
    INDEX       { ss2NameIndex, ss2SQLErrorsInstance }
    ::= { ss2SQLErrorsTable 1 }

Ss2SQLErrorsEntry ::= SEQUENCE {
    ss2SQLErrorsInstance        InstanceName,
    ss2SQLErrorsErrorsPerSec    Gauge
}

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

ss2SQLErrorsErrorsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of errors/sec"
    ::= { ss2SQLErrorsEntry 2 }

ss2SQLStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2SQLStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Statistics object in SQL Server
         provides counters to monitor compilation and
         the type of requests sent to an instance of SQL
         Server. Monitoring the number of query
         compilations and recompilations and the number
         of batches received by an instance of SQL
         Server gives you an indication of how quickly
         SQL Server is processing user queries and how
         effectively the query optimizer is processing
         the queries.
         
         Compilation is a significant part of a query's
         turnaround time. In order to save the
         compilation cost, the Database Engine saves the
         compiled query plan in a query cache. The
         objective of the cache is to reduce compilation
         by storing compiled queries for later reuse,
         therefore ending the requirement to recompile
         queries when later executed. However, each
         unique query must be compiled at least one
         time. Query recompilations can be caused by the
         following factors:
         
         * Schema changes, including base schema changes
         such as adding columns or indexes to a table,
         or statistics schema changes such as inserting
         or deleting a significant number of rows from a
         table.
         * Environment (SET statement) changes. Changes
         in session settings such as ANSI_PADDING or
         ANSI_NULLS can cause a query to be recompiled."
    ::= { sqlServerEngineV2 31 }

ss2SQLStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2SQLStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         SQLStatistics instance."
    INDEX       { ss2NameIndex }
    ::= { ss2SQLStatisticsTable 1 }

Ss2SQLStatisticsEntry ::= SEQUENCE {
    ss2sqsAutoParamAttemptsPerSec       Gauge,
    ss2sqsBatchRequestsPerSec           Gauge,
    ss2sqsFailedAutoParamsPerSec        Gauge,
    ss2sqsForcedParameterizationsSec    Gauge,
    ss2sqsGuidedPlanExecutionsPerSec    Gauge,
    ss2sqsMisguidedPlanExecutionsSec    Gauge,
    ss2sqsSQLAttentionRate              Gauge,
    ss2sqsSQLCompilationsPerSec         Gauge,
    ss2sqsSQLReCompilationsPerSec       Gauge,
    ss2sqsSafeAutoParamsPerSec          Gauge,
    ss2sqsUnsafeAutoParamsPerSec        Gauge
}

ss2sqsAutoParamAttemptsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of auto-parameterization attempts."
    ::= { ss2SQLStatisticsEntry 1 }

ss2sqsBatchRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SQL batch requests received by
         server."
    ::= { ss2SQLStatisticsEntry 2 }

ss2sqsFailedAutoParamsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of failed auto-parameterizations."
    ::= { ss2SQLStatisticsEntry 3 }

ss2sqsForcedParameterizationsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of statements parameterized by forced
         parameterization  second."
    ::= { ss2SQLStatisticsEntry 4 }

ss2sqsGuidedPlanExecutionsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of plan executions per second in which
         the query plan has been generated by using a
         plan guide."
    ::= { ss2SQLStatisticsEntry 5 }

ss2sqsMisguidedPlanExecutionsSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of plan executions	second in which a
         plan guide could not be honored during plan
         generation. The plan guide was disregarded and
         normal compilation was used to generate the
         executed plan."
    ::= { ss2SQLStatisticsEntry 6 }

ss2sqsSQLAttentionRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of attentions per second."
    ::= { ss2SQLStatisticsEntry 7 }

ss2sqsSQLCompilationsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SQL compilations."
    ::= { ss2SQLStatisticsEntry 8 }

ss2sqsSQLReCompilationsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of SQL re-compiles."
    ::= { ss2SQLStatisticsEntry 9 }

ss2sqsSafeAutoParamsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of safe auto-parameterizations."
    ::= { ss2SQLStatisticsEntry 10 }

ss2sqsUnsafeAutoParamsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of unsafe auto-parameterizations."
    ::= { ss2SQLStatisticsEntry 11 }

ss2SSISPipelineTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2SSISPipelineEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'SSIS Pipeline' objects."
    ::= { sqlServerEngineV2 32 }

ss2SSISPipelineEntry OBJECT-TYPE
    SYNTAX      Ss2SSISPipelineEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'SSIS Pipeline' object."
    INDEX       { ss2NameIndex }
    ::= { ss2SSISPipelineTable 1 }

Ss2SSISPipelineEntry ::= SEQUENCE {
    ss2SSISPipelineBLOBBytesRead        Gauge,
    ss2SSISPipelineBLOBBytesWritten     Gauge,
    ss2SSISPipelineBLOBFilesInUse       Gauge,
    ss2SSISPipelineBufferMemory         Gauge,
    ss2SSISPipelineBuffersInUse         Gauge,
    ss2SSISPipelineBuffersSpooled       Gauge,
    ss2SSISPipelineFlatBufferMemory     Gauge,
    ss2SSISPipelineFlatBuffersInUse     Gauge,
    ss2SSISPipelinePrivateBuffMemory    Gauge,
    ss2SSISPipelinePrivateBuffersUse    Gauge,
    ss2SSISPipelineRowsRead             Gauge,
    ss2SSISPipelineRowsWritten          Gauge
}

ss2SSISPipelineBLOBBytesRead OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of BLOB bytes read from all data
         sources in total."
    ::= { ss2SSISPipelineEntry 1 }

ss2SSISPipelineBLOBBytesWritten OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of BLOB bytes written to all data
         sources in total."
    ::= { ss2SSISPipelineEntry 2 }

ss2SSISPipelineBLOBFilesInUse OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of BLOB spooling files in use
         throughout the pipeline."
    ::= { ss2SSISPipelineEntry 3 }

ss2SSISPipelineBufferMemory OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The amount of memory allocated to buffers in
         the pipeline."
    ::= { ss2SSISPipelineEntry 4 }

ss2SSISPipelineBuffersInUse OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of pipeline buffers in use
         throughout the pipeline."
    ::= { ss2SSISPipelineEntry 5 }

ss2SSISPipelineBuffersSpooled OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of buffers spooled to disk."
    ::= { ss2SSISPipelineEntry 6 }

ss2SSISPipelineFlatBufferMemory OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The amount of memory allocated to flat memory
         buffers."
    ::= { ss2SSISPipelineEntry 7 }

ss2SSISPipelineFlatBuffersInUse OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of flat memory buffers in use
         throughout the pipeline."
    ::= { ss2SSISPipelineEntry 8 }

ss2SSISPipelinePrivateBuffMemory OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The amount of memory allocated to private
         transformation buffers."
    ::= { ss2SSISPipelineEntry 9 }

ss2SSISPipelinePrivateBuffersUse OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of private transformation buffers
         in use throughout the pipeline."
    ::= { ss2SSISPipelineEntry 10 }

ss2SSISPipelineRowsRead OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of rows read from all data sources
         in total."
    ::= { ss2SSISPipelineEntry 11 }

ss2SSISPipelineRowsWritten OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of rows written to all data
         destinations in total."
    ::= { ss2SSISPipelineEntry 12 }

ss2SSISServiceTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2SSISServiceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'SSIS Service' objects."
    ::= { sqlServerEngineV2 33 }

ss2SSISServiceEntry OBJECT-TYPE
    SYNTAX      Ss2SSISServiceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'SSIS Service' object."
    INDEX       { ss2NameIndex }
    ::= { ss2SSISServiceTable 1 }

Ss2SSISServiceEntry ::= SEQUENCE {
    ss2SSISServiceSSISPackageInstanc    Gauge
}

ss2SSISServiceSSISPackageInstanc OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of package instances currently
         running."
    ::= { ss2SSISServiceEntry 1 }

ss2TraceEventStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2TraceEventStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Trace Event Statistics' objects."
    ::= { sqlServerEngineV2 34 }

ss2TraceEventStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2TraceEventStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Trace Event Statistics' object."
    INDEX       { ss2NameIndex, ss2tesInstance }
    ::= { ss2TraceEventStatisticsTable 1 }

Ss2TraceEventStatisticsEntry ::= SEQUENCE {
    ss2tesInstance                  InstanceName,
    ss2tesBytesPerSec               Gauge,
    ss2tesCPUTicksPerSec            Gauge,
    ss2tesEventsFilteredPerSec      Gauge,
    ss2tesEventsFiredPerSec         Gauge,
    ss2tesEventsPrefilteredPerSec   Gauge
}

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

ss2tesBytesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Bytes transferred by this trace per second"
    ::= { ss2TraceEventStatisticsEntry 2 }

ss2tesCPUTicksPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "CPU usage per second (Requires -T1904)"
    ::= { ss2TraceEventStatisticsEntry 3 }

ss2tesEventsFilteredPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Events filtered per second"
    ::= { ss2TraceEventStatisticsEntry 4 }

ss2tesEventsFiredPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Events fired by this trace per second"
    ::= { ss2TraceEventStatisticsEntry 5 }

ss2tesEventsPrefilteredPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Prefiltered events per second"
    ::= { ss2TraceEventStatisticsEntry 6 }

ss2TraceStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2TraceStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Trace Statistics' objects."
    ::= { sqlServerEngineV2 35 }

ss2TraceStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2TraceStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Trace Statistics' object."
    INDEX       { ss2NameIndex, ss2tstInstance }
    ::= { ss2TraceStatisticsTable 1 }

Ss2TraceStatisticsEntry ::= SEQUENCE {
    ss2tstInstance              InstanceName,
    ss2tstBytesPerSec           Gauge,
    ss2tstDroppedEventsPerSec   Gauge,
    ss2tstEventsFilteredPerSec  Gauge,
    ss2tstEventsFiredPerSec     Gauge
}

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

ss2tstBytesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Bytes transferred by this trace per second"
    ::= { ss2TraceStatisticsEntry 2 }

ss2tstDroppedEventsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Events dropped by this trace per second"
    ::= { ss2TraceStatisticsEntry 3 }

ss2tstEventsFilteredPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Events filtered per second"
    ::= { ss2TraceStatisticsEntry 4 }

ss2tstEventsFiredPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Events fired by this trace per second"
    ::= { ss2TraceStatisticsEntry 5 }

ss2TransactionsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2TransactionsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Transactions object in Microsoft SQL
         Server provides counters to monitor the number
         of transactions active in an instance of the
         Database Engine, and the effects of those
         transactions on resources such as the snapshot
         isolation row version store in tempdb.
         Transactions are logical units of work; a set
         of operations that must either all succeed or
         all be erased from a database in order to
         maintain the logical integrity of the data. All
         modifications of data in SQL Server databases
         are made in transactions.
         
         When a database is set to allow snapshot
         isolation level, SQL Server must maintain a
         record of the modifications made to each row in
         a database. Each time a row is modified, a copy
         of the row as it existed before the
         modification is recorded in a row version store
         in tempdb. Many of the counters in the
         Transaction object can be used to monitor the
         size and rate of growth of the row version
         store in tempdb.
         
         The Transactions object counters report all
         transactions in one instance of the Database
         Engine."
    ::= { sqlServerEngineV2 36 }

ss2TransactionsEntry OBJECT-TYPE
    SYNTAX      Ss2TransactionsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         Transactions instance."
    INDEX       { ss2NameIndex }
    ::= { ss2TransactionsTable 1 }

Ss2TransactionsEntry ::= SEQUENCE {
    ss2trnFreeSpaceInTempdbKB           Gauge,
    ss2trnLongestTransactRunningTime    Gauge,
    ss2trnNonSnapshotVersionTransact    Gauge,
    ss2trnSnapshotTransactions          Gauge,
    ss2trnTransactions                  Gauge,
    ss2trnUpdateSnapshotTransactions    Gauge,
    ss2trnUpdateConflictRatio           Gauge,
    ss2trnVersionCleanupRateKBPerS      Gauge,
    ss2trnVersionGenerationRateKBS      Gauge,
    ss2trnVersionStoreSizeKB            Gauge,
    ss2trnVersionStoreUnitCount         Gauge,
    ss2trnVersionStoreUnitCreation      Gauge,
    ss2trnVersionStoreUnitTruncation    Gauge
}

ss2trnFreeSpaceInTempdbKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The free space in tempdb in KB."
    ::= { ss2TransactionsEntry 1 }

ss2trnLongestTransactRunningTime OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The longest running time of any transcation in
         seconds."
    ::= { ss2TransactionsEntry 2 }

ss2trnNonSnapshotVersionTransact OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The total number of active non-snapshot
         transactions that generate version records."
    ::= { ss2TransactionsEntry 3 }

ss2trnSnapshotTransactions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The total number of active snapshot
         transactions."
    ::= { ss2TransactionsEntry 4 }

ss2trnTransactions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of transaction enlistments (local, dtc,
         and bound)."
    ::= { ss2TransactionsEntry 5 }

ss2trnUpdateSnapshotTransactions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The total number of active snapshot
         transactions that do updates."
    ::= { ss2TransactionsEntry 6 }

ss2trnUpdateConflictRatio OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The fraction of update snapshot transactions
         that have update conflicts to the total number
         of update snapshot transactions."
    ::= { ss2TransactionsEntry 7 }

ss2trnVersionCleanupRateKBPerS OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The version cleanup rate in KB per seconds."
    ::= { ss2TransactionsEntry 8 }

ss2trnVersionGenerationRateKBS OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The version generation rate in KB	seconds."
    ::= { ss2TransactionsEntry 9 }

ss2trnVersionStoreSizeKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The size of the version store in KB."
    ::= { ss2TransactionsEntry 10 }

ss2trnVersionStoreUnitCount OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of unit in Version Store."
    ::= { ss2TransactionsEntry 11 }

ss2trnVersionStoreUnitCreation OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Creation of new unit in Version Store."
    ::= { ss2TransactionsEntry 12 }

ss2trnVersionStoreUnitTruncation OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Truncation of unit in Version Store."
    ::= { ss2TransactionsEntry 13 }

ss2UserSettableTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2UserSettableEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The User Settable object in Microsoft SQL
         Server allows you to create custom counter
         instances. Use custom counter instances to
         monitor aspects of the server not monitored by
         existing counters, such as components unique to
         your SQL Server database (for example, the
         number of customer orders logged or the product
         inventory).
         
         The User Settable object contains 10 instances
         of the query counter: User counter 1 through
         User counter 10. These counters map to the SQL
         Server stored procedures sp_user_counter1
         through sp_user_counter10. As these stored
         procedures are executed by user applications,
         the values set by the stored procedures are
         displayed in System Monitor. A counter can
         monitor any single integer value (for example,
         a stored procedure that counts how many orders
         for a particular product have occurred in one
         day)."
    ::= { sqlServerEngineV2 37 }

ss2UserSettableEntry OBJECT-TYPE
    SYNTAX      Ss2UserSettableEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'User Settable' object."
    INDEX       { ss2NameIndex, ss2UserSettableInstance }
    ::= { ss2UserSettableTable 1 }

Ss2UserSettableEntry ::= SEQUENCE {
    ss2UserSettableInstance     InstanceName,
    ss2UserSettableQuery        Gauge
}

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

ss2UserSettableQuery OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "As defined by the user."
    ::= { ss2UserSettableEntry 2 }

ss2WaitStatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2WaitStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The Wait Statistics performance object
         contains performance counters that report
         information about wait status."
    ::= { sqlServerEngineV2 38 }

ss2WaitStatisticsEntry OBJECT-TYPE
    SYNTAX      Ss2WaitStatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Wait Statistics' object."
    INDEX       { ss2NameIndex, ss2wsInstance }
    ::= { ss2WaitStatisticsTable 1 }

Ss2WaitStatisticsEntry ::= SEQUENCE {
    ss2wsInstance                       InstanceName,
    ss2wsLockWaits                      Gauge,
    ss2wsLogBufferWaits                 Gauge,
    ss2wsLogWriteWaits                  Gauge,
    ss2wsMemoryGrantQueueWaits          Gauge,
    ss2wsNetworkIOWaits                 Gauge,
    ss2wsNonPageLatchWaits              Gauge,
    ss2wsPageIOLatchWaits               Gauge,
    ss2wsPageLatchWaits                 Gauge,
    ss2wsThreadSafeMemoryObjectsWait    Gauge,
    ss2wsTransactionOwnershipWaits      Gauge,
    ss2wsWaitForTheWorker               Gauge,
    ss2wsWorkspaceSynchronizatWaits     Gauge
}

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

ss2wsLockWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics for processes waiting on a lock."
    ::= { ss2WaitStatisticsEntry 2 }

ss2wsLogBufferWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics for processes waiting for log
         buffer to be available."
    ::= { ss2WaitStatisticsEntry 3 }

ss2wsLogWriteWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics for processes waiting for log
         buffer to be written."
    ::= { ss2WaitStatisticsEntry 4 }

ss2wsMemoryGrantQueueWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics for processes waiting for memory
         grant to become available."
    ::= { ss2WaitStatisticsEntry 5 }

ss2wsNetworkIOWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to wait on network IO."
    ::= { ss2WaitStatisticsEntry 6 }

ss2wsNonPageLatchWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to non-page latches."
    ::= { ss2WaitStatisticsEntry 7 }

ss2wsPageIOLatchWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to page IO latches."
    ::= { ss2WaitStatisticsEntry 8 }

ss2wsPageLatchWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to page latches, not
         including IO latches"
    ::= { ss2WaitStatisticsEntry 9 }

ss2wsThreadSafeMemoryObjectsWait OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics for processes waiting on
         thread-safe memory allocators."
    ::= { ss2WaitStatisticsEntry 10 }

ss2wsTransactionOwnershipWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to processes synchronizing
         access to transaction."
    ::= { ss2WaitStatisticsEntry 11 }

ss2wsWaitForTheWorker OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to processes waiting for
         worker to become available."
    ::= { ss2WaitStatisticsEntry 12 }

ss2wsWorkspaceSynchronizatWaits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Statistics relevant to processes synchronizing
         access to workspace."
    ::= { ss2WaitStatisticsEntry 13 }

ss2WorkloadGroupStatsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Ss2WorkloadGroupStatsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'Workload Group Stats' objects."
    ::= { sqlServerEngineV2 39 }

ss2WorkloadGroupStatsEntry OBJECT-TYPE
    SYNTAX      Ss2WorkloadGroupStatsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Workload Group Stats' object."
    INDEX       { ss2NameIndex, ss2wgsInstance }
    ::= { ss2WorkloadGroupStatsTable 1 }

Ss2WorkloadGroupStatsEntry ::= SEQUENCE {
    ss2wgsInstance                      InstanceName,
    ss2wgsActiveParallelThreads         Gauge,
    ss2wgsActiveRequests                Gauge,
    ss2wgsBlockedTasks                  Gauge,
    ss2wgsCPUUsagePercent               Gauge,
    ss2wgsMaxRequestCpuTimeMs           Gauge,
    ss2wgsMaxRequestMemoryGrantKB       Gauge,
    ss2wgsQueryOptimizationsPerSec      Gauge,
    ss2wgsQueuedRequests                Gauge,
    ss2wgsReducedMemoryGrantsPerSec     Gauge,
    ss2wgsRequestsCompletedPerSec       Gauge,
    ss2wgsSuboptimalPlansPerSec         Gauge
}

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

ss2wgsActiveParallelThreads OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of threads used by parallel queries in
         the workload group. Serial queries and the main
         thread of parallel queries are not included in
         this number."
    ::= { ss2WorkloadGroupStatsEntry 2 }

ss2wgsActiveRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of currently running requests in the
         workload group."
    ::= { ss2WorkloadGroupStatsEntry 3 }

ss2wgsBlockedTasks OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of blocked tasks in the workload
         group."
    ::= { ss2WorkloadGroupStatsEntry 4 }

ss2wgsCPUUsagePercent OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "System CPU usage by all requests in the
         specified instance of the performance object."
    ::= { ss2WorkloadGroupStatsEntry 5 }

ss2wgsMaxRequestCpuTimeMs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Maximum CPU time in milliseconds used by a
         request in the workload group."
    ::= { ss2WorkloadGroupStatsEntry 6 }

ss2wgsMaxRequestMemoryGrantKB OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Maximum value of memory grant in kilobytes
         used by a query in the workload group."
    ::= { ss2WorkloadGroupStatsEntry 7 }

ss2wgsQueryOptimizationsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of query optimizations per second
         occurring in the workload group."
    ::= { ss2WorkloadGroupStatsEntry 8 }

ss2wgsQueuedRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of requests waiting in the queue due to
         resource governor limits in the workload
         group."
    ::= { ss2WorkloadGroupStatsEntry 9 }

ss2wgsReducedMemoryGrantsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of queries per second getting less than
         ideal amount of memory in the workload group."
    ::= { ss2WorkloadGroupStatsEntry 10 }

ss2wgsRequestsCompletedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of completed requests per second in the
         workload group."
    ::= { ss2WorkloadGroupStatsEntry 11 }

ss2wgsSuboptimalPlansPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of suboptimal query plans generated per
         second in the workload group."
    ::= { ss2WorkloadGroupStatsEntry 12 }

sqlServerAgentV2 OBJECT IDENTIFIER
    ::= { sqlServerV2 3 }

sa2NameTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Sa2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "This table contains the list of SQL Server
         Agent instance names installed. The
         ss2NameIndex is used to refer to all other SQL
         Server Agent SNMP entries."
    ::= { sqlServerAgentV2 1 }

sa2NameEntry OBJECT-TYPE
    SYNTAX      Sa2NameEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         Agent name instance."
    INDEX       { sa2NameIndex }
    ::= { sa2NameTable 1 }

Sa2NameEntry ::= SEQUENCE {
    sa2NameIndex        INTEGER,
    sa2NameInstance     InstanceName
}

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

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

sa2AlertsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Sa2AlertsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Server Agent Alerts performance object
         contains performance counters that report
         information about SQL Server Agent alerts."
    ::= { sqlServerAgentV2 2 }

sa2AlertsEntry OBJECT-TYPE
    SYNTAX      Sa2AlertsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Alerts' object."
    INDEX       { sa2NameIndex }
    ::= { sa2AlertsTable 1 }

Sa2AlertsEntry ::= SEQUENCE {
    sa2AlertsActivatedAlerts        Gauge,
    sa2AlertsAlertsActivatedMinute  Gauge
}

sa2AlertsActivatedAlerts OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of Alerts that have activated since
         the last SQL Server restart."
    ::= { sa2AlertsEntry 1 }

sa2AlertsAlertsActivatedMinute OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of Alerts that have activated
         within the last minute."
    ::= { sa2AlertsEntry 2 }

sa2JobsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Sa2JobsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Server Agent Jobs performance object
         contains performance counters that report
         information about SQL Server Agent jobs."
    ::= { sqlServerAgentV2 3 }

sa2JobsEntry OBJECT-TYPE
    SYNTAX      Sa2JobsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Jobs' object."
    INDEX       { sa2NameIndex, sa2JobsInstance }
    ::= { sa2JobsTable 1 }

Sa2JobsEntry ::= SEQUENCE {
    sa2JobsInstance                 InstanceName,
    sa2JobsActiveJobs               Gauge,
    sa2JobsFailedJobs               Gauge,
    sa2JobsJobSuccessRate           Gauge,
    sa2JobsJobsActivatedPerMinute   Gauge,
    sa2JobsQueuedJobs               Gauge,
    sa2JobsSuccessfulJobs           Gauge
}

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

sa2JobsActiveJobs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of running jobs."
    ::= { sa2JobsEntry 2 }

sa2JobsFailedJobs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of failed jobs."
    ::= { sa2JobsEntry 3 }

sa2JobsJobSuccessRate OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Percentage of successful jobs from the total
         number of executed jobs."
    ::= { sa2JobsEntry 4 }

sa2JobsJobsActivatedPerMinute OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of jobs activated within the last
         minute."
    ::= { sa2JobsEntry 5 }

sa2JobsQueuedJobs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of jobs queued."
    ::= { sa2JobsEntry 6 }

sa2JobsSuccessfulJobs OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of successful jobs."
    ::= { sa2JobsEntry 7 }

sa2JobStepsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Sa2JobStepsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Server Agent JobSteps performance
         object contains performance counters that
         report information about SQL Server Agent job
         steps."
    ::= { sqlServerAgentV2 4 }

sa2JobStepsEntry OBJECT-TYPE
    SYNTAX      Sa2JobStepsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'JobSteps' object."
    INDEX       { sa2NameIndex, sa2JobStepsInstance }
    ::= { sa2JobStepsTable 1 }

Sa2JobStepsEntry ::= SEQUENCE {
    sa2JobStepsInstance             InstanceName,
    sa2JobStepsActiveSteps          Gauge,
    sa2JobStepsQueuedSteps          Gauge,
    sa2JobStepsTotalStepRetries     Gauge
}

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

sa2JobStepsActiveSteps OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active steps."
    ::= { sa2JobStepsEntry 2 }

sa2JobStepsQueuedSteps OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of queued steps."
    ::= { sa2JobStepsEntry 3 }

sa2JobStepsTotalStepRetries OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The total number of times any Job Step
         execution is retried since the last SQL Server
         restart."
    ::= { sa2JobStepsEntry 4 }

sa2StatisticsTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Sa2StatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "The SQL Server Agent Statistics performance
         object contains performance counters that
         report information about SQL Server Agent."
    ::= { sqlServerAgentV2 5 }

sa2StatisticsEntry OBJECT-TYPE
    SYNTAX      Sa2StatisticsEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'Statistics' object."
    INDEX       { sa2NameIndex }
    ::= { sa2StatisticsTable 1 }

Sa2StatisticsEntry ::= SEQUENCE {
    sa2StatisticsSQLServerRestarted     Gauge
}

sa2StatisticsSQLServerRestarted OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "The number of times the SQL Server has been
         successfully restarted by SQL Server Agent,
         since the last SQL Server Agent restart."
    ::= { sa2StatisticsEntry 1 }

reportingServicesV2 OBJECT IDENTIFIER
    ::= { sqlServerV2 4 }

rs2WebService OBJECT IDENTIFIER
    ::= { reportingServicesV2 1 }

rs2wbsActiveSessions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active sessions."
    ::= { rs2WebService 1 }

rs2wbsCacheHitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of report server cache hits per
         second."
    ::= { rs2WebService 2 }

rs2wbsCacheHitsSecSemanticModels OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times  second that models can be
         retrieved from the cache."
    ::= { rs2WebService 3 }

rs2wbsCacheMissesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports cannot
         be retrieved from cache."
    ::= { rs2WebService 4 }

rs2wbsCacheMissesSecSemantModels OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times  second that models cannot be
         retrieved from the cache."
    ::= { rs2WebService 5 }

rs2wbsFirstSessionRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of new user sessions that are started
         per second."
    ::= { rs2WebService 6 }

rs2wbsMemoryCacheHitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports can be
         retrieved from the in memory cache."
    ::= { rs2WebService 7 }

rs2wbsMemoryCacheMissPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports cannot
         be retrieved from the in memory cache."
    ::= { rs2WebService 8 }

rs2wbsNextSessionRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of requests per second for reports that
         are open in an existing session."
    ::= { rs2WebService 9 }

rs2wbsReportRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active report requests."
    ::= { rs2WebService 10 }

rs2wbsReportsExecutedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of reports executed per second."
    ::= { rs2WebService 11 }

rs2wbsRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of requests per second."
    ::= { rs2WebService 12 }

rs2wbsTotalCacheHits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of report server cache hits."
    ::= { rs2WebService 13 }

rs2wbsTotalCacheHitSemanticModel OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache hits made in the model
         cache."
    ::= { rs2WebService 14 }

rs2wbsTotalCacheMisses OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses."
    ::= { rs2WebService 15 }

rs2wbsTotalCachMissSemanticModel OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses made in the model
         cache."
    ::= { rs2WebService 16 }

rs2wbsTotalMemoryCacheHits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache hits made in the in
         memory cache."
    ::= { rs2WebService 17 }

rs2wbsTotalMemoryCacheMisses OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses made in the in
         memory cache."
    ::= { rs2WebService 18 }

rs2wbsTotalProcessingFailures OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of processing failures."
    ::= { rs2WebService 19 }

rs2wbsTotalRejectedThreads OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of rejected threads as a result
         of thread pressure."
    ::= { rs2WebService 20 }

rs2wbsTotalReportsExecute OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of reports executed."
    ::= { rs2WebService 21 }

rs2wbsTotalRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of requests being processed."
    ::= { rs2WebService 22 }

rs2WindowsServiceTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Rs2WindowsServiceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "A table containing performance information for
         instances of 'MSRS Windows Service' objects."
    ::= { reportingServicesV2 2 }

rs2WindowsServiceEntry OBJECT-TYPE
    SYNTAX      Rs2WindowsServiceEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one particular
         instance of 'MSRS Windows Service' object."
    INDEX       { rs2wnsInstance }
    ::= { rs2WindowsServiceTable 1 }

Rs2WindowsServiceEntry ::= SEQUENCE {
    rs2wnsInstance                      InstanceName,
    rs2wnsActiveSessions                Gauge,
    rs2wnsCacheFlushesPerSec            Gauge,
    rs2wnsCacheHitsPerSec               Gauge,
    rs2wnsCacheHitsSecSemanticModels    Gauge,
    rs2wnsCacheMissesPerSec             Gauge,
    rs2wnsCacheMissSecSemanticModels    Gauge,
    rs2wnsDeliversPerSec                Gauge,
    rs2wnsEventsPerSec                  Gauge,
    rs2wnsFirstSessionRequestsPerSec    Gauge,
    rs2wnsMemoryCacheHitsPerSec         Gauge,
    rs2wnsMemoryCacheMissPerSec         Gauge,
    rs2wnsNextSessionRequestsPerSec     Gauge,
    rs2wnsReportRequests                Gauge,
    rs2wnsReportsExecutedPerSec         Gauge,
    rs2wnsRequestsPerSec                Gauge,
    rs2wnsSnapshotUpdatesPerSec         Gauge,
    rs2wnsTotalAppDomainRecycles        Gauge,
    rs2wnsTotalCacheFlushes             Gauge,
    rs2wnsTotalCacheHits                Gauge,
    rs2wnsTotalCacheHitSemanticModel    Gauge,
    rs2wnsTotalCacheMisses              Gauge,
    rs2wnsTotalCachMissSemanticModel    Gauge,
    rs2wnsTotalDeliveries               Gauge,
    rs2wnsTotalEvents                   Gauge,
    rs2wnsTotalMemoryCacheHits          Gauge,
    rs2wnsTotalMemoryCacheMisses        Gauge,
    rs2wnsTotalProcessingFailures       Gauge,
    rs2wnsTotalRejectedThreads          Gauge,
    rs2wnsTotalReportsExecuted          Gauge,
    rs2wnsTotalRequests                 Gauge,
    rs2wnsTotalSnapshotUpdates          Gauge
}

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

rs2wnsActiveSessions OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active sessions."
    ::= { rs2WindowsServiceEntry 2 }

rs2wnsCacheFlushesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of cache flushes per second."
    ::= { rs2WindowsServiceEntry 3 }

rs2wnsCacheHitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of report server cache hits per
         second."
    ::= { rs2WindowsServiceEntry 4 }

rs2wnsCacheHitsSecSemanticModels OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times  second that models can be
         retrieved from the cache."
    ::= { rs2WindowsServiceEntry 5 }

rs2wnsCacheMissesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports cannot
         be retrieved from cache."
    ::= { rs2WindowsServiceEntry 6 }

rs2wnsCacheMissSecSemanticModels OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times  second that models cannot be
         retrieved from the cache."
    ::= { rs2WindowsServiceEntry 7 }

rs2wnsDeliversPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of delivers deliveries per second."
    ::= { rs2WindowsServiceEntry 8 }

rs2wnsEventsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of events per second."
    ::= { rs2WindowsServiceEntry 9 }

rs2wnsFirstSessionRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of new user sessions that are started
         per second."
    ::= { rs2WindowsServiceEntry 10 }

rs2wnsMemoryCacheHitsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports can be
         retrieved from the in memory cache."
    ::= { rs2WindowsServiceEntry 11 }

rs2wnsMemoryCacheMissPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of times per second that reports cannot
         be retrieved from the in memory cache."
    ::= { rs2WindowsServiceEntry 12 }

rs2wnsNextSessionRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of requests per second for reports that
         are open in an existing session."
    ::= { rs2WindowsServiceEntry 13 }

rs2wnsReportRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of active report requests."
    ::= { rs2WindowsServiceEntry 14 }

rs2wnsReportsExecutedPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of reports executed per second."
    ::= { rs2WindowsServiceEntry 15 }

rs2wnsRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of requests per second."
    ::= { rs2WindowsServiceEntry 16 }

rs2wnsSnapshotUpdatesPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of snapshot updates per second."
    ::= { rs2WindowsServiceEntry 17 }

rs2wnsTotalAppDomainRecycles OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of application domain recycles."
    ::= { rs2WindowsServiceEntry 18 }

rs2wnsTotalCacheFlushes OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of report execution server cache
         updates."
    ::= { rs2WindowsServiceEntry 19 }

rs2wnsTotalCacheHits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of report server cache hits."
    ::= { rs2WindowsServiceEntry 20 }

rs2wnsTotalCacheHitSemanticModel OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache hits made in the model
         cache."
    ::= { rs2WindowsServiceEntry 21 }

rs2wnsTotalCacheMisses OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses."
    ::= { rs2WindowsServiceEntry 22 }

rs2wnsTotalCachMissSemanticModel OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses made in the model
         cache."
    ::= { rs2WindowsServiceEntry 23 }

rs2wnsTotalDeliveries OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of deliveries."
    ::= { rs2WindowsServiceEntry 24 }

rs2wnsTotalEvents OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of events."
    ::= { rs2WindowsServiceEntry 25 }

rs2wnsTotalMemoryCacheHits OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache hits made in the in
         memory cache."
    ::= { rs2WindowsServiceEntry 26 }

rs2wnsTotalMemoryCacheMisses OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of cache misses made in the in
         memory cache."
    ::= { rs2WindowsServiceEntry 27 }

rs2wnsTotalProcessingFailures OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of processing failures."
    ::= { rs2WindowsServiceEntry 28 }

rs2wnsTotalRejectedThreads OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of rejected threads as a result
         of thread pressure."
    ::= { rs2WindowsServiceEntry 29 }

rs2wnsTotalReportsExecuted OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of reports executed."
    ::= { rs2WindowsServiceEntry 30 }

rs2wnsTotalRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of requests being processed."
    ::= { rs2WindowsServiceEntry 31 }

rs2wnsTotalSnapshotUpdates OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of report execution snapshot
         updates."
    ::= { rs2WindowsServiceEntry 32 }

rs2ReportServerHTTPTable OBJECT-TYPE
    SYNTAX      SEQUENCE OF Rs2ReportServerHTTPEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Statistics related to Report Server HTTP
         Service"
    ::= { reportingServicesV2 3 }

rs2ReportServerHTTPEntry OBJECT-TYPE
    SYNTAX      Rs2ReportServerHTTPEntry
    ACCESS      not-accessible
    STATUS      mandatory
    DESCRIPTION 
        "Performance information for one SQL Server
         name instance."
    INDEX       { rs2HTTPNameIndex }
    ::= { rs2ReportServerHTTPTable 1 }

Rs2ReportServerHTTPEntry ::= SEQUENCE {
    rs2HTTPNameIndex        INTEGER,
    rs2HTTPNameInstance     InstanceName,
    rs2HTTPRequestsPerSec   Gauge,
    rs2HTTPTotalRequests    Gauge
}

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

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

rs2HTTPRequestsPerSec OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Number of HTTP requests received."
    ::= { rs2ReportServerHTTPEntry 3 }

rs2HTTPTotalRequests OBJECT-TYPE
    SYNTAX      Gauge
    ACCESS      read-only
    STATUS      mandatory
    DESCRIPTION 
        "Total number of HTTP requests received."
    ::= { rs2ReportServerHTTPEntry 4 }

END -- end of module INFORMANT-SQLSERVER-V2.