Database Tuning & Optimization

Customer Challenge

An automotive retailer needed to improve and tune their database performance and undersized memory.

Innovative Solution

ILW doubled the memory setting for production OLTP database and report server and added more CPUs to report server to “cool off” the CPU load. Both servers were changed to optimize the type of workload, and duplicate indexes were removed for performance improvement. In addition, our engineers reallocated space to move user acceptance testing and free up additional production space. 

Benefits/Outcomes

  • Increased total memory from 59GB to 180GB
  • Reduced database contention by reducing parallel queries
  • Adjusted indexes to reduce deadlocks
  • Provided recommendations for future optimization opportunities 

Business Value

Tuning and optimizing the database enabled the retailer to significantly improve point of sale quality and speed

Toolbox

  • Point of sale customer transactions
  • On-Prem Microsoft SQL Server
  • Performance Tuning Best Practices
  • Processor CPU for analysis
  • SQL programming language

Related Case Studies You May Like

Expert Talk: Data Mesh – The Journey of Publishing Data by Domain

Expert Talk: Data Mesh – The Journey of Publishing Data by Domain

Statistical Model & Training Algorithms (Air Force)

Statistical Model & Training Algorithms (Air Force)

Expert Talk: Extracting Tabular Data from Images

Expert Talk: Extracting Tabular Data from Images

Expert Talk: Serverless Azure Functions and Kubernetes

Expert Talk: Serverless Azure Functions and Kubernetes

Expert Talk: Extracting Tabular Data from Native PDF in 5 Easy Steps

Expert Talk: Extracting Tabular Data from Native PDF in 5 Easy Steps

Webinar: Advanced Vuforia Studio

Webinar: Advanced Vuforia Studio

Webinar: Advanced Vuforia Expert Capture

Webinar: Advanced Vuforia Expert Capture

Webinar: Intro Vuforia Chalk

Webinar: Intro Vuforia Chalk

Webinar: Intro Vuforia Studio

Webinar: Intro Vuforia Studio

Webinar: Intro Vuforia Expert Capture

Webinar: Intro Vuforia Expert Capture

Webinar: Blackhawk Helicopter Preflight Inspection AR Application

Webinar: Blackhawk Helicopter Preflight Inspection AR Application

Webinar: Paint Hangar Environmental Monitoring

Webinar: Paint Hangar Environmental Monitoring

Webinar: Making the Most of Your Sensors — Smart Facilities, Factories, and Labs

Webinar: Making the Most of Your Sensors — Smart Facilities, Factories, and Labs

Data Science & Architecture Assessment (Marketing)

Data Science & Architecture Assessment (Marketing)

Micro-Model Machine Shop Simulator – Smart Factory

Micro-Model Machine Shop Simulator – Smart Factory

Automating Data Rights Understanding (Air Force)

Automating Data Rights Understanding (Air Force)

Text Analytics of PDF Technical Documents (Air Force)

Text Analytics of PDF Technical Documents (Air Force)

Expert Capture Webinars

Expert Capture Webinars

Data Engineering & Data Science (Retail)

Data Engineering & Data Science (Retail)

Paint Hangar IoT Monitoring

Paint Hangar IoT Monitoring

Pre-Flight Inspection AR Application

Pre-Flight Inspection AR Application

Expert Capture Maintenance Training Pilot

Expert Capture Maintenance Training Pilot

Automated Data Cleansing with Machine Learning (Navy, SBIR)

Automated Data Cleansing with Machine Learning (Navy, SBIR)

Automated Data Capture and Prediction (Air Force, SBIR)

Automated Data Capture and Prediction (Air Force, SBIR)

Automated Data Crosswalks (Air Force, SBIR)

Automated Data Crosswalks (Air Force, SBIR)

Contract Conversion & Analytics (Air Force)

Contract Conversion & Analytics (Air Force)

Database Tuning & Optimization

Database Tuning & Optimization

Augmented Reality Tools to Increase Workforce Productivity Across the Enterprise

Augmented Reality Tools to Increase Workforce Productivity Across the Enterprise

Decision Support for Cyber Hygiene (Air Force)

Decision Support for Cyber Hygiene (Air Force)

Augmented Reality Engineering Collaboration

Augmented Reality Engineering Collaboration

Big Data Ingestion & Cloud Architecture

Big Data Ingestion & Cloud Architecture

Cloud-Native Azure PaaS Architecture

Cloud-Native Azure PaaS Architecture

Azure Data Integration Hub Modernization

Azure Data Integration Hub Modernization

Data Warehousing & Business Intelligence

Data Warehousing & Business Intelligence

App Service Azure Infrastructure

App Service Azure Infrastructure

Big Data Engineering for Improved Analytics

Big Data Engineering for Improved Analytics

Agile Big Data Development

Agile Big Data Development

Cloud-Based Big Data Analytics

Cloud-Based Big Data Analytics

Supply Chain Predictive Analytics (Air Force)

Supply Chain Predictive Analytics (Air Force)

Cost Allocation Rules Engine Modernization (Insurance)

Cost Allocation Rules Engine Modernization (Insurance)

Data Services Cloud Migration Support

Data Services Cloud Migration Support

Predictive Analytics for the Aircraft Digital Thread

Predictive Analytics for the Aircraft Digital Thread

On-Demand Maintenance Analytics (Air Force)

On-Demand Maintenance Analytics (Air Force)

Algorithm Development & Text Analytics (Air Force)

Algorithm Development & Text Analytics (Air Force)

Machine Learning & NLP for Decision Support (Healthcare)

Machine Learning & NLP for Decision Support (Healthcare)

Sensor Data Analysis for Predictive CBM+

Sensor Data Analysis for Predictive CBM+

Cutting-Edge Responsive Design

Cutting-Edge Responsive Design

Data Cleansing and Migration

Data Cleansing and Migration

Application Modernization

Application Modernization

Large-Scale Data Integration

Large-Scale Data Integration

Data Science Big Data Ingestion (Energy)

Data Science Big Data Ingestion (Energy)

Modern Analytics Framework

Modern Analytics Framework

Agile Big Data Analytics Framework

Agile Big Data Analytics Framework

Big Data Hadoop Administration

Big Data Hadoop Administration

Modern Data Ingestion Framework

Modern Data Ingestion Framework

Performance Tuning & Best Practices

Performance Tuning & Best Practices

Engines Forecast Reporting Tool (Air Force)

Engines Forecast Reporting Tool (Air Force)

Augmented Reality Combustion Chamber & Gear Pump Disassembly

Optimization Using Hadoop

Data Quality & Lineage Mapping

Big Data Platform Analytics Outcomes

Modern Analytic Framework

Data Cleansing and Migration

Enterprise Data Warehousing

Value-Driven Analytics

Enterprise Data Exchange

Valuable Insight into Customer Shopping Behaviors

Interested In Working With Us?