CA Nimsoft Monitor for SQL Server

Solution Briefs

Share

Published: 19 Nov 2012

Many of your organization’s most vital information assets reside in Microsoft SQL Server databases. Turn to CA Nimsoft Monitor for SQL Server to help ensure those assets are continuously available to the users and applications that need them.

Key Features

Extensive SQL Server Monitoring Capabilities

  • Comprehensive SQL Server coverage.
    CA Nimsoft Monitor gives you a comprehensive view of your entire SQL Server infrastructure, whether you’re looking to monitor a single database instance on a single server, or multiple instances on multiple server clusters. CA Nimsoft Monitor allows you to manage both local and remote database servers, and it delivers comprehensive server performance metrics—including uptime, free log file space, log file cache hit ratio, and more.
  • Fast insights.
    With its centralized view of all SQL Server instances, CA Nimsoft Monitor enables you to quickly get the insights you need to optimize the performance and availability of your entire SQL Server infrastructure. CA Nimsoft Monitor offers granular capabilities for setting thresholds, polling schedules, and alarms—so you can ensure your team is notified of potential issues when needed.
  • Efficient deployment and administration.
    CA Nimsoft Monitor offers a simple configuration process that makes setup and deployment fast and efficient. Using a standard interface, you can quickly define which database servers and database instances are to be monitored, and what metrics are to be collected. Further, CA Nimsoft Monitor features templates that automatically apply the appropriate monitoring settings when new SQL Server instances come online. These capabilities can significantly reduce the administrative burden of monitoring large numbers of SQL Server servers.

Benefits

The Power of Intelligent SQL Server Monitoring

  • Improved performance and uptime.
    CA Nimsoft Monitor offers flexible, sophisticated alerting capabilities that accelerate the identification of performance issues—enabling response before end user productivity is affected. Plus, with our PMDB, you can also track key historical performance metrics to intelligently assess performance trends and more effectively guard against potential issues.
  • Enhanced resource optimization.
    By delivering a centralized, comprehensive view of performance, CA Nimsoft Monitor gives you invaluable insights into opportunities for better utilizing your existing resources.
  • Reduced monitoring administration cost and effort.
    With its capabilities for building templates and automating new database instance monitoring, CA Nimsoft Monitor significantly reduces the time and effort required to monitor SQL Server database environments.

Technical Details

The Power of Intelligent SQL Server Monitoring

CA Nimsoft Monitor for SQL Server can track and report on the following metrics:

  • Local and/or remote monitoring of SQL Servers
  • Server uptime
  • Size of database
  • Buffer cache-hit ratio
  • Log-file cache-hit ratio
  • Free log-file space
  • Number of:
    • databases
    • active users
    • logged-in users
    • deadlocks per second
    • transactions per second
    • database reads
    • database writes
    • flush waits
    • latch waits
    • full scans
  • Transaction log growth
  • Transaction log shrinking

Platform Features

Agent-optional Coverage Alarm Console
MM Easily monitor local or remote environments See, assign, and close alarms. Fast.
Alarm Database APIs and SDKs
Accelerate problem resolution. Tailor the solution to meet your unique business requirements.
Automatic Discovery & Deployment CA Nimsoft Portal
Keep informed of changes to your infrastructure. Unified view of IT performance
Executive Dashboards Flexible Pricing & Licensing
Powerful out-of-box executive views Works with your budget, and your business.
Gateways and 3rd Party Integration IT Service Level Management
Integrate all of your IT management tools with ease. Set, meet, and exceed your SLAs.
ITIL Compatible Message Bus
Best-practices. Built-in. Rest assured that your solution is future ready.
Multi-tenant CA Nimsoft for iPhone
Scale your services—efficiently and economically. A unified view, now in your pocket.
On-Premise or SaaS Performance Management Database (PMDB)
Flexibility to suit your business. Spot trends before they become problems.
Security Usage-based Metering & Billing
Keep private data private. Provide pay-as-you-grow scalability for your customers.
Web Archive
Access the world’s largest collection of IT monitoring probes.