Falanguage icon
×
Products
Services
Resources
About Us

/Microsoft SQL Server

Microsoft SQL Server backgroundMicrosoft SQL Server
Microsoft SQL Server backgroundMicrosoft SQL Server
Databases
DB2HazelcastMicrosoft SQL ServerOracle DatabaseMariaDBPostgreSQLMySQLDB2/ZElastic SearchCassandraApache HbaseRedisMongoDBMemcached

Microsoft SQL Server Monitoring

Integrated operations monitoring system, Moein, is a monitoring system whose services expand to all layers of Information Technology (IT). As databases are among the most widely used service systems in IT domain, one side of Moein focuses on the monitoring of this type of application-level products. Monitoring Microsoft SQL database as one of the databases commonly used in the organization and medium scale is fully supported by Moein. Success ratio of cache and buffer, request time for connection, metrics related to the existing databases, Backup, Restore and Log Shipping metrics, key performance metrics related to sessions and top queries are some of the items that are provided to the administrators in this database. The details of the supported metrics of this database are presented below:

Mssql.overview.en

Metrics per database:

  1. Database ID
  2. Database Creation Date
  3. Database Status
  4. Database File Size
  5. Database Log File Size
  6. Database Log File Used Size
  7. Database Log File Used Percentage

Mssql.databases.en

 Memory Metrics :

  1. Total System Memory Size
  2. SQL Cache Memory Size
  3. Lock Memory Used Size
  4. Optimizer Memory Used Size
  5. Connection Memory Used Size
  6. Granted WorkSpace Memory Size
  7. Memory Grants Pending
  8. Memory Grants Outstanding
  9. Stolen Server Memory
  10. Target Server Memory
  11. Total OS Memory Size
  12. Free OS Memory Size
  13. OS Memory Used Percentage
  14. Cache Memory Size
  15. Total Page File Size
  16. Page File Free Size
  17. Page File Used Percentage
  18. OS Memory Status

Mssql.kpi.en

 Buffer Metrics:

  1. Buffer Hit Ratio
  2. Page Lookups Rate
  3. Page read Rate
  4. Page Write Rate
  5. Database Pages
  6. Page Life Expectancy

 Cache Metrics:

  1. Cache Hit Ratio
  2. Cache Objects In Use
  3. Number Of Cache Objects
  4. Cache Pages

 Lock Metrics:

  1. Lock Request Rate
  2. Lock Waits Rate
  3. Lock Timeout Rate
  4. Deadlock Rate
  5. Average Lock Wait Time

Connections Metrics:

  1. User Connections
  2. Login Rate
  3. Logout Rate

 SQL Transactions Statistics:

  1. Batch Requests Rate
  2. SQL Compilation Rate
  3. SQL Recompilation Rate
  4. Auto-Params Attempts Rate
  5. Failed Auto-Params Rate

Backups information:

  1. List Of Backups
  2. Backup Status
  3. Backup Start Time
  4. Backup Finish Time
  5. Backup Size
  6. Backup Type

Mssql.maintenance.en

Sessions Metrics:

  1. List Of Sessions
  2. Session Status
  3. Database Name
  4. Username
  5. Session Memory Usage
  6. CPU Time

Mssql.sessions.en

Top Queries in terms of different parameters:

  1. Top Queries with respect to Average CPU Time
  2. Most Frequently Executed Queries
  3. TOP Query with respect to IO usage
  4. TOP Query with respect to CLR
  5. Top Slow Running Queries
  6. Most Blocked Queries
  7. Top Queries with respect to (Lowest) Plan Reuse

Mssql.top Queries.en

Communication Protocols:

  • JDBC
Databases
DB2HazelcastMicrosoft SQL ServerOracle DatabaseMariaDBPostgreSQLMySQLDB2/ZElastic SearchCassandraApache HbaseRedisMongoDBMemcached
Address
3rd floor, No. 8, 2nd dead-end, Sadeghi St., Azadi Ave., Tehran, Iran, Postal code 1458846155