SQL Server Setup Report

Instance: DEV01 | Timestamp: 2026-07-19 18:36:51
CRITICAL ISSUES
SA Account
CRITICAL (not renamed)
Name: sa
Backup Jobs
OK (5 jobs)
Enable backups immediately if missing
Max Memory
NOT CONFIGURED (default)
Tolerance: 85-95% of RAM
SECURITY
Sysadmin Accounts
dev
DEV01\Administrator
NT Service\MSSQLSERVER
NT SERVICE\SQLSERVERAGENT
NT SERVICE\SQLWriter
NT SERVICE\Winmgmt
sa
Logins with Extended Roles
dev [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]
DEV01\Administrator [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]
NT SERVICE\SQLSERVERAGENT [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]
NT SERVICE\SQLWriter [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]
NT SERVICE\Winmgmt [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]
sa [sysadmin, serveradmin, securityadmin, processadmin, dbcreator, diskadmin]

Server-Level Features

CLR: OK (disabled)

xp_cmdshell: OK (disabled)

Infrastructure

SPN Status: WARNUNG (0 fehlend, 0 unerwartet)

Not checked

Splunk: Not configured

SERVICE ACCOUNTS

Unable to determine

CONFIGURATION

Query Execution

MAXDOP: CHECK (12, recommended 8)

Cost Threshold: WARNING (5, recommended >= 50)

Tempdb

Files: OK (8 files)

DATABASES
Database Recovery Model DBO Owner Last Full Backup
PartitionTestDBFulldevNever
ArchiveTestDBFulldevNever
ActiveSourceDBFulldevNever
AdventureWorksSimpledevNever
SQLLiveDiagnoseFulldevNever
sqmRestoreTestFullsaNever
Report generated by sqmSQLTool - Setup Report v2.0 | All times UTC
Quelle: www.powershelldba.de