by Peter Nyffenegger     info@pn-informatik.ch                       Ihre IP-Adresse:  54.205.108.212   compiled with VS 2015

.

.

.

.

.

System
Name Processor Operating System Total Memory (GB) Uptime Clustered
WIN-RJRJ3K27MCHAMD FX(tm)-8350 Eight-Core Processor Windows NT x64 Version 6.3 (14393)15.9514 days, 14 hours & 20 minutesNo
 
SQL Server
Version Start Up Date Used Memory (MB) Collation User Mode SQL Agent
Microsoft SQL Server 13.0.4411.0 SP1 Enterprise Edition (64-bit)Feb 11 2017 4:45PM2329.718750Latin1_General_CI_ASMultiUp
 
SQL Server Configuration - Modified Settings
Configuration Name Configuration Description Default Value Current Value Dynamic Setting Advanced Setting
Agent XPsEnable or disable Agent XPs0111
backup compression defaultEnable compression of backups by default0110
clr enabledCLR user code execution enabled in the server0110
default full-text languagedefault full-text language1033103111
default languagedefault language0110
filestream access levelSets the FILESTREAM access level0210
min server memory (MB)Minimum size of server memory (MB)01611
Ole Automation ProceduresEnable or disable Ole Automation Procedures0111
priority boostPriority boost0101
remote login timeout (s)remote login timeout201010
show advanced optionsshow advanced options0110
 
Databases
Database Create Date Restore Date Last Backup Date Size (GB) State Recovery Replicated Mirrored
aspnetdbJan 6 2017 2:21PMJan 6 2017 2:21PMJan 7 2017 11:47AM0.00488ONLINESIMPLENoNo
BestellabwicklungV11Jan 8 2017 5:12PMJan 8 2017 5:14PMJan 8 2017 4:40PM5.72949ONLINEFULLNoNo
CL70085_dbSchulverwaltungSQLJan 6 2017 2:19PMJan 6 2017 2:19PMFeb 24 2017 9:21PM0.81641ONLINESIMPLENoNo
dbDokumentSQLJan 8 2017 3:05PMJan 8 2017 3:05PMDec 29 2016 10:35AM0.21973ONLINEFULLNoNo
dbPCInventarJan 30 2017 7:37PMJan 30 2017 7:37PMMay 29 2007 10:12AM0.00781ONLINESIMPLENoNo
dbPCInventarSQLFeb 12 2017 2:11PMFeb 12 2017 2:11PMFeb 12 2017 10:03PM0.04590ONLINESIMPLENoNo
dbUmfrageSQLJan 6 2017 2:24PMJan 6 2017 2:24PMFeb 17 2017 10:15PM3.13672ONLINESIMPLENoNo
dbWardenJan 6 2017 7:48PMJan 6 2017 7:47PMJan 7 2017 11:47AM0.02539ONLINESIMPLENoNo
masterApr 8 2003 9:13AMN/AJan 7 2017 11:47AM0.00684ONLINESIMPLENoNo
modelApr 8 2003 9:13AMN/AJan 7 2017 11:47AM0.01562ONLINEFULLNoNo
msdbApr 30 2016 12:46AMN/AJan 7 2017 11:47AM0.04394ONLINESIMPLENoNo
ReportServerJan 6 2017 2:15PMN/AJan 7 2017 11:47AM0.07812ONLINEFULLNoNo
ReportServerTempDBJan 6 2017 2:15PMN/AJan 7 2017 11:47AM0.01562ONLINESIMPLENoNo
semanticsdbJan 21 2017 11:45AMJan 21 2017 11:45AMJun 4 2016 2:50PM0.39062ONLINESIMPLENoNo
tempdbFeb 11 2017 4:45PMN/AN/A0.13281ONLINESIMPLENoNo
Disks
Drive Free Space (GB) Cluster Share
C:410.57No
F:1814.88No
 
Trace Flags
No Trace Flags Are Active
 
Database Settings
Database Owner Compat. Level User Access Read Only AutoCreate Stats AutoUpdate Stats Quoted Identifier FullText Trustworthy Encryption
aspnetdbsa130MULTI_USERNoYesYesNoYesNoNo
BestellabwicklungV11nyffeneggerpeter1957130MULTI_USERNoYesYesNoNoNoNo
CL70085_dbSchulverwaltungSQLsa130MULTI_USERNoYesYesYesNoNoNo
dbDokumentSQLnyffeneggerpeter1957130MULTI_USERNoYesYesNoYesNoNo
dbPCInventarnyffeneggerpeter1957100MULTI_USERNoYesYesNoYesNoNo
dbPCInventarSQLnyffeneggerpeter1957110MULTI_USERNoYesYesNoYesNoNo
dbUmfrageSQLsa130MULTI_USERNoYesYesNoNoNoNo
dbWardenWIN-RJRJ3K27MCH\Administrator130MULTI_USERNoYesYesNoYesNoNo
mastersa130MULTI_USERNoYesYesNoNoNoNo
modelsa130MULTI_USERNoYesYesNoNoNoNo
msdbsa130MULTI_USERNoYesYesNoYesYesNo
ReportServerWIN-RJRJ3K27MCH\Administrator130MULTI_USERNoYesYesNoYesNoNo
ReportServerTempDBWIN-RJRJ3K27MCH\Administrator130MULTI_USERNoYesYesNoYesNoNo
semanticsdbsa130MULTI_USERNoYesYesNoYesNoNo
tempdbsa130MULTI_USERNoYesYesNoNoNoNo
 
Orphaned Users
There are no orphaned users in any user databases
 
File Info
Database Drive FileName Logical Name Group VLF Count Size (MB) Growth Used (MB) Empty (MB) % Empty
aspnetdbF:aspnvvetdb.mdfaspnetdbPRIMARYN/A41 MB3125.00
aspnetdbF:aspvvvnetdb_log.ldfaspnetdb_logN/A5110 %01100.00
BestellabwicklungV11C:BestellabwicklungV11.ldfBestellabwicklungV11_logN/A103224550 %65218097.10
BestellabwicklungV11C:BestellabwicklungV11.mdfBestellabwicklungV11_datPRIMARYN/A2572110 MB230626610.34
BestellabwicklungV11C:BestellabwicklungV11.ndfBestellabwicklungV11_idxINDEXN/A1050110 MB30974170.57
CL70085_dbSchulverwaltungSQLF:schul.ldfCL70085_dbSchulverwaltungSQL_logN/A1210610 %510195.28
CL70085_dbSchulverwaltungSQLF:schuleCL70085_dbSchulverwaltungSQLPRIMARYN/A73010 MB55117924.52
dbDokumentSQLF:dbDokumentSQL.mdfdbDokumentSQLDBPRIMARYN/A1701 MB1115993.53
dbDokumentSQLF:dbDokumentSQL_1.ldfdbDokumentSQLLOGN/A295510 %134276.36
dbPCInventarF:PCInventarSQL.ldfPCInventarSQL_logN/A15410 %04100.00
dbPCInventarF:PCInventarSQL.mdfPCInventarSQL_datPRIMARYN/A41 MB3125.00
dbPCInventarSQLF:dbPCInventarSQL.ldfBpPlix_logN/A82510 %22392.00
dbPCInventarSQLF:dbPCInventarSQL.mdfBpPlix_datPRIMARYN/A221 MB2114.55
dbUmfrageSQLF:umfrageNEU.ldfdbUmfrageSQL_logN/A50190510 %687121863.94
dbUmfrageSQLF:umfrageNEU.mdfdbUmfrageSQLPRIMARYN/A130710 MB46384464.58
dbWardenF:dbWarden.mdfdbWardenPRIMARYN/A241 MB101458.33
dbWardenF:dbWarden_log.ldfdbWarden_logN/A9210 %1150.00
masterC:master.mdfmasterPRIMARYN/A510 %4120.00
masterC:mastlog.ldfmastlogN/A9210 %1150.00
modelC:model.mdfmodeldevPRIMARYN/A864 MB2675.00
modelC:modellog.ldfmodellogN/A6864 MB1787.50
msdbC:MSDBData.mdfMSDBDataPRIMARYN/A1710 %1700.00
msdbC:MSDBLog.ldfMSDBLogN/A352810 %22692.86
ReportServerF:ReportServer.mdfReportServerPRIMARYN/A864 MB6225.00
ReportServerF:ReportServer_log.ldfReportServer_logN/A87264 MB86488.89
ReportServerTempDBF:ReportServerTempDB.mdfReportServerTempDBPRIMARYN/A864 MB3562.50
ReportServerTempDBF:ReportServerTempDB_log.ldfReportServerTempDB_logN/A4864 MB08100.00
semanticsdbF:semanticsdb.mdfsemanticsdbPRIMARYN/A2151 MB21500.00
semanticsdbF:semanticsdb_log.ldfsemanticsdb_logN/A1118510 %118499.46
tempdbC:tempdb.mdftempdevPRIMARYN/A864 MB3562.50
tempdbC:tempdb_mssql_2.ndftemp2PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_3.ndftemp3PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_4.ndftemp4PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_5.ndftemp5PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_6.ndftemp6PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_7.ndftemp7PRIMARYN/A864 MB1787.50
tempdbC:tempdb_mssql_8.ndftemp8PRIMARYN/A864 MB1787.50
tempdbC:templog.ldftemplogN/A87264 MB96387.50
 
File Stats - Last 24 Hours
FileName # Reads KBytes Read # Writes KBytes Written IO Read Wait (MS) IO Write Wait (MS) Cumulative IO (GB) IO %
aspnvvetdb.mdf573504.00 (3.42 MB)18.00 (0.01 MB)925230.000.03
aspvvvnetdb_log.ldf740.00 (0.04 MB)1460.00 (0.06 MB)59800.000.00
BestellabwicklungV11.ldf106768.00 (0.75 MB)524.00 (0.02 MB)1435150.000.00
BestellabwicklungV11.mdf60337784.00 (36.90 MB)18.00 (0.01 MB)412800.040.31
BestellabwicklungV11.ndf181088.00 (1.06 MB)00.00 (0.00 MB)15500.000.01
dbDokumentSQL.mdf623832.00 (3.74 MB)18.00 (0.01 MB)153700.000.03
dbDokumentSQL_1.ldf321084.00 (1.06 MB)940.00 (0.04 MB)1133430.000.01
dbPCInventarSQL.ldf172984.00 (2.91 MB)14998401.00 (8.20 MB)11749300.010.09
dbPCInventarSQL.mdf25840712.00 (39.76 MB)2823464.00 (3.38 MB)1326710740.040.37
dbWarden.mdf563408.00 (3.33 MB)141248.00 (1.22 MB)2793100.000.03
dbWarden_log.ldf12312.00 (0.30 MB)561856.00 (1.81 MB)519144400.000.02
master.mdf693792.00 (3.70 MB)303724416.00 (23.84 MB)41313250.030.23
mastlog.ldf12172.00 (0.17 MB)35070148684.00 (145.20 MB)16102710.141.25
model.mdf4410264.00 (10.02 MB)216.00 (0.02 MB)39500.010.09
modellog.ldf9992.00 (0.97 MB)22104.00 (0.10 MB)107640.000.01
MSDBData.mdf18913240.00 (12.93 MB)44520.00 (0.51 MB)1156130.010.11
MSDBLog.ldf381108.00 (1.08 MB)4011760.00 (1.72 MB)3142720.000.02
PCInventarSQL.ldf18456.00 (0.45 MB)944.00 (0.04 MB)631240.000.00
PCInventarSQL.mdf492944.00 (2.88 MB)18.00 (0.01 MB)76600.000.02
ReportServer.mdf824960.00 (4.84 MB)00.00 (0.00 MB)239300.000.03
ReportServer_log.ldf111000.00 (0.98 MB)736.00 (0.04 MB)56810.000.01
ReportServerTempDB.mdf512896.00 (2.83 MB)18.00 (0.01 MB)142300.000.02
ReportServerTempDB_log.ldf7984.00 (0.96 MB)1048.00 (0.05 MB)51620.000.01
schul.ldf241212.00 (1.18 MB)12257676.00 (7.50 MB)10091876140.010.07
schule74255124032.00 (5003.94 MB)6967048.00 (6.88 MB)25951327984.8943.25
semanticsdb.mdf19412232.00 (11.95 MB)18.00 (0.01 MB)40700.010.09
semanticsdb_log.ldf141012.00 (0.99 MB)420.00 (0.02 MB)866230.000.01
tempdb.mdf30818096.00 (17.67 MB)26715816.00 (15.45 MB)4402180.030.28
tempdb_mssql_2.ndf26415704.00 (15.34 MB)25315624.00 (15.26 MB)2681830.030.26
tempdb_mssql_3.ndf27015712.00 (15.34 MB)25315632.00 (15.27 MB)2511850.030.26
tempdb_mssql_4.ndf26015264.00 (14.91 MB)24515184.00 (14.83 MB)2781720.030.25
tempdb_mssql_5.ndf26515648.00 (15.28 MB)24915568.00 (15.20 MB)2641660.030.26
tempdb_mssql_6.ndf26815712.00 (15.34 MB)25215632.00 (15.27 MB)4091660.030.26
tempdb_mssql_7.ndf26515720.00 (15.35 MB)25015640.00 (15.27 MB)2761750.030.26
tempdb_mssql_8.ndf26915936.00 (15.56 MB)25415856.00 (15.48 MB)3151720.030.27
templog.ldf111000.00 (0.98 MB)140880976.00 (79.08 MB)9713270.080.69
umfrageNEU.ldf42473544916.00 (3461.83 MB)622643824.00 (42.80 MB)1086121049613.4230.25
umfrageNEU.mdf40732455232.00 (2397.69 MB)133316928.00 (16.53 MB)13712289422.3620.84
 
Mirroring
Mirroring is not setup on this system
 
Log Shipping
Log Shipping is not setup on this system
 
Replication Distributor
Distributor is not setup on this system
 
Replication Publisher
Publisher is not setup on this system
 
Replication Subscriptions
Subscriptions are not setup on this system
 
SQL Agent Jobs
Job Name Owner Category Enabled Last Outcome Last Date Run AvgRunTime(mi) LastRunTime(mi)
dbWarden_BlockingAlertsaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_CheckFilessaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_CPUAlertsaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_HealthReportsaDatabase MonitoringTrueInProcessFeb 26 2017 6:05AM0.000.02
dbWarden_LongRunningJobsAlertsaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_LongRunningQueriesAlertsaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_MemoryUsageStatssaDatabase MonitoringFalseNAN/A0.000.00
dbWarden_PerfStatssaDatabase MonitoringFalseNAN/A0.000.00
syspolicy_purge_historysa[Uncategorized (Local)]TrueSuccessFeb 26 2017 2:00AM0.110.07
 
Long Running Queries
There has been no recently recorded long running queries
 
Blocking
There has been no recently recorded blocking
 
Deadlocks - Previous Day
There has been no recently recorded Deadlocks OR TraceFlag 1222 is not Active
 
Schema Changes
Schema Change Tracking is not enabled on any databases
 
Error Log - Last 24 Hours
There has been no recently recorded error log entries
 
Backup Stats - Last 24 Hours
No backups have been created on this server in the last 24 hours
 
dbWarden Alert Settings
Alert Name Variable Name Value Description Enabled
BlockingAlertQueryValue10Value is in seconds1
BlockingAlertQueryValue220Value is in seconds1
CPUAlertQueryValue85Value is percentage1
CPUAlertQueryValue295Value is percentage1
HealthReportShowBackupsN/AVariable for the HealthReport1
HealthReportShowCPUStatsN/AVariable for the HealthReport1
HealthReportShowDatabaseSettingsN/AVariable for the HealthReport1
HealthReportShowdbWardenSettingsN/AVariable for the HealthReport1
HealthReportShowEmptySectionsN/AVariable for the HealthReport1
HealthReportShowErrorLogN/AVariable for the HealthReport0
HealthReportShowFullFileInfoN/AVariable for the HealthReport1
HealthReportShowFullJobInfoN/AVariable for the HealthReport1
HealthReportShowLogBackupsN/AVariable for the HealthReport1
HealthReportShowModifiedServerConfigN/AVariable for the HealthReport1
HealthReportShowOrphanedUsersN/AVariable for the HealthReport0
HealthReportShowPerfStatsN/AVariable for the HealthReport1
HealthReportShowSchemaChangesN/AVariable for the HealthReport1
LogFilesMinFileSizeMB0Value is percentage1
LogFilesQueryValue50Value is percentage1
LogFilesQueryValue220Value is percentage1
LongRunningJobsQueryValue60Value is in seconds1
LongRunningQueriesQueryValue615Value is in seconds1
LongRunningQueriesQueryValue21200Value is in seconds1
TempDBMinFileSizeMB0Value is a number1
TempDBQueryValue50Value is percentage1
TempDBQueryValue220Value is percentage1
dbWarden Database Settings
Database Schema Tracking Log File Alerts Long Query Alerts Reindex
aspnetdb0110
CL70085_dbSchulverwaltungSQL0110
dbUmfrageSQL0110
dbWarden0110
master0110
model0110
msdb0110
ReportServer0110
ReportServerTempDB0110
tempdb0110
BestellabwicklungV11This database is not listed in the DatabaseSettings table
dbDokumentSQLThis database is not listed in the DatabaseSettings table
dbPCInventarThis database is not listed in the DatabaseSettings table
dbPCInventarSQLThis database is not listed in the DatabaseSettings table
semanticsdbThis database is not listed in the DatabaseSettings table
 
Generated on Feb 26 2017 6:05AM with dbWarden v2.5.2
   Gruppenzugehörigkeit: