Health Report - SQLPROD01

Erstellt: 2026-11-11 08:24:08
Quelle: www.powershelldba.de | sqmSQLTool v1.9.224.0
GesamtCritical
Critical55
Warning15
Info8
Laufzeit56 s
Uptime9.7 d

SQLPROD01 · Enterprise Edition: Core-based Licensing (64-bit) · 13.0.6500.1 · kumulierte Werte

● Instance● Waits● Activity● OpenTransactions● TempDb● Databases● Backups● PlanCache● Indexes● FileLatency● Deadlocks● Security● Disk

Beispielausgabe von Invoke-sqmHealthReport. Server-, Datenbank-, Host- und Login-Namen sind frei erfunden. Detailberichte: Backups · Databases · Disk · File latency · Security · TempDB · Waits. Plan Cache, Indizes, Activity und Deadlocks gibt es hier nur in der Uebersicht.

Befunde

SchwereBereichBefundDetail
CriticalBackupsBackup Tfs_MainCollectionLetztes Full/Diff vor 35.2 h (Grenze 26 h)
CriticalFileLatencytempdb temp5 (ROWS): Read 1.75 ms, Write 317.57 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp6 (ROWS): Read 1.75 ms, Write 317.51 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp7 (ROWS): Read 1.76 ms, Write 318.04 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp3 (ROWS): Read 1.75 ms, Write 317.75 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb tempdev (ROWS): Read 1.76 ms, Write 317.16 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp4 (ROWS): Read 1.75 ms, Write 316.94 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb templog (LOG): Read 0.23 ms, Write 23.56 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp2 (ROWS): Read 1.75 ms, Write 317.12 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalFileLatencytempdb temp8 (ROWS): Read 1.75 ms, Write 317.1 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
CriticalInstanceMAXDOP: 8MAXDOP zu hoch (8). Empfohlen max. 4. Empfohlen: 2..4 (abhaengig von NUMA, idealerweise 4)
CriticalOpenTransactionsSPID 231 haelt seit 22 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 178 haelt seit 51 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 190 haelt seit 22 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 235 haelt seit 22 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 118 haelt seit 75 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 202 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 196 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 215 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 209 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 237 haelt seit 22 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 245 haelt seit 11 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 225 haelt seit 11 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 247 haelt seit 11 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 226 haelt seit 11 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 123 haelt seit 11 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 104 haelt seit 21 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 238 haelt seit 22 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 66 haelt seit 18 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal, Log 0.00 MB
CriticalOpenTransactionsSPID 217 haelt seit 19 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 170 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 124 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 264 haelt seit 92 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 254 haelt seit 92 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 174 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 157 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 160 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 262 haelt seit 88 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 149 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 129 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 165 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 161 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 158 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 214 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 200 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 207 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 219 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 193 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 194 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 265 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 162 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 172 haelt seit 84 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 199 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 101 haelt seit 77 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
CriticalOpenTransactionsSPID 110 haelt seit 107 Minuten eine Transaktion offen (sleeping)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
WarningActivity4 blockierte Session(s)Blockierende SPID(s): 129, 158, 165, 174. Details: Get-sqmBlockingReport.
WarningDiskLaufwerk F:\: 14.7 % freiWarnung: nur 14.7% frei (293.2 GB).
WarningFileLatencyIdentityMgmt IdentityMgmt (ROWS): Read 27.2 ms, Write 1.39 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
WarningFileLatencyTimeReporting TimeReporting_log (LOG): Read 2.78 ms, Write 9.18 msLaufwerk F:, kumuliert seit 11/01/2026 15:04:50
WarningIndexes10 fehlende(r) Index(e) mit Impact-Score >= 1000ProjectSuite_PROD.TB_VOUCHER_BATCH (3195847.12); ExternalScores.spScoreData (717785.54); TradingCore_PROD.Holiday (405555.52); EndUserApps.App_ProjectVersion (52537.77); EndUserApps.App_ProjectVersion (52317.33)
WarningIndexes5343 Index-Befund(e) 'Unused' (80951.6 MB)Details und auskommentiertes DROP-Skript im Detailbericht.
WarningInstanceCLR (Common Language Runtime): EnabledCLR ist aktiviert - Nutzen Sie diese Funktion? Empfohlen: Disabled (unless required for stored procedures)
WarningOpenTransactionsSPID 113 haelt seit 22 Minuten eine Transaktion offen (running)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
WarningOpenTransactionsSPID 180 haelt seit 11 Minuten eine Transaktion offen (running)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
WarningOpenTransactionsSPID 234 haelt seit 22 Minuten eine Transaktion offen (running)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
WarningOpenTransactionsSPID 189 haelt seit 50 Minuten eine Transaktion offen (running)app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB
WarningPlanCacheSpill in 1 der teuersten StatementsEndUserApps (ad hoc) [Reads#9]
WarningPlanCacheImplicitConversion in 12 der teuersten StatementsEndUserApps (ad hoc) [CPU#1, Duration#1, Reads#4]; ProjectSuite_PROD (ad hoc) [CPU#2, Duration#2, Reads#1]; EndUserApps (ad hoc) [CPU#3, Duration#4]; master (ad hoc) [CPU#4, Duration#5]; ExternalScores (ad hoc) [CPU#5, Duration#3, Reads#8]
WarningTempDbTempDB-Konfiguration: WarningAnzahl TempDB-Dateien: 8 (empfohlen 4). Alle TempDB-Dateien liegen auf demselben Laufwerk (F) - fuer optimale Leistung separate Laufwerke empfehlenswert.
WarningWaitsLCK_M_S: 35 % der Wartezeit (Locking)Shared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI).
InfoActivity36 Request(s) laufen laenger als 10 MinutenSPID 110 (6439 s), SPID 254 (5443 s), SPID 262 (5262 s), SPID 129 (5068 s), SPID 158 (5068 s), SPID 149 (5067 s), SPID 157 (5057 s), SPID 165 (4709 s), SPID 193 (4604 s), SPID 170 (4535 s), SPID 124 (4483 s), SPID 219 (4342 s), SPID 265 (4282 s), SPID 172 (4246 s), SPID 101 (4238 s), SPID 161 (4093 s), SPID 202 (3881 s), SPID 209 (3648 s), SPID 162 (3599 s), SPID 264 (3419 s), SPID 196 (3358 s), SPID 207 (2874 s), SPID 214 (2632 s), SPID 160 (2575 s), SPID 199 (2561 s), SPID 174 (1911 s), SPID 178 (1791 s), SPID 215 (1309 s), SPID 231 (1309 s), SPID 190 (1307 s), SPID 217 (1161 s), SPID 66 (1050 s), SPID 238 (957 s), SPID 225 (651 s), SPID 247 (647 s), SPID 194 (602 s)
InfoDeadlocks7 Deadlock(s) in 15 TagenHaeufigste Opfer-Programme: Microsoft JDBC Driver for SQL Server (3), Microsoft SQL Server JDBC Driver (3), Microsoft SQL Server Management Studio (1)
InfoIndexes425 Index-Befund(e) 'Heap' (81398.3 MB)Details und auskommentiertes DROP-Skript im Detailbericht.
InfoIndexes157 Index-Befund(e) 'Overlapping' (2376.7 MB)Details und auskommentiertes DROP-Skript im Detailbericht.
InfoIndexes43 Index-Befund(e) 'Duplicate' (174.1 MB)Details und auskommentiertes DROP-Skript im Detailbericht.
InfoPlanCacheEin Statement verursacht 25.21 % der CPU im CacheEndUserApps (ad hoc): SELECT [GroupBy1].[A1] AS [C1] FROM ( SELECT COUNT(1) AS [A1] FROM [dbo].[IDV_ProjectVersi ...
InfoPlanCacheMissingIndex in 3 der teuersten StatementsProjectSuite_PROD (ad hoc) [CPU#2, Duration#2, Reads#1]; TradingCore_PROD (ad hoc) [CPU#6, Duration#8, Reads#10]; ExternalScores (ad hoc) [CPU#7, Duration#6, Reads#6]
InfoSecurity8 Konto/Konten mit sysadminVollstaendiges Login-Audit: Invoke-sqmLoginAudit.

Instance Critical · 0.8 s

ServerVersionEditionUptimeCPUsRAM MBSQL committed MBAlwaysOnClusterUser DBs
SQLPROD0113.0.6500.1 SP3Enterprise Edition: Core-based Licensing (64-bit)9.7 Tage (seit 2026-11-01 15:04)4131070117201FalseFalse56
CheckCurrentValueRecommendedStatusMessage
MAXDOP82..4 (abhaengig von NUMA, idealerweise 4)FailedMAXDOP zu hoch (8). Empfohlen max. 4.
Max Server Memory122880 MB117964 MB (90% von 131071 MB RAM)OKMax Server Memory OK (122880 MB). Toleranz: 111410 - 124517 MB
Cost Threshold for Parallelism50>= 50OKOK.
xp_cmdshellDisabledDisabled (es sei denn, benoetigt)OKDeaktiviert - OK.
SA AccountName: sa, Aktiviert: FalseUmbenannt und/oder deaktiviertOKSA-Konto heisst noch 'sa' (aber deaktiviert).
Sysadmin Accounts0 Konto(n): NoneSollte auf wenige Accounts begrenzt werden (idealerweise Windows-Gruppen)OKAngemessene Anzahl von Sysadmin-Accounts.
CLR (Common Language Runtime)EnabledDisabled (unless required for stored procedures)WarningCLR ist aktiviert - Nutzen Sie diese Funktion?
SQL XPs und Erweiterte KonfigurationenKeine XP konfiguriertNur aktiviert wenn notwendig (Sicherheitsrisiko)InfoUeberpruefe regelmassig ob diese XPs noch benoetigt werden.
TempDB Configuration8 Datenbankdateien, gleiche Groesse: True4 Dateien (entsprechend Anzahl Kerne, max 8), alle gleiche Groesse, separate LaufwerkeOKOK.
SQL Server Version13.0.6500.1Aktuelle Version + neuestes Service Pack / CUOKOK.
Instance CollationSQL_Latin1_General_CP1_CI_ASUnternehmensstandard sicherstellen (z.B. Latin1_General_CI_AS)InfoInstanz-Collation: SQL_Latin1_General_CP1_CI_AS

Waits Warning · 0.1 s

Top 10 Waits, kumuliert seit Start.

WaitTypeCategoryWaitTimePctAvgWaitMsSignalWaitPctRecommendation
LCK_M_SLocking3512995.610Shared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI).
SOS_SCHEDULER_YIELDCPU15.20.8699.9Inconspicuous: signal wait share of the instance is 19,1 %, below the 25 % threshold - no CPU pressure.
ASYNC_IO_COMPLETIONI/O7.219974.270Async I/O delay - Backup/Restore/DBCC running on slow storage.
BACKUPBUFFEROther7.21.9013.1
ASYNC_NETWORK_IONetwork72.551.9Inconspicuous: average wait 2,55 ms is below the 10 ms threshold - no action required.
CXPACKETParallelism6.12.356.4Parallelism waits - tune MAXDOP and Cost Threshold for Parallelism.
BACKUPIOOther5.21.206.7
CXCONSUMERParallelism4.82.1714.8Inconspicuous: only 4,8 % of the relevant wait time (threshold 5 %) - no action required.
BACKUPTHREADOther3.3272.180.1
WRITELOGI/O3.20.8919.3Inconspicuous: average wait 0,89 ms is below the 5 ms threshold - no action required.

Activity Warning · 2.7 s

SessionIdBlockingSessionIdLoginNameDatabaseNameStatusWaitTypeElapsedSecondsCpuTimeMsTempdbAllocMBSqlText
1100app_portalOrderPortal-DMZsleeping64391410518.19(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
2540app_portalOrderPortal-DMZsleeping54431321410.06(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
2620app_portalOrderPortal-DMZsleeping52621420318.75(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1580app_portalOrderPortal-DMZsleeping506800.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1290app_portalOrderPortal-DMZsleeping506800.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1490app_portalOrderPortal-DMZsleeping506700.00(@P0 varchar(8000),@P1 bigint)select KVA_TIMEINDEX, KVA_OCCURANCE, KVA_LONGVALUE, KVA_DOUBLE_VALUE from APP_KPI_VALUE where KVA_INSTANCEID = @P0 and KVA_TIMEINDEX > @P1 order by KVA_TIMEINDEX desc
1570app_portalOrderPortal-DMZsleeping505700.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1650app_portalOrderPortal-DMZsleeping470900.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1930app_portalOrderPortal-DMZsleeping4604150.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
1700app_portalOrderPortal-DMZsleeping453500.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0

... 42 weitere Zeile(n) im Detailbericht.

OpenTransactions Critical · 2.5 s

Benutzertransaktionen, die seit mindestens 1 Minute(n) offen sind. 'sleeping' mit offener Transaktion heisst meist: die Anwendung hat COMMIT vergessen.

SessionIdLoginNameHostNameProgramNameDatabaseNameBeginTimeOpenSecondsSessionStatusLogUsedMBLastSqlText
110app_portaldmzhost02Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:356441sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
254app_portaldmzhost02Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:515505sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
264app_portaldmzhost02Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:515504sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
262app_portaldmzhost02Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:555264sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
129app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585070sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
149app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585070sleeping0.00(@P0 varchar(8000),@P1 bigint)select KVA_TIMEINDEX, KVA_OCCURANCE, KVA_LONGVALUE, KVA_DOUBLE_VALUE from APP_KPI_VALUE where KVA_INSTANCEID = @P0 and KVA_TIMEINDEX > @P1 order by KVA_TIMEINDEX desc
158app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585070sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
161app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585070sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
165app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585070sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0
160app_portaldmzhost01Microsoft JDBC Driver for SQL ServerOrderPortal-DMZ2026-11-11 06:585067sleeping0.00(@P0 varchar(8000))select USR_STATE,USR_LOGON_TRIES,USR_LAST_LOGIN,UST_USER_ID from APP_SEC_USER_STATE where UST_USER_ID = @P0

... 40 weitere Zeile(n) im Detailbericht.

TempDb Warning · 0.4 s

StatusFileCountRecommendedCountFileSizesMBGrowthMBRecommendations
Warning844352, 4352, 4352, 4352, 4352, 4352, 4352, 4352256, 256, 256, 256, 256, 256, 256, 256Anzahl TempDB-Dateien: 8 (empfohlen 4). Alle TempDB-Dateien liegen auf demselben Laufwerk (F) - fuer optimale Leistung separate Laufwerke empfehlenswert.

Groesste TempDB-Verbraucher (aktuelle Sessions)

Keine Eintraege.

Databases OK · 3.7 s

DatabaseOverallStatusRecoveryModelSizeMBLastCheckDbCheckDbStatusLastFullBackupLastLogBackupVlfCountVlfStatus
BillingTool_RetailOKSimple14.82026-11-08OK2026-11-10 20:30n/a4OK
RoleProfilesOKSimple106.82026-11-08OK2026-11-10 20:30n/a5OK
AppInventoryOKSimple1119.82026-11-08OK2026-11-10 20:30n/a3OK
OrderPortalOKSimple30082026-11-08OK2026-11-10 20:30n/a4OK
OrderPortal-DMZOKSimple96642026-11-08OK2026-11-10 20:30n/a4OK
Contoso_CMSOKSimple135882026-11-08OK2026-11-10 20:31n/a9OK
Contoso_WikiOKSimple498882026-11-08OK2026-11-10 20:31n/a2OK
ProjectSuite_PRODOKSimple1320012026-11-08OK2026-11-10 20:35n/a16OK
BIReporting01OKSimple249.42026-11-08OK2026-11-10 20:36n/a10OK
TradingCore_PRODOKSimple7020.72026-11-08OK2026-11-10 20:37n/a2OK
DocArchive01OKSimple2641.12026-11-08OK2026-11-10 20:37n/a15OK
SandboxTest01OKSimple1922026-11-08OK2026-11-10 20:37n/a4OK
DeadlockCollectorOKSimple1119.82026-11-08OK2026-11-10 20:37n/a3OK
ExternalScoresOKSimple5247.92026-11-08OK2026-11-10 20:37n/a2OK
Ops_MonitoringOKSimple19.82026-11-08OK2026-11-10 20:37n/a3OK
PrintServicesOKSimple4790.12026-11-08OK2026-11-10 20:37n/a4OK
HwInventoryOKSimple1151.92026-11-08OK2026-11-10 20:37n/a2OK
IdeaData1OKSimple175.82026-11-08OK2026-11-10 20:37n/a7OK
IdentityMgmtOKSimple18047.82026-11-08OK2026-11-10 20:38n/a2OK
EndUserAppsOKSimple3076312026-11-08OK2026-11-10 20:59n/a6OK
EndUserApps_oldOKSimple3084952026-11-01OK2026-11-10 21:37n/a60OK
PortalEU_PRODOKSimple3744.12026-11-08OK2026-11-10 21:47n/a5OK
PortalConfigDBOKSimple6461.52026-11-08OK2026-11-10 21:47n/a8OK
IssueTrackerOKSimple20607.92026-11-08OK2026-11-10 21:48n/a2OK
BudgetPlannerOKSimple1151.92026-11-08OK2026-11-10 21:48n/a2OK

... 31 weitere Zeile(n) im Detailbericht.

Backups Critical · 0.2 s

Letzter Backup-Lauf: 2026-11-10 21:56 | Ausgeschlossen (sqm_BackupExclude): 0

DatabaseStatusRecoveryModelCreateDateLastFullBackupLastLogBackupNotes
Tfs_MainCollectionCriticalSIMPLE2020-11-19 20:362026-11-09 21:13Letztes Full/Diff vor 35.2 h (Grenze 26 h)

PlanCache Warning · 1.2 s

RanksDatabaseNameObjectNameExecutionsTotalCpuMsCpuPercentAvgDurationMsAvgReadsFindingsStatementText
CPU#1, Duration#1, Reads#4EndUserApps(ad hoc)280962457008125.211035.9519304ImplicitConversion, KeyLookupSELECT [GroupBy1].[A1] AS [C1] FROM ( SELECT COUNT(1) AS [A1] FROM [dbo].[App_Documents] AS [Extent1] WHERE (((LOWER([Extent1].[GUID])) = (LOWER(@p__linq__0))) OR ((LOWER([Extent1].[GUID]) IS NULL) AND (LOWER(@p__linq__0) IS NULL))) AND ( ...
CPU#2, Duration#2, Reads#1ProjectSuite_PROD(ad hoc)13293702033094320.8616.133122ImplicitConversion, MissingIndexSELECT COUNT(*) FROM TB_VOUCHER_BATCH v1 WHERE (v1.BATCH_NUMBER=@P0)
CPU#3, Duration#4EndUserApps(ad hoc)971284710228.691025.0519747ImplicitConversion, KeyLookupSELECT TOP (1) [Project1].[ID] AS [ID], [Project1].[GUID] AS [GUID], [Project1].[HostName] AS [HostName], [Project1].[FileName] AS [FileName], [Project1].[OwnerUnit] AS [OwnerUnit], [Project1].[RunDate ...
CPU#4, Duration#5master(ad hoc)93469177227.18247.18125ImplicitConversionSELECT DB_NAME(db.database_id) AS [DatabaseName], ISNULL(info.NConnections, 0) AS [NConnections] FROM sys.databases AS db LEFT JOIN ( SELECT database_id, COUNT(database_id) AS [NConnections] FROM sys.dm_exec_connections AS c INNER JOIN sys.dm_exec_sessions AS s ON c.session_id ...
CPU#5, Duration#3, Reads#8ExternalScores(ad hoc)12393942584724.37110.832240ImplicitConversionselect dataValue from dbo.spScoreLevelData where entityKey= @P0 and scoreItemId=1
CPU#6, Duration#8, Reads#10TradingCore_PROD(ad hoc)26309934248273.5114.34859MissingIndexSELECT [c0].[CalendarId], [c0].[Key], [c0].[LastDate], [h].[Id], [h].[CalendarId], [h].[Comment], [h].[Date], [h].[DayOfWeek], [h].[FromYear], [h].[Rule] FROM ( SELECT TOP(2) [c].[CalendarId], [c].[Key], [c].[LastDate] FROM [cx].[Calendars] AS [c] ...
CPU#7, Duration#6, Reads#6ExternalScores(ad hoc)7743020009222.0578.233898ImplicitConversion, MissingIndexselect sd.scoreKey,sd.scoreDetailId,st.scoreTypeId,sd.scoreDate,sd.qualifier,sd.trend,sd.trendDate,sd.typeCode,st.scoreTypeCode,case when st.longFlag=1 and st.shortFlag=0 then 'LONG' when st.longFlag=0 and st.shortFlag=1 then 'SHORT' el ...
CPU#8, Reads#2ProjectSuite_PROD(ad hoc)46059817448721.793.843393ImplicitConversion, KeyLookupSELECT a.ATTRIBUTE_DEFINITION, a.ID, a.VALUE_STRING, a.VALUE_DATE_TIME, a.VALUE_LONG, a.VALUE_DOUBLE, a.VALUE_CLOB, a.PROJECT_ID, a.TASK_ID, a.TICKET_ID, a.PERSON_ID, a.DEPARTMENT_ID, a.INVOICE_ID, a.RISK_ID ...
CPU#9, Duration#10TradingCore_PROD(ad hoc)10010590611.0927322.55227539SELECT [FlowId], [AmountOverwrite], [Barrier], [BarrierKind], [BaseAmount], [CapOrFloor], [Currency], [End], [ExchangedAmount], [FixingRate], [FixingDate], [Index], [InvertBuy], [InvertStrike], [KnockInStrike], [KnockOutStrike] ...
CPU#10ProjectSuite_PROD(ad hoc)713476269408240.970.030SELECT NEXT VALUE FOR SQ_PK
Duration#7TradingCore_PROD(ad hoc)4717711030.798745.9333636SELECT [LegId], [CapOrFloor], [Currency], [DayCountMethod], [DiscountCurveName], [End], [EndStubNextIndex], [EndStubPreviousIndex], [FirstCouponEffectiveDate], [FixedRate], [ForwardCurveName], [FxCurveName] ...
Duration#9EndUserApps(ad hoc)213516288390.65171.461087ImplicitConversionSELECT * FROM [App].[Report_AccessAndRoles] WHERE [LastDeliveryDate]=@1
Reads#5EndUserApps(ad hoc)936177290.637502.193566472ImplicitConversion, KeyLookupSELECT [t0].[TaskId], [t0].[TaskClassificationId], [t0].[TaskStatus], [t0].[TaskOrgUnit], [t0].[TaskRoleId], [t0].[TaskDueAt], [t0].[TaskSchemeId], [t0].[TaskDescription], [t0].[IsProcessedByNotification], [t0].[CreatedAt], [t ...
Reads#7ProjectSuite_PROD(ad hoc)142118155300830.540.0420ImplicitConversioninsert into TB_MIRROR_FCAST_STAFF_0 (MIRROR_STAFF_ID,MIRROR_DATE,STAFF_ID,VIRTUAL_HEAD_ID,DEPARTMENT_ID,AVAILABILITY,REST_AVAILABILITY,PARTICIPATION_RES_DURATION,PARTICIPATION_PLAN_IN_DURATION,COST_INTERNAL_AVAIL,COST_INTERNAL_RES,C ...
Reads#9EndUserApps(ad hoc)2024878290.53256.511266335ImplicitConversion, KeyLookup, SpillSELECT * FROM App.PendingWorkflows_LV WHERE IsProcessedByNotification = 0

... 1 weitere Zeile(n) im Detailbericht.

Indexes Warning · 29.4 s

FindingCountSizeMB
Heap42581398.3
Unused534380951.6
Overlapping1572376.7
Duplicate43174.1

Groesste Befunde

FindingDatabaseNameTableNameIndexNameSizeMBReadsWritesDetail
HeapProjectSuite_PRODTMP_RESULT_CACHE(heap)63135.3400Tabelle ohne Clustered Index, 1 Nonclustered-Index(e).
UnusedProjectSuite_PRODTMP_RESULT_CACHEI_TMP_RESULT_CACHE49795.8800Kein Lesezugriff seit Neustart (9.7 Tage), 0 Schreibvorgaenge.
HeapPatchMgmtvuln_plugin(heap)2535.8700Tabelle ohne Clustered Index, 0 Nonclustered-Index(e).
HeapOrderPortalAPP_DBS_PAGE(heap)1920.272331228528Tabelle ohne Clustered Index, 1 Nonclustered-Index(e).
HeapIdentityMgmtTempDirectMemberships(heap)1896.5200Tabelle ohne Clustered Index, 1 Nonclustered-Index(e).
HeapTimeReportingWorklog_STAGING(heap)1895.1330178Tabelle ohne Clustered Index, 0 Nonclustered-Index(e).
UnusedEndUserApps_oldApp_ProjectUserProjectUser$Filename_IX181200Kein Lesezugriff seit Neustart (9.7 Tage), 0 Schreibvorgaenge.
HeapOrderPortal-DMZAPP_DBS_PAGE(heap)1516.2773259118769Tabelle ohne Clustered Index, 1 Nonclustered-Index(e).
HeapwebcorewebPerformanceInfo(heap)1115.1200Tabelle ohne Clustered Index, 4 Nonclustered-Index(e).
HeapPatchMgmtcache_imports(heap)1059.700Tabelle ohne Clustered Index, 0 Nonclustered-Index(e).

... 5958 weitere Zeile(n) im Detailbericht.

Fehlende Indizes (DMV-Empfehlungen)

DatabaseNameTableNameImpactScoreUserSeeksEqualityColumnsInequalityColumnsIncludedColumns
ProjectSuite_PRODTB_VOUCHER_BATCH3195847.121329370[BATCH_NUMBER]
ExternalScoresspScoreData717785.54224883[objectTypeId], [scoreTypeCode][scoreDetailId], [entityKey], [instrumentKey], [issuerKey], [typeCode], [scoreKey], [scoreDate], [trend], [trendDate], [qualifier]
TradingCore_PRODHoliday405555.52327278[CalendarId][Id], [Date], [DayOfWeek], [DayMonth_Day], [DayMonth_Month], [FromYear], [Rule], [Comment]
EndUserAppsApp_ProjectVersion52537.77621[Stage], [DeploymentId][IsRoot][FileDate]
EndUserAppsApp_ProjectVersion52317.33621[Stage], [DeploymentId][FileDate]
ProjectSuite_PRODTB_DEPT_MEMBER44355.04343156[STAFF_ID]
TimeReportingStaffList40771.42690[IsExternal][uid]
EndUserAppsApp_WorkflowValue_BR29326.4516364[ClassificationId]
EndUserAppsApp_ProjectVersion20614.12238[Stage], [DeploymentId][IsRoot][ID], [GUID], [HostName], [FileName], [OwnerUnit], [RunUser], [RunDate], [FileDate], [FileSize], [FileType], [Connections], [Sheets], [Charts], [Formulas], [PivotTables], [Controls] ...
EndUserAppsApp_ProjectVersion20523.42238[Stage], [DeploymentId][ID], [GUID], [HostName], [FileName], [OwnerUnit], [RunUser], [RunDate], [FileDate], [FileSize], [FileType], [Connections], [Sheets], [Charts], [Formulas], [PivotTables], [Controls] ...

FileLatency Critical · 0.2 s

DatabaseNameLogicalNameFileTypeDriveReadsAvgReadMsWritesAvgWriteMsRating
tempdbtemp7ROWSF:1996621.76204473318.04Critical
tempdbtemp3ROWSF:1996951.75204669317.75Critical
tempdbtemp5ROWSF:2000311.75204749317.57Critical
tempdbtemp6ROWSF:1998781.75204847317.51Critical
tempdbtempdevROWSF:2000121.76205068317.16Critical
tempdbtemp2ROWSF:1999171.75205087317.12Critical
tempdbtemp8ROWSF:1999231.75205113317.1Critical
tempdbtemp4ROWSF:1999321.75205181316.94Critical
tempdbtemplogLOGF:780.2311386023.56Critical
IdentityMgmtIdentityMgmtROWSF:47292627.26371.39Warning

... 117 weitere Zeile(n) im Detailbericht.

Deadlocks OK · 14.3 s

Deadlocks der letzten 15 Tage (system_health, Ring Buffer + .xel). Die Graphen liegen als .xdl in Details\Deadlocks.

TimestampVictimLoginVictimHostVictimProgramProcessCountVictimStatement
2026-11-10 14:45MarketResearchAdminapphost01Microsoft SQL Server JDBC Driver2(@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1)
2026-11-09 19:55CONTOSO\jdoeSQLPROD01Microsoft SQL Server Management Studio2(@_msparam_0 nvarchar(4000)) create table #tmp_db_hadr_dbrs (group_database_id uniqueidentifier, synchronization_state tinyint, is_local bit) declare @HasViewPermission int select @HasViewPermission = HAS_PERMS_BY_NAME(null, null, 'VIEW SERVER STATE') if (@HasViewPermission = 1) begin insert into #t ...
2026-11-04 09:00MarketResearchAdminapphost01Microsoft SQL Server JDBC Driver2(@P0 nvarchar(4000),@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 decimal(38,0),@P4 decimal(38,0),@P5 nvarchar(4000),@P6 nvarchar(4000),@P7 decimal(38,0),@P8 decimal(38,0),@P9 nvarchar(4000),@P10 int,@P11 int,@P12 nvarchar(4000),@P13 nvarchar(4000))UPDATE QRTZ_TRIGGERS SET JOB_NAME = @P0, JOB_GROUP = @P ...
2026-11-02 10:00MarketResearchAdminapphost02Microsoft JDBC Driver for SQL Server2(@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1)
2026-10-29 10:30MarketResearchAdminapphost02Microsoft JDBC Driver for SQL Server2(@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1)
2026-10-28 10:15MarketResearchAdminapphost01Microsoft SQL Server JDBC Driver2(@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1)
2026-10-27 11:45MarketResearchAdminapphost02Microsoft JDBC Driver for SQL Server2(@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1)

Security OK · 0.3 s

LoginNameLoginTypeIsEnabledIsSaLastLoginStatusMessage
CONTOSO\SQL_ServerAdmins_FullWINDOWS_GROUPTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
CONTOSO\SQL_DBA_TeamWINDOWS_GROUPTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
CONTOSO\svc_sqlcollectWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
NT AUTHORITY\SYSTEMWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
NT SERVICE\MSSQLSERVERWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
NT SERVICE\SQLSERVERAGENTWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
NT SERVICE\SQLWriterWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.
NT SERVICE\WinmgmtWINDOWS_LOGINTrueFalseUnexpectedSysadmin-Login - kein Ausschluss definiert.

Disk Warning · 0.5 s

MountPointVolumeNameTotalGBFreeGBFreePctDaysUntilFullStatusMessage
F:\SQLData2000.0293.214.7WarningWarnung: nur 14.7% frei (293.2 GB).