AIM Business Driven Data Solutions Logo

Networking Services for the Local Office using Access, IIS, and Visual Studio
Networking Services for Enterprise Companies using SQL Server, IIS, and Visual Studio

  • Performance Tuning
  • Input/Output per Second (IOPS)
  • Bandwidth (MB/s)
  • Core and Memory Sizing

  • Disaster Recovery
  • Availability Groups
  • Backup and Restore
  • Partitioning

  • Kerberos (SSO)
  • Data Replication
  • Role Based Security

Storage, Infrastructure, and Networking Services

AIM utilizes years of Information Technology experience to facilitate scalability with the always growing data storage needs of an organization. In order to successfully size, scale, and maintain your enterprise storage, we also need to consider your infrastructure and network. As we scale and plan for the future, the infrastructure and network must scale with your storage. AIM can help size your current and future data storage needs and assist you in acquiring and implementing the appropriate infrastructure and networking.

In the content below, topics are divided into 3 sections:

  • Storage
  • Infrastructure
  • Networking


Storage is critical to the performance of a business intelligence solution. Not only is the hardware selection important, how our storage is configured is also very important. When planning for your storage needs, AIM can assist in gathering current storage usage amounts and related performance metrics. As a gesture of good will, AIM has provided a list of "best practices" in regards to storage and SQL Server.

NTFS Allocation Unit (AU)
Block Size = 64k, Alignment = 1024k | Default is 4k, Use /L with Format on Windows 2012 and above.

Max Degree of Parallelism
MAXDOP | Set to Number of Cores in a Single CPU Socket

DB Auto Growth
Set very high for performance. (100MB to 100s GB)

Cost Threshold for Parallelism
For OLTP where we seek to minimize Parallelism and offer more concurrency then Use 15-20.
Up to 50 with modern CPUs. For DSS, OLAP, Data Warehouse, and test environments
Consider leaving at default and Managing Parallelism with MAXDOP if concurrency is a problem.

1:2, or 1:4 Ratio (TempDB Data Files to Cores). 1:1 Ratio for large systems. Pre SQL Server 2016:
Use Trace Flags T1117 and T1118 to enable consistent AutoGrowth.
On Flash Arrays enable SORT_IN_TEMPDB Index Build option to prevent index rebuilds.

Separate Data / Log Volumes
Tier 1. Test to determine for Tier 2 Flash Arrays. Multiple Volumes per File Group to Reduce Latch Contention.
4-8 Files per File Group.
3 Volumes | TempDB, Data / Log Files, and Backups for Fast Flash (Under 1ms Response Times)

Max Server Memory
90% of Available Server Memory

Enable Instant File Initialization
Windows Server Setting: Perform Volume Maintenance Tasks needs to be Set Under Local Policies and User Rights Assignments.


We offer services to size and scale a solution's infrastructure:

Infrastructure Sizing Services
  • Dell DPack (Network and Server Statistics, IOPS, Gigs, MB/s, TB) to determine SAN requirements
  • Fast Track Data Warehouse (FTDW) to determine blade server core processor requirement
  • Blade Servers, Network Cards, SAN / DAT / NAS, Host Bus Adapter (Fiber), Switches, Fabric, Repository Servers
  • Total Server Bandwidth and Single Largest Server Bandwidth (> 400 MB/s on any 1 Server use Fiber)
  • Total Data (56.2 TB using a SAN 60-128 TB) and 16K Total IOPS (SAN 40-45K IOPS)
  • iSCSI (320 MB/s), NAS (450 MB/s), and Fiber Channel (2 GB/s)
  • Switches (1 GB Ports (60-65 MB/s) / Bundle to 4 GB (240 MB/s – 260 MB/s) and 10 GB Port (300 – 400 MB/s)
  • Memory DRAM (100 K / Writes), SLC (30 K / Reads), MLC (Not Recommended) / Storage (SSD and HDD)
  • Disaster Recovery


We offer services to stand up a network from scratch including:

Server Services
  • Windows Server
  • Active Directory
  • Domain Name System (DNS)
  • Dynamic Host Configuration Protocol (DHCP)

Domain Service
  • Company Domains
  • Intranet, Extranet, & Internet Security
  • Authentication
  • Single Sign-On

Other Networking Services
  • RAID Configuration
  • Virtual Servers
  • Virtual Private Networks (VPN)
  • Wireless Networks

Peripheral Device Services
  • Printers
  • Scanners
  • Projectors
  • Storage