Argent for SQL Server

Argent for SQL Server is more than just a monitoring solution — like all Argent products, Argent for SQL Server is a complete automation solution, automating all the essential but labor-intensive chores that all customers must perform to ensure SQL Server runs smoothly.

With all the layoffs, there are fewer people to do more work – this is why Argent’s unique Instant Best Practices is essential – who has the time to read White Papers?

The most significant aspect of Argent for SQL Server is the use of a number of different approaches to monitoring SQL Server: PowerShell, WMI, and classic Windows APIs are all used in different parts of the product. Think of Argent for SQL Server as four or five discrete products all integrated into one super-product.

Image Image

Details

SQL Server 2000 through to SQL Server 2016 environments are fully supported.

Argent for SQL Server monitors and reports on SQL Server baselines, disk I/O rates, queue lengths, soft and hard page faults, and tracking logs – all within a single interface.

Argent’s legendary alerting with 18 different types of alerts is fully integrated into Argent for SQL Server.

Argent for SQL Server comes with pre-defined SLA reports that can be automatically emailed every morning to show the actual health and performance of SQL Server.

What are Instant Best Practices?

Instant Best Practices are Argent’s unique technology that combines the best expert knowledge into one fully-integrated solution.

Until Instant Best Practices, you’d have to read tedious White Papers, download and install quirky scripts, install so-called “Management” packs, find a slew of vendors’ add-ons, etc, etc, etc.

All these tedious chores took you time and not to mention all the finger pointing from different vendors.

Rather than being a manager and looking to move up the food chain, you were stuck wasting your time doing the donkey work of trying to make yet-another badly written script work for your environment.

Argent Instant Best Practices – Ready For Tomorrow

With Argent’s unique technology, hassles are a thing of the past.

There are a lot of critical variables, thresholds, metrics and components you need to be on top of.

But there’s the rub – what variables should you monitor?

Even after you’ve read all the dozens of Technical Papers, Tuning Guides, downloaded all the scripts, you now have to decide what values make sense.

With Argent’s Instant Best Practices, all the donkey work is done for you – Instant Best Practices has all the critical variables and values defined.

In one click you can have Argent Instant Best Practices working for you.

The following is a partial list of installed Rules. Out-of-the-box, Argent handles over 95% of your day-to-day needs.
Argent solves all your day-to-day problems — automatically.

Backups

  • Database Backup Due Dates
  • Database Integrity Checks

Configuration Checks

  • Log and Data File Growth
  • Log and Data File Locations
  • Max Server Memory
  • Processor Cores
  • TempDB Space and Data Size
  • SQL Security

Database Statistics

  • Database Free Space
  • Transaction Log Size
  • Database Free Space
  • Fragmentation
  • Offline Databases
  • Transaction Log Shipping

Database Settings

  • Auto-Create Statistics
  • Auto-Shrink Options
  • Auto-Update Statistics
  • Page Verify

General Statistics

  • Login/Logout Per Second
  • Processes Blocked

SQL Statistics

  • Batch Requests
  • Re-compilation Ratios
  • SQL Compilations

Performance

  • Buffer Cache Hit Ratios
  • Page Life Expectancy
  • Checkpoint Pages
  • Lazy Writes
  • Free Pages
  • Memory Grants
  • Page Splits
  • Lock Waits
  • Deadlock Counts
  • Latch Waits
  • Memory Usage
  • CPU Usage
  • Disk Usage and I/O
  • Replication Latency
  • Concurrent Users

Queries

  • Custom SQL Query Rules
  • Blocked Queries
  • Runaway Queries

SQL Agent

  • SQL Job Status
  • Blocked Queries
  • Runaway Queries