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:

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

 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

 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

Sessions Metrics:

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

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

Communication Protocols:

• JDBC