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

Data-Driven Financial Budget Planning (Air Force)

Data-Driven Financial Budget Planning (Air Force)

AI/ML Analytics Framework & Services (Air Force)

AI/ML Analytics Framework & Services (Air Force)

Data Pipeline for Improved Data Management (Insurance/Retail)

Data Pipeline for Improved Data Management (Insurance/Retail)

Automated Data Labeling and Curation (Army)

Automated Data Labeling and Curation (Army)

Automated Data Cleansing & Analysis Tool (Video)

Automated Data Cleansing & Analysis Tool (Video)

Accelerate Readiness with ReadyX Decision Support Tool (Video)

Accelerate Readiness with ReadyX Decision Support Tool (Video)

Geospatial Location Analysis Application (eCommerce/Retail)

Geospatial Location Analysis Application (eCommerce/Retail)

ML/AI Object Tracking Model (Army)

ML/AI Object Tracking Model (Army)

Standard Missile Maintenance Data with AI/ML (Navy)

Standard Missile Maintenance Data with AI/ML (Navy)

Automate Part Candidacy Analysis Pipeline (Army)

Automate Part Candidacy Analysis Pipeline (Army)

Automated Data Rights Understanding (Air Force)

Automated Data Rights Understanding (Air Force)

Automated Maintenance Data Capture Agent (Video)

Automated Maintenance Data Capture Agent (Video)

Automated Data Cleansing for Data-Driven Decision Making

Automated Data Cleansing for Data-Driven Decision Making

Automated Data Rights Verification (Air Force)

Automated Data Rights Verification (Air Force)

Integrated Digital Environment Discovery & Design (Air Force)

Integrated Digital Environment Discovery & Design (Air Force)

Edge Data Management & Analytics (Navy)

Edge Data Management & Analytics (Navy)

Statistical Model & Training Algorithms (Air Force)

Statistical Model & Training Algorithms (Air Force)

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

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

Data Science & Architecture Assessment (Marketing)

Data Science & Architecture Assessment (Marketing)

Micro-Model Machine Shop Simulator (Smart Factory)

Micro-Model Machine Shop Simulator (Smart Factory)

Text Analytics of PDF Technical Documents (Air Force)

Text Analytics of PDF Technical Documents (Air Force)

Deep Learning on Raw Google Analytics Data (Retail)

Deep Learning on Raw Google Analytics Data (Retail)

Paint Hangar IoT Monitoring (Innovation)

Paint Hangar IoT Monitoring (Innovation)

Pre-Flight Inspection AR Application (Innovation)

Pre-Flight Inspection AR Application (Innovation)

Expert Capture Maintenance Training Pilot (Air Force)

Expert Capture Maintenance Training Pilot (Air Force)

Automated Data Cleansing with Machine Learning (Navy)

Automated Data Cleansing with Machine Learning (Navy)

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 (Retail)

Database Tuning & Optimization (Retail)

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 (Air Force)

Azure Data Integration Hub Modernization (Air Force)

Data Warehousing & Business Intelligence

Data Warehousing & Business Intelligence

App Service Azure Infrastructure (Air Force)

App Service Azure Infrastructure (Air Force)

Big Data Engineering for Improved Analytics (Retail)

Big Data Engineering for Improved Analytics (Retail)

Agile Big Data Development (Retail)

Agile Big Data Development (Retail)

Cloud-Based Big Data Analytics (Retail)

Cloud-Based Big Data Analytics (Retail)

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 (Air Force)

Data Services Cloud Migration Support (Air Force)

Predictive Analytics for the Aircraft Digital Thread (Air Force)

Predictive Analytics for the Aircraft Digital Thread (Air Force)

On-Demand Maintenance Analytics for Logistics (Air Force)

On-Demand Maintenance Analytics for Logistics (Air Force)

User-Centric Predictive Insights with Machine Learning (Air Force)

User-Centric Predictive Insights with Machine Learning (Air Force)

Machine Learning & NLP for Decision Support (Healthcare)

Machine Learning & NLP for Decision Support (Healthcare)

Sensor Data Analysis for Predictive CBM+ (Retail)

Sensor Data Analysis for Predictive CBM+ (Retail)

Cutting-Edge Responsive Design (Financial)

Cutting-Edge Responsive Design (Financial)

Data Cleansing and Migration (Energy)

Data Cleansing and Migration (Energy)

Application Modernization (Healthcare)

Application Modernization (Healthcare)

Large-Scale Data Integration (Air Force)

Large-Scale Data Integration (Air Force)

Data Science Big Data Ingestion (Energy)

Data Science Big Data Ingestion (Energy)

Transformation to Modern Analytics Framework (Energy)

Transformation to Modern Analytics Framework (Energy)

Agile Big Data Analytics Framework (Retail)

Agile Big Data Analytics Framework (Retail)

Big Data Hadoop Administration (Retail)

Big Data Hadoop Administration (Retail)

Modern Data Ingestion Framework (Insurance)

Modern Data Ingestion Framework (Insurance)

Performance Tuning & Best Practices (Retail)

Performance Tuning & Best Practices (Retail)

Engines Forecast Reporting Tool (Air Force)

Engines Forecast Reporting Tool (Air Force)

Augmented Reality Combustion Chamber & Gear Pump Disassembly (Air Force)

Optimization Using Hadoop (Retail)

Data Quality & Lineage Mapping (Retail)

Big Data Platform Analytics Outcomes

Modern Analytic Framework

Enterprise Data Warehousing

Value-Driven Analytics

Enterprise Data Exchange

Valuable Insight into Customer Shopping Behaviors

Interested In Working With Us?