Microsoft SQL Server is commonly used by businesses for small-to-medium databases as well as for larger enterprise databases. It is absolutely necessary to monitor MS SQL Server 24x7 to ensure that your business-critical applications perform effectively. Proactive monitoring helps prevent downtime and quickly fix problems after they arise, but also to know the health of individual components and to identify potential problems and performance degradations before they turn into costly downtime.

OpManager On-Demand remotely monitors and discovers systems that support MS SQL server, using WMI protocol and gathers data by applying various WMI classes. MSSQL database monitor counters include Data Files size, Log files Used Percentage, Active Transactions, Log growths, Log shrinks, Log files free size, Log Cache hit ratio, etc.

Problems like increase in database size can be monitored by the 'Data Files Size' monitor, which shows cumulative size of all data files in the database including any automatic growth. Monitoring this counter is useful to determine the correct size of the databases. By proactively monitoring the databases and configuring thresholds, probable database size bottlenecks can be got ridden of.

MS SQL Monitoring-Lock-related Monitors, Cache, Memory and Buffer Monitors

A growing number of users complain that they have to wait for their transactions to complete is an indicator of trouble. Longer waiting time may mean that the object locking on the server might be contributing to this problem. OpManager On-Demand's MSSQL monitor's lock-related monitors help in identifying the locks causing transaction delays so that you can investigate further and find out the cause. Other performance metrics monitored include buffer monitors, cache monitors, & memory monitors. Monitoring these critical metrics will help identify performance bottle-necks early on. OpManager On-Demand does a good job in identifying this through setting up of thresholds & notifying you of the imminent failure.

Benefits

• Detect MS SQL server problems quickly and minimize downtime
• Pin-point the exact point of failure to make sure MSSQL server is up and running quickly
• Detect and correct potential degradations before they impact end users
• Know the health of your MS SQL server inside out