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: