Brainstorming
Performance
Improvement

SQL 2016 Upgrade

Analyse Snapshot Locking

Neue Hardware

Query Optimizing

MTS --> .NET

GUID --> INT

Funktionsanpassungen

ACTIONS

Statisktiken

ACTIONS

ACTIONS

Funktionen SQL

ACTIONS

Anpassungen

Function

Statistiken

Kalkulation KALK

Lagerbewertung

RISK: LOW

🍾 BENEFIT: MEDIUM / HIGH

👥 EFFORT: HIGH

AWF = Count vor Ausführung

🍾 BENEFIT: HIGH

🍾 BENEFIT: MEDIUM / HIGH

🍾 BENEFIT: HIGH

🍾 BENEFIT: LOW / MEDIUM

🍾 BENEFIT: MEDIUM

🍾 BENEFIT: MEDIUM / LOW

👥 EFFORT: MEDIUM

👥 EFFORT: MEDIUM

👥 EFFORT: LOW

👥 EFFORT: HIGH

👥 EFFORT: HIGH

👥 EFFORT: HIGH

RISK: LOW

RISK: MEDIUM

RISK: HIGH

RISK: LOW

RISK: HIGH

RISK: MEDIUM

Index Improvements

ACTIONS

ACTIONS

ACTIONS

Primary Key

Index

Infrastruktur ⭐

ACTIONS✅

WLAN-Improvement/Connection

👥 EFFORT: MEDIUM

🍾 BENEFIT: LOW / MEDIUM

RISK: LOW

Check RAM

SQL Monitoring

Check Network Connection Speed (100 GB?) ❓

Check Citrix-Connections (Speedtest)

Analyse

Archivierung

ACTIONS ✅

Grosse Auftragspositionen
Achrivieren

👥 EFFORT: HIGH

🍾 BENEFIT: LOW / MEDIUM

RISK: MEDIUM

PSI-Jobs

💰 EXTERNAL COSTS: