SQL Server Configuration Guide
Preface
Architecture and Hardware
General Performance Notes
App Control Server One-tier Architecture
App Control Server Two-tier Architecture
Choosing Proper Hardware for the SQL Server
Choosing Proper Hardware for App Control Server
Network Configuration
Network Latency Impact
SQL Permissions and Memory Configuration
SQL Permissions
SQL Server Memory Configuration
App Control Server Database Storage
Database Files
SSD and Flash Storage Lifetime
Database Size Calculator
Moving Database Files after Installing App Control Server
App Control Server and Storage Area Networks
Using a SAN with App Control Server
Validating Storage Performance
Using the CBPTest Tool - Disk Performance Testing Tool
SQL Server Maintenance
Scheduled Database Tasks
Database Growth