ScaleArc for SQL Server Administrator's Guide

Introducing ScaleArc

Installing ScaleArc

Configuring ScaleArc Clusters

Settings Column

Managing Users & DBs
Transparent Cache
>> Defining Cache Rules
>> Cache Manager
>> Configuring Stored Procedure Query Caching
>> Cache Invalidation
Load Balancing and Routing
Configuring Query Firewall Rules
Log Settings
Configuring Database Servers

Getting started	Installing ScaleArc	Configure ScaleArc
Learn the benefits and features of ScaleArc.	Evaluate your on-premise or cloud-based enterprise Install or upgrade ScaleArc. Initialize ScaleArc and configure its basic functions.	Create a ScaleArc endpoint cluster. Configure advanced features for load balancing, zero downtime, AlwaysOn, and automated failover, security, and performance
Administering ScaleArc	Real-Time Monitoring	ScaleArc Analytics
Administer ScaleArc's many systems, cluster, and log settings.	Live monitor ScaleArc for upgrading performance in real-time.	Use the powerful suite of Analytics tools to review, evaluate, and manage performance and security at varying degrees of granularity.

Administering ScaleArc	Real-Time Monitoring
Administering ScaleArc - Introduction Network Settings Configuration System Settings >> System Status >> System Config >> System Services >> Setting up Windows Active Directory >> Setting up Azure Active Directory Configuring Email Alerts Setting up HA (High Availability) License Settings User Management >> Policy and Access Control Configuration >> Authentication Configuration >> Editing the Authentication Module Using ScaleArc RESTful APIs Managing CPU Distribution	Real-Time Monitoring - Introduction Live Monitor - System Stats Live Monitor - Cluster Stats Live Monitor - Historical Stats Live Monitor - Logs Live Monitor - Diagnostics >> File Browser >> Traffic Analyzer Live Monitor - Value Meter

Analytics	Appendices
Using ScaleArc Analytics Analytics - Total Cluster Traffic Analysis Analytics - Cluster Analysis Analytics - Database Server Analysis Analytics - Query Pattern Analysis Analytics - Unique Query Analysis Analytics - Comparative Analysis Analytics - Log Search	>> Deployment checklist >> Cluster configuration checklist >> ScaleArc Sizing Guide >> ScaleArc Appliance Console Login >> List of ports on ScaleArc >> CPU distribution - Thread Mapping >> Best practices for VM migration >> Database replication topologies >> Third-party software dependencies

Table of Contents