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.
| Schwere | Bereich | Befund | Detail |
|---|---|---|---|
| Critical | Backups | Backup Tfs_MainCollection | Letztes Full/Diff vor 35.2 h (Grenze 26 h) |
| Critical | FileLatency | tempdb temp5 (ROWS): Read 1.75 ms, Write 317.57 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp6 (ROWS): Read 1.75 ms, Write 317.51 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp7 (ROWS): Read 1.76 ms, Write 318.04 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp3 (ROWS): Read 1.75 ms, Write 317.75 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb tempdev (ROWS): Read 1.76 ms, Write 317.16 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp4 (ROWS): Read 1.75 ms, Write 316.94 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb templog (LOG): Read 0.23 ms, Write 23.56 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp2 (ROWS): Read 1.75 ms, Write 317.12 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | FileLatency | tempdb temp8 (ROWS): Read 1.75 ms, Write 317.1 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Critical | Instance | MAXDOP: 8 | MAXDOP zu hoch (8). Empfohlen max. 4. Empfohlen: 2..4 (abhaengig von NUMA, idealerweise 4) |
| Critical | OpenTransactions | SPID 231 haelt seit 22 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 178 haelt seit 51 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 190 haelt seit 22 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 235 haelt seit 22 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 118 haelt seit 75 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 202 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 196 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 215 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 209 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 237 haelt seit 22 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 245 haelt seit 11 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 225 haelt seit 11 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 247 haelt seit 11 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 226 haelt seit 11 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 123 haelt seit 11 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 104 haelt seit 21 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 238 haelt seit 22 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 66 haelt seit 18 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal, Log 0.00 MB |
| Critical | OpenTransactions | SPID 217 haelt seit 19 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 170 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 124 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 264 haelt seit 92 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 254 haelt seit 92 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 174 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 157 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 160 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 262 haelt seit 88 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 149 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 129 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 165 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 161 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 158 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 214 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 200 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 207 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 219 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 193 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 194 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 265 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 162 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 172 haelt seit 84 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 199 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 101 haelt seit 77 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Critical | OpenTransactions | SPID 110 haelt seit 107 Minuten eine Transaktion offen (sleeping) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Warning | Activity | 4 blockierte Session(s) | Blockierende SPID(s): 129, 158, 165, 174. Details: Get-sqmBlockingReport. |
| Warning | Disk | Laufwerk F:\: 14.7 % frei | Warnung: nur 14.7% frei (293.2 GB). |
| Warning | FileLatency | IdentityMgmt IdentityMgmt (ROWS): Read 27.2 ms, Write 1.39 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Warning | FileLatency | TimeReporting TimeReporting_log (LOG): Read 2.78 ms, Write 9.18 ms | Laufwerk F:, kumuliert seit 11/01/2026 15:04:50 |
| Warning | Indexes | 10 fehlende(r) Index(e) mit Impact-Score >= 1000 | ProjectSuite_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) |
| Warning | Indexes | 5343 Index-Befund(e) 'Unused' (80951.6 MB) | Details und auskommentiertes DROP-Skript im Detailbericht. |
| Warning | Instance | CLR (Common Language Runtime): Enabled | CLR ist aktiviert - Nutzen Sie diese Funktion? Empfohlen: Disabled (unless required for stored procedures) |
| Warning | OpenTransactions | SPID 113 haelt seit 22 Minuten eine Transaktion offen (running) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Warning | OpenTransactions | SPID 180 haelt seit 11 Minuten eine Transaktion offen (running) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Warning | OpenTransactions | SPID 234 haelt seit 22 Minuten eine Transaktion offen (running) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Warning | OpenTransactions | SPID 189 haelt seit 50 Minuten eine Transaktion offen (running) | app_portal / Microsoft JDBC Driver for SQL Server / OrderPortal-DMZ, Log 0.00 MB |
| Warning | PlanCache | Spill in 1 der teuersten Statements | EndUserApps (ad hoc) [Reads#9] |
| Warning | PlanCache | ImplicitConversion in 12 der teuersten Statements | EndUserApps (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] |
| Warning | TempDb | TempDB-Konfiguration: Warning | Anzahl TempDB-Dateien: 8 (empfohlen 4). Alle TempDB-Dateien liegen auf demselben Laufwerk (F) - fuer optimale Leistung separate Laufwerke empfehlenswert. |
| Warning | Waits | LCK_M_S: 35 % der Wartezeit (Locking) | Shared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI). |
| Info | Activity | 36 Request(s) laufen laenger als 10 Minuten | SPID 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) |
| Info | Deadlocks | 7 Deadlock(s) in 15 Tagen | Haeufigste Opfer-Programme: Microsoft JDBC Driver for SQL Server (3), Microsoft SQL Server JDBC Driver (3), Microsoft SQL Server Management Studio (1) |
| Info | Indexes | 425 Index-Befund(e) 'Heap' (81398.3 MB) | Details und auskommentiertes DROP-Skript im Detailbericht. |
| Info | Indexes | 157 Index-Befund(e) 'Overlapping' (2376.7 MB) | Details und auskommentiertes DROP-Skript im Detailbericht. |
| Info | Indexes | 43 Index-Befund(e) 'Duplicate' (174.1 MB) | Details und auskommentiertes DROP-Skript im Detailbericht. |
| Info | PlanCache | Ein Statement verursacht 25.21 % der CPU im Cache | EndUserApps (ad hoc): SELECT [GroupBy1].[A1] AS [C1] FROM ( SELECT COUNT(1) AS [A1] FROM [dbo].[IDV_ProjectVersi ... |
| Info | PlanCache | MissingIndex in 3 der teuersten Statements | ProjectSuite_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] |
| Info | Security | 8 Konto/Konten mit sysadmin | Vollstaendiges Login-Audit: Invoke-sqmLoginAudit. |
| Server | Version | Edition | Uptime | CPUs | RAM MB | SQL committed MB | AlwaysOn | Cluster | User DBs |
|---|---|---|---|---|---|---|---|---|---|
| SQLPROD01 | 13.0.6500.1 SP3 | Enterprise Edition: Core-based Licensing (64-bit) | 9.7 Tage (seit 2026-11-01 15:04) | 4 | 131070 | 117201 | False | False | 56 |
| Check | CurrentValue | Recommended | Status | Message |
|---|---|---|---|---|
| MAXDOP | 8 | 2..4 (abhaengig von NUMA, idealerweise 4) | Failed | MAXDOP zu hoch (8). Empfohlen max. 4. |
| Max Server Memory | 122880 MB | 117964 MB (90% von 131071 MB RAM) | OK | Max Server Memory OK (122880 MB). Toleranz: 111410 - 124517 MB |
| Cost Threshold for Parallelism | 50 | >= 50 | OK | OK. |
| xp_cmdshell | Disabled | Disabled (es sei denn, benoetigt) | OK | Deaktiviert - OK. |
| SA Account | Name: sa, Aktiviert: False | Umbenannt und/oder deaktiviert | OK | SA-Konto heisst noch 'sa' (aber deaktiviert). |
| Sysadmin Accounts | 0 Konto(n): None | Sollte auf wenige Accounts begrenzt werden (idealerweise Windows-Gruppen) | OK | Angemessene Anzahl von Sysadmin-Accounts. |
| CLR (Common Language Runtime) | Enabled | Disabled (unless required for stored procedures) | Warning | CLR ist aktiviert - Nutzen Sie diese Funktion? |
| SQL XPs und Erweiterte Konfigurationen | Keine XP konfiguriert | Nur aktiviert wenn notwendig (Sicherheitsrisiko) | Info | Ueberpruefe regelmassig ob diese XPs noch benoetigt werden. |
| TempDB Configuration | 8 Datenbankdateien, gleiche Groesse: True | 4 Dateien (entsprechend Anzahl Kerne, max 8), alle gleiche Groesse, separate Laufwerke | OK | OK. |
| SQL Server Version | 13.0.6500.1 | Aktuelle Version + neuestes Service Pack / CU | OK | OK. |
| Instance Collation | SQL_Latin1_General_CP1_CI_AS | Unternehmensstandard sicherstellen (z.B. Latin1_General_CI_AS) | Info | Instanz-Collation: SQL_Latin1_General_CP1_CI_AS |
Top 10 Waits, kumuliert seit Start.
| WaitType | Category | WaitTimePct | AvgWaitMs | SignalWaitPct | Recommendation |
|---|---|---|---|---|---|
| LCK_M_S | Locking | 35 | 12995.61 | 0 | Shared lock waits - consider enabling Read Committed Snapshot Isolation (RCSI). |
| SOS_SCHEDULER_YIELD | CPU | 15.2 | 0.86 | 99.9 | Inconspicuous: signal wait share of the instance is 19,1 %, below the 25 % threshold - no CPU pressure. |
| ASYNC_IO_COMPLETION | I/O | 7.2 | 19974.27 | 0 | Async I/O delay - Backup/Restore/DBCC running on slow storage. |
| BACKUPBUFFER | Other | 7.2 | 1.90 | 13.1 | |
| ASYNC_NETWORK_IO | Network | 7 | 2.55 | 1.9 | Inconspicuous: average wait 2,55 ms is below the 10 ms threshold - no action required. |
| CXPACKET | Parallelism | 6.1 | 2.35 | 6.4 | Parallelism waits - tune MAXDOP and Cost Threshold for Parallelism. |
| BACKUPIO | Other | 5.2 | 1.20 | 6.7 | |
| CXCONSUMER | Parallelism | 4.8 | 2.17 | 14.8 | Inconspicuous: only 4,8 % of the relevant wait time (threshold 5 %) - no action required. |
| BACKUPTHREAD | Other | 3.3 | 272.18 | 0.1 | |
| WRITELOG | I/O | 3.2 | 0.89 | 19.3 | Inconspicuous: average wait 0,89 ms is below the 5 ms threshold - no action required. |
| SessionId | BlockingSessionId | LoginName | DatabaseName | Status | WaitType | ElapsedSeconds | CpuTimeMs | TempdbAllocMB | SqlText |
|---|---|---|---|---|---|---|---|---|---|
| 110 | 0 | app_portal | OrderPortal-DMZ | sleeping | 6439 | 14105 | 18.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 | |
| 254 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5443 | 13214 | 10.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 | |
| 262 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5262 | 14203 | 18.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 | |
| 158 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5068 | 0 | 0.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 | |
| 129 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5068 | 0 | 0.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 | |
| 149 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5067 | 0 | 0.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 | |
| 157 | 0 | app_portal | OrderPortal-DMZ | sleeping | 5057 | 0 | 0.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 | |
| 165 | 0 | app_portal | OrderPortal-DMZ | sleeping | 4709 | 0 | 0.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 | |
| 193 | 0 | app_portal | OrderPortal-DMZ | sleeping | 4604 | 15 | 0.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 | |
| 170 | 0 | app_portal | OrderPortal-DMZ | sleeping | 4535 | 0 | 0.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.
Benutzertransaktionen, die seit mindestens 1 Minute(n) offen sind. 'sleeping' mit offener Transaktion heisst meist: die Anwendung hat COMMIT vergessen.
| SessionId | LoginName | HostName | ProgramName | DatabaseName | BeginTime | OpenSeconds | SessionStatus | LogUsedMB | LastSqlText |
|---|---|---|---|---|---|---|---|---|---|
| 110 | app_portal | dmzhost02 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:35 | 6441 | sleeping | 0.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 |
| 254 | app_portal | dmzhost02 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:51 | 5505 | sleeping | 0.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 |
| 264 | app_portal | dmzhost02 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:51 | 5504 | sleeping | 0.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 |
| 262 | app_portal | dmzhost02 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:55 | 5264 | sleeping | 0.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 |
| 129 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5070 | sleeping | 0.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 |
| 149 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5070 | sleeping | 0.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 |
| 158 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5070 | sleeping | 0.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 |
| 161 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5070 | sleeping | 0.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 |
| 165 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5070 | sleeping | 0.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 |
| 160 | app_portal | dmzhost01 | Microsoft JDBC Driver for SQL Server | OrderPortal-DMZ | 2026-11-11 06:58 | 5067 | sleeping | 0.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.
| Status | FileCount | RecommendedCount | FileSizesMB | GrowthMB | Recommendations |
|---|---|---|---|---|---|
| Warning | 8 | 4 | 4352, 4352, 4352, 4352, 4352, 4352, 4352, 4352 | 256, 256, 256, 256, 256, 256, 256, 256 | Anzahl TempDB-Dateien: 8 (empfohlen 4). Alle TempDB-Dateien liegen auf demselben Laufwerk (F) - fuer optimale Leistung separate Laufwerke empfehlenswert. |
Keine Eintraege.
| Database | OverallStatus | RecoveryModel | SizeMB | LastCheckDb | CheckDbStatus | LastFullBackup | LastLogBackup | VlfCount | VlfStatus |
|---|---|---|---|---|---|---|---|---|---|
| BillingTool_Retail | OK | Simple | 14.8 | 2026-11-08 | OK | 2026-11-10 20:30 | n/a | 4 | OK |
| RoleProfiles | OK | Simple | 106.8 | 2026-11-08 | OK | 2026-11-10 20:30 | n/a | 5 | OK |
| AppInventory | OK | Simple | 1119.8 | 2026-11-08 | OK | 2026-11-10 20:30 | n/a | 3 | OK |
| OrderPortal | OK | Simple | 3008 | 2026-11-08 | OK | 2026-11-10 20:30 | n/a | 4 | OK |
| OrderPortal-DMZ | OK | Simple | 9664 | 2026-11-08 | OK | 2026-11-10 20:30 | n/a | 4 | OK |
| Contoso_CMS | OK | Simple | 13588 | 2026-11-08 | OK | 2026-11-10 20:31 | n/a | 9 | OK |
| Contoso_Wiki | OK | Simple | 49888 | 2026-11-08 | OK | 2026-11-10 20:31 | n/a | 2 | OK |
| ProjectSuite_PROD | OK | Simple | 132001 | 2026-11-08 | OK | 2026-11-10 20:35 | n/a | 16 | OK |
| BIReporting01 | OK | Simple | 249.4 | 2026-11-08 | OK | 2026-11-10 20:36 | n/a | 10 | OK |
| TradingCore_PROD | OK | Simple | 7020.7 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 2 | OK |
| DocArchive01 | OK | Simple | 2641.1 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 15 | OK |
| SandboxTest01 | OK | Simple | 192 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 4 | OK |
| DeadlockCollector | OK | Simple | 1119.8 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 3 | OK |
| ExternalScores | OK | Simple | 5247.9 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 2 | OK |
| Ops_Monitoring | OK | Simple | 19.8 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 3 | OK |
| PrintServices | OK | Simple | 4790.1 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 4 | OK |
| HwInventory | OK | Simple | 1151.9 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 2 | OK |
| IdeaData1 | OK | Simple | 175.8 | 2026-11-08 | OK | 2026-11-10 20:37 | n/a | 7 | OK |
| IdentityMgmt | OK | Simple | 18047.8 | 2026-11-08 | OK | 2026-11-10 20:38 | n/a | 2 | OK |
| EndUserApps | OK | Simple | 307631 | 2026-11-08 | OK | 2026-11-10 20:59 | n/a | 6 | OK |
| EndUserApps_old | OK | Simple | 308495 | 2026-11-01 | OK | 2026-11-10 21:37 | n/a | 60 | OK |
| PortalEU_PROD | OK | Simple | 3744.1 | 2026-11-08 | OK | 2026-11-10 21:47 | n/a | 5 | OK |
| PortalConfigDB | OK | Simple | 6461.5 | 2026-11-08 | OK | 2026-11-10 21:47 | n/a | 8 | OK |
| IssueTracker | OK | Simple | 20607.9 | 2026-11-08 | OK | 2026-11-10 21:48 | n/a | 2 | OK |
| BudgetPlanner | OK | Simple | 1151.9 | 2026-11-08 | OK | 2026-11-10 21:48 | n/a | 2 | OK |
... 31 weitere Zeile(n) im Detailbericht.
Letzter Backup-Lauf: 2026-11-10 21:56 | Ausgeschlossen (sqm_BackupExclude): 0
| Database | Status | RecoveryModel | CreateDate | LastFullBackup | LastLogBackup | Notes |
|---|---|---|---|---|---|---|
| Tfs_MainCollection | Critical | SIMPLE | 2020-11-19 20:36 | 2026-11-09 21:13 | Letztes Full/Diff vor 35.2 h (Grenze 26 h) |
| Ranks | DatabaseName | ObjectName | Executions | TotalCpuMs | CpuPercent | AvgDurationMs | AvgReads | Findings | StatementText |
|---|---|---|---|---|---|---|---|---|---|
| CPU#1, Duration#1, Reads#4 | EndUserApps | (ad hoc) | 28096 | 24570081 | 25.21 | 1035.95 | 19304 | ImplicitConversion, KeyLookup | SELECT [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#1 | ProjectSuite_PROD | (ad hoc) | 1329370 | 20330943 | 20.86 | 16.13 | 3122 | ImplicitConversion, MissingIndex | SELECT COUNT(*) FROM TB_VOUCHER_BATCH v1 WHERE (v1.BATCH_NUMBER=@P0) |
| CPU#3, Duration#4 | EndUserApps | (ad hoc) | 9712 | 8471022 | 8.69 | 1025.05 | 19747 | ImplicitConversion, KeyLookup | SELECT 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#5 | master | (ad hoc) | 934 | 6917722 | 7.1 | 8247.18 | 125 | ImplicitConversion | SELECT 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#8 | ExternalScores | (ad hoc) | 123939 | 4258472 | 4.37 | 110.83 | 2240 | ImplicitConversion | select dataValue from dbo.spScoreLevelData where entityKey= @P0 and scoreItemId=1 |
| CPU#6, Duration#8, Reads#10 | TradingCore_PROD | (ad hoc) | 263099 | 3424827 | 3.51 | 14.34 | 859 | MissingIndex | SELECT [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#6 | ExternalScores | (ad hoc) | 77430 | 2000922 | 2.05 | 78.23 | 3898 | ImplicitConversion, MissingIndex | select 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#2 | ProjectSuite_PROD | (ad hoc) | 460598 | 1744872 | 1.79 | 3.84 | 3393 | ImplicitConversion, KeyLookup | SELECT 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#10 | TradingCore_PROD | (ad hoc) | 100 | 1059061 | 1.09 | 27322.55 | 227539 | SELECT [FlowId], [AmountOverwrite], [Barrier], [BarrierKind], [BaseAmount], [CapOrFloor], [Currency], [End], [ExchangedAmount], [FixingRate], [FixingDate], [Index], [InvertBuy], [InvertStrike], [KnockInStrike], [KnockOutStrike] ... | |
| CPU#10 | ProjectSuite_PROD | (ad hoc) | 71347626 | 940824 | 0.97 | 0.03 | 0 | SELECT NEXT VALUE FOR SQ_PK | |
| Duration#7 | TradingCore_PROD | (ad hoc) | 471 | 771103 | 0.79 | 8745.93 | 33636 | SELECT [LegId], [CapOrFloor], [Currency], [DayCountMethod], [DiscountCurveName], [End], [EndStubNextIndex], [EndStubPreviousIndex], [FirstCouponEffectiveDate], [FixedRate], [ForwardCurveName], [FxCurveName] ... | |
| Duration#9 | EndUserApps | (ad hoc) | 21351 | 628839 | 0.65 | 171.46 | 1087 | ImplicitConversion | SELECT * FROM [App].[Report_AccessAndRoles] WHERE [LastDeliveryDate]=@1 |
| Reads#5 | EndUserApps | (ad hoc) | 93 | 617729 | 0.63 | 7502.19 | 3566472 | ImplicitConversion, KeyLookup | SELECT [t0].[TaskId], [t0].[TaskClassificationId], [t0].[TaskStatus], [t0].[TaskOrgUnit], [t0].[TaskRoleId], [t0].[TaskDueAt], [t0].[TaskSchemeId], [t0].[TaskDescription], [t0].[IsProcessedByNotification], [t0].[CreatedAt], [t ... |
| Reads#7 | ProjectSuite_PROD | (ad hoc) | 14211815 | 530083 | 0.54 | 0.04 | 20 | ImplicitConversion | insert 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#9 | EndUserApps | (ad hoc) | 202 | 487829 | 0.5 | 3256.51 | 1266335 | ImplicitConversion, KeyLookup, Spill | SELECT * FROM App.PendingWorkflows_LV WHERE IsProcessedByNotification = 0 |
... 1 weitere Zeile(n) im Detailbericht.
| Finding | Count | SizeMB |
|---|---|---|
| Heap | 425 | 81398.3 |
| Unused | 5343 | 80951.6 |
| Overlapping | 157 | 2376.7 |
| Duplicate | 43 | 174.1 |
| Finding | DatabaseName | TableName | IndexName | SizeMB | Reads | Writes | Detail |
|---|---|---|---|---|---|---|---|
| Heap | ProjectSuite_PROD | TMP_RESULT_CACHE | (heap) | 63135.34 | 0 | 0 | Tabelle ohne Clustered Index, 1 Nonclustered-Index(e). |
| Unused | ProjectSuite_PROD | TMP_RESULT_CACHE | I_TMP_RESULT_CACHE | 49795.88 | 0 | 0 | Kein Lesezugriff seit Neustart (9.7 Tage), 0 Schreibvorgaenge. |
| Heap | PatchMgmt | vuln_plugin | (heap) | 2535.87 | 0 | 0 | Tabelle ohne Clustered Index, 0 Nonclustered-Index(e). |
| Heap | OrderPortal | APP_DBS_PAGE | (heap) | 1920.27 | 23312 | 28528 | Tabelle ohne Clustered Index, 1 Nonclustered-Index(e). |
| Heap | IdentityMgmt | TempDirectMemberships | (heap) | 1896.52 | 0 | 0 | Tabelle ohne Clustered Index, 1 Nonclustered-Index(e). |
| Heap | TimeReporting | Worklog_STAGING | (heap) | 1895.13 | 30 | 178 | Tabelle ohne Clustered Index, 0 Nonclustered-Index(e). |
| Unused | EndUserApps_old | App_ProjectUser | ProjectUser$Filename_IX | 1812 | 0 | 0 | Kein Lesezugriff seit Neustart (9.7 Tage), 0 Schreibvorgaenge. |
| Heap | OrderPortal-DMZ | APP_DBS_PAGE | (heap) | 1516.27 | 73259 | 118769 | Tabelle ohne Clustered Index, 1 Nonclustered-Index(e). |
| Heap | webcore | webPerformanceInfo | (heap) | 1115.12 | 0 | 0 | Tabelle ohne Clustered Index, 4 Nonclustered-Index(e). |
| Heap | PatchMgmt | cache_imports | (heap) | 1059.7 | 0 | 0 | Tabelle ohne Clustered Index, 0 Nonclustered-Index(e). |
... 5958 weitere Zeile(n) im Detailbericht.
| DatabaseName | TableName | ImpactScore | UserSeeks | EqualityColumns | InequalityColumns | IncludedColumns |
|---|---|---|---|---|---|---|
| ProjectSuite_PROD | TB_VOUCHER_BATCH | 3195847.12 | 1329370 | [BATCH_NUMBER] | ||
| ExternalScores | spScoreData | 717785.54 | 224883 | [objectTypeId], [scoreTypeCode] | [scoreDetailId], [entityKey], [instrumentKey], [issuerKey], [typeCode], [scoreKey], [scoreDate], [trend], [trendDate], [qualifier] | |
| TradingCore_PROD | Holiday | 405555.52 | 327278 | [CalendarId] | [Id], [Date], [DayOfWeek], [DayMonth_Day], [DayMonth_Month], [FromYear], [Rule], [Comment] | |
| EndUserApps | App_ProjectVersion | 52537.77 | 621 | [Stage], [DeploymentId] | [IsRoot] | [FileDate] |
| EndUserApps | App_ProjectVersion | 52317.33 | 621 | [Stage], [DeploymentId] | [FileDate] | |
| ProjectSuite_PROD | TB_DEPT_MEMBER | 44355.04 | 343156 | [STAFF_ID] | ||
| TimeReporting | StaffList | 40771.42 | 690 | [IsExternal] | [uid] | |
| EndUserApps | App_WorkflowValue_BR | 29326.45 | 16364 | [ClassificationId] | ||
| EndUserApps | App_ProjectVersion | 20614.12 | 238 | [Stage], [DeploymentId] | [IsRoot] | [ID], [GUID], [HostName], [FileName], [OwnerUnit], [RunUser], [RunDate], [FileDate], [FileSize], [FileType], [Connections], [Sheets], [Charts], [Formulas], [PivotTables], [Controls] ... |
| EndUserApps | App_ProjectVersion | 20523.42 | 238 | [Stage], [DeploymentId] | [ID], [GUID], [HostName], [FileName], [OwnerUnit], [RunUser], [RunDate], [FileDate], [FileSize], [FileType], [Connections], [Sheets], [Charts], [Formulas], [PivotTables], [Controls] ... |
| DatabaseName | LogicalName | FileType | Drive | Reads | AvgReadMs | Writes | AvgWriteMs | Rating |
|---|---|---|---|---|---|---|---|---|
| tempdb | temp7 | ROWS | F: | 199662 | 1.76 | 204473 | 318.04 | Critical |
| tempdb | temp3 | ROWS | F: | 199695 | 1.75 | 204669 | 317.75 | Critical |
| tempdb | temp5 | ROWS | F: | 200031 | 1.75 | 204749 | 317.57 | Critical |
| tempdb | temp6 | ROWS | F: | 199878 | 1.75 | 204847 | 317.51 | Critical |
| tempdb | tempdev | ROWS | F: | 200012 | 1.76 | 205068 | 317.16 | Critical |
| tempdb | temp2 | ROWS | F: | 199917 | 1.75 | 205087 | 317.12 | Critical |
| tempdb | temp8 | ROWS | F: | 199923 | 1.75 | 205113 | 317.1 | Critical |
| tempdb | temp4 | ROWS | F: | 199932 | 1.75 | 205181 | 316.94 | Critical |
| tempdb | templog | LOG | F: | 78 | 0.23 | 113860 | 23.56 | Critical |
| IdentityMgmt | IdentityMgmt | ROWS | F: | 472926 | 27.2 | 637 | 1.39 | Warning |
... 117 weitere Zeile(n) im Detailbericht.
Deadlocks der letzten 15 Tage (system_health, Ring Buffer + .xel). Die Graphen liegen als .xdl in Details\Deadlocks.
| Timestamp | VictimLogin | VictimHost | VictimProgram | ProcessCount | VictimStatement |
|---|---|---|---|---|---|
| 2026-11-10 14:45 | MarketResearchAdmin | apphost01 | Microsoft SQL Server JDBC Driver | 2 | (@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1) |
| 2026-11-09 19:55 | CONTOSO\jdoe | SQLPROD01 | Microsoft SQL Server Management Studio | 2 | (@_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:00 | MarketResearchAdmin | apphost01 | Microsoft SQL Server JDBC Driver | 2 | (@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:00 | MarketResearchAdmin | apphost02 | Microsoft JDBC Driver for SQL Server | 2 | (@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1) |
| 2026-10-29 10:30 | MarketResearchAdmin | apphost02 | Microsoft JDBC Driver for SQL Server | 2 | (@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1) |
| 2026-10-28 10:15 | MarketResearchAdmin | apphost01 | Microsoft SQL Server JDBC Driver | 2 | (@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1) |
| 2026-10-27 11:45 | MarketResearchAdmin | apphost02 | Microsoft JDBC Driver for SQL Server | 2 | (@P0 datetime2,@P1 nvarchar(4000))UPDATE APPLASTMODIFIED SET MODIFIED = @P0 WHERE (CLASSNAME = @P1) |
| LoginName | LoginType | IsEnabled | IsSa | LastLogin | Status | Message |
|---|---|---|---|---|---|---|
| CONTOSO\SQL_ServerAdmins_Full | WINDOWS_GROUP | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| CONTOSO\SQL_DBA_Team | WINDOWS_GROUP | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| CONTOSO\svc_sqlcollect | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| NT AUTHORITY\SYSTEM | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| NT SERVICE\MSSQLSERVER | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| NT SERVICE\SQLSERVERAGENT | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| NT SERVICE\SQLWriter | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. | |
| NT SERVICE\Winmgmt | WINDOWS_LOGIN | True | False | Unexpected | Sysadmin-Login - kein Ausschluss definiert. |
| MountPoint | VolumeName | TotalGB | FreeGB | FreePct | DaysUntilFull | Status | Message |
|---|---|---|---|---|---|---|---|
| F:\ | SQLData | 2000.0 | 293.2 | 14.7 | Warning | Warnung: nur 14.7% frei (293.2 GB). |