• Grey YouTube Icon
  • LInkedIn MS SQL
  • Facebook
  • Twitter

+420 222 745 000 | info@apponfly.com | mssql.apponfly.com

AppOnFly SQL

Microsoft SQL Server 2019

Technical overview

Dedicated virtual private server with Windows Server 2019 and SQL Server 2019 running on top of Hyper-V cluster. Optional Application server for higher security and offloading application load from SQL server. Administrator access via Remote desktop. User access restricted to specific IP adresses, VPN or public.

AppOnFly SQL Overview

Storage & compute cluster node

Fine tuned, high performance and great operational expeience.
Dell PowerEdge R740xd
  • 2x Intel Xeon Gold 6244, 3.60 GHz up to 4.40 GHz, 8C/16T, 24.75MB cache

  • 1.536 GB RAM, 2.933 MHz, performance optimized

  • BOSS controller card, 2x 240GB RAID 1

  • PERC H740P RAID Controller, 8Gb NV Cache

  • 24x 3.84TB SSD PM883

  • Dual, Hot-plug, Redundant Power Supply (1+1), 1100W

  • iDRAC9,Enterprise

  • Broadcom 57416 2 Port 10Gb Base-T + 5720 2 Port 1Gb Base-T

  • 2x Mellanox ConnectX-3 Pro Dual Port 10 GbE SFP+

Software licenses

Use industry leading software for a fraction of the cost.
Operating system
  • Microsoft Windows Server 2019 Datacenter

SQL Server
  • Microsoft SQL Server 2019 Enterprise

Management and backup
  • Microsoft System Center 2019 Datacenter

    • Configuration Manager

    • Data Protection Manager

    • Endpoint Protection

    • Operations Manager

    • Orchestrator

    • Service Manager

    • Virtual Machine Manager

Take advantage of Datacenter and Enterprise licenses

Physical servers nodes (virtual machines hosts) are licensed with Windows Datacenter, System Center Datacenter and SQL Enterprise editions. Although Standard editions are installed by default, Datacenter and Enterprise licenses are included and allows you to:

  • Use any System Center products in Application and SQL servers

  • Run any number of SQL instances or containers in SQL Server

  • Free upgrade to SQL Enterprise edition on request

  • Setup SQL Always-on high available multi-node clusters

Tips and tricks to save your costs
  • Use SQL Server virtual machine for SQL load only. Run System Center or any other appliacation load on separate application servers, which are not covered with SQL licenses and therefore are way far cost-effective.

  • Make CPU benchmarks and use only necessary number of CPUs with appropriate performance

  • Add as much memory as your budget allows, the best is to fit your whole database working set into memory

  • For super-high IO databases, use 30.000 IOPS SSD Tier

Datacenter and security

Ultimate security, Tier III certification and geographically separated disaster recovery sites.
High availability, reliability and disaster recovery
  • High voltage power is supplied by two independent 2x 10MW 22kV power connections. The backup comprises a total of nine 14 MVA diesel generators.

  • Low voltage power provided by nine separate power substations with N+1 configurations. All systems are backed up by separate UPS.

  • Cooling is designed with N+1 on the source as well as the distribution side. All components of the cooling system are redundant and powered from two independent sources of electricity.

  • Disaster recovery site TTC DC 1 - geographically separated locations with 2x 10Gbs redundant southern and northern route.

TTC DC2 Datacenter certifications
  • Tier III: International Data Center Tier Standards for reliability and overall data center performance

  • PCI DSS Compliant: The Payment Card Industry Data Security Standard is a set of security standards designed to ensure that ALL companies that accept, process, store or transmit credit card information maintain a secure environment.

  • ISO 9001: International symbol of quality for document circulation, human resources, infrastructure, customer communication processes and supplier evaluation

  • ISO 14001: Certification ensuring high level criteria for an environmental management system

  • ISO 20000: Certification guaranteeing an international standard for IT management and service delivery

  • ISO 27001: Certification ensuring a high level and quality of information security management

European Union - Czech Republic based datacenter

High availability, reliability and disaster recovery

Advanced setup for mission critical databases, detailed disaster recovery plans and their regular testing ensure absolute reliability of AppOnFly SQL.
SQL Clustering with variety of options
  • SQL Always-on availability groups multi-node cluster for high-performance mission critical databases

  • SQL basic Always-on availability two-node cluster with failover replica for standard database applications

  • Asynchronous-commit or synchronous-commit modes

  • Planned manual failover or automatic failover

  • Primary datacenter only or distributed over primary datacenter and disaster recovery site

Application servers and data replication
  • Hyper-V Replica can be used for application and file servers replication

  • Hyper-V Replica creates a copy of a live virtual machine to a replica offline virtual machine

  • Single or multiple recovery points

  • Continuous protection or specific replication frequency

  • Planned manual failover or automatic failover

  • Primary datacenter only or replicated from primary datacenter to disaster recovery site

Backup and recovery
  • Microsoft System Center Data Protection Manager:

    • Host-level backup (snapshot-aware backup of entire virtual machine)

    • Database backup with DPM agent installed

    • Volume and file backup for specific drives or files, eg. transaction logs

  • Advanced backup and recovery plans available:

    • Continuous backup protection

    • Operational backup available for administrators and developers

    • Security backup as a protection against cyber threats

  • Backup to local storage or dedicated file server in primary datacenter or backup storage in disaster recovery site

Networking and security

Next generation firewall with advanced security profiles ready to protect your SQL Server.
AppOnFly SQL Security - FortiGate200E
Fortigate 200E UTM Firewall
  • Clustered solution for high availability

  • Protect against cyber threats with security processor powered high performance, security efficacy and deep visibility

  • Dedicated Virtual Domain available

  • 2x 1Gbs high bandwidth & low latency datacenter ports

Securely connect from everywhere
  • Utilize Fortigate IP Firewall to secure direct access to SQL Server:

    • Limit user access ​to specific source IP addresses only, eg. access from company offices only

    • ​Set up site-to-site Virtual Private Network, eg. VPN between company offices and AppOnFly datacenter

    • ​Set up client Virtual Private Network, eg. VPN between user laptop and AppOnFly datacenter

  • Further increase security by adding optional application server in front of your SQL Server:

    • Limit direct access to SQL Server at all

    • Forward all user traffic to application server

    • Great for public access to your web, e-commerce or any other application

SQL monitoring, management and premium support

We cover your back, every 60 seconds, 24/7.
AppOnFly SQL - Zabbix Monitoring
Proactive monitoring
  • Real-time monitoring hundreds of operational values of SQL Server and underlying infrastructure:

    • Servers, storage and networking hardware

    • CPU performance, memory usage, SSD performance

    • SQL server performance and clusters availability, SQL performance, server eventlogs and much more

  • 60 seconds evaluation period

  • Zabbix enterprise-class monitoring solution

Immediate incident response
  • Automated enhanced escalations plans

  • Access to comprehensive knowledge base with hundreds ready-to-go solutions

  • Detailed step-by-step ​processes

    • Operations recovery plans

    • Maintenance plans

    • Disaster recovery plans​

    • Backup & restore plans

Complete team 24/7 availability
  • Helpdesk team, monitoring operators and 1st level support

  • Infrastructure engineers

  • Microsoft certified Windows & SQL Server experts

  • Ready to help with SQL operations, data migrations, maintenance, upgrades, performance tuning, clustering, backup and disaster recovery and more