by Peter Nyffenegger     info@pn-informatik.ch                       Ihre IP-Adresse:  54.161.155.6   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.954 days, 13 hours & 16 minutesNo
 
SQL Server
Version Start Up Date Used Memory (MB) Collation User Mode SQL Agent
Microsoft SQL Server 13.0.4199.0 SP1 Enterprise Edition (64-bit)Jan 11 2017 5:49PM3243.781250Latin1_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.71973ONLINEFULLNoNo
CL70085_dbSchulverwaltungSQLJan 6 2017 2:19PMJan 6 2017 2:19PMJan 15 2017 2:05PM0.81641ONLINESIMPLENoNo
dbDokumentSQLJan 8 2017 3:05PMJan 8 2017 3:05PMDec 29 2016 10:35AM0.21973ONLINEFULLNoNo
dbUmfrageSQLJan 6 2017 2:24PMJan 6 2017 2:24PMJan 13 2017 2:18PM3.12402ONLINESIMPLENoNo
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
tempdbJan 11 2017 5:49PMN/AN/A0.13281ONLINESIMPLENoNo
Disks
Drive Free Space (GB) Cluster Share
C:433.43No
F:1824.13No
 
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
dbUmfrageSQLsa130MULTI_USERNoYesYesNoNoNoNo
dbWardenWIN-RJRJ3K27MCH\Administrator130MULTI_USERNoYesYesNoYesNoNo
mastersa130MULTI_USERNoYesYesNoNoNoNo
modelsa130MULTI_USERNoYesYesNoNoNoNo
msdbsa130MULTI_USERNoYesYesNoYesYesNo
ReportServerWIN-RJRJ3K27MCH\Administrator130MULTI_USERNoYesYesNoYesNoNo
ReportServerTempDBWIN-RJRJ3K27MCH\Administrator130MULTI_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/A105223550 %30220598.66
BestellabwicklungV11C:BestellabwicklungV11.mdfBestellabwicklungV11_datPRIMARYN/A2572110 MB230526710.38
BestellabwicklungV11C:BestellabwicklungV11.ndfBestellabwicklungV11_idxINDEXN/A1050110 MB30974170.57
CL70085_dbSchulverwaltungSQLF:schul.ldfCL70085_dbSchulverwaltungSQL_logN/A1210610 %310397.17
CL70085_dbSchulverwaltungSQLF:schuleCL70085_dbSchulverwaltungSQLPRIMARYN/A73010 MB696344.66
dbDokumentSQLF:dbDokumentSQL.mdfdbDokumentSQLDBPRIMARYN/A1701 MB1115993.53
dbDokumentSQLF:dbDokumentSQL_1.ldfdbDokumentSQLLOGN/A295510 %15498.18
dbUmfrageSQLF:umfrageNEU.ldfdbUmfrageSQL_logN/A49189210 %161228014.80
dbUmfrageSQLF:umfrageNEU.mdfdbUmfrageSQLPRIMARYN/A130710 MB45884964.96
dbWardenF:dbWarden.mdfdbWardenPRIMARYN/A241 MB51979.17
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 %12796.43
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
tempdbC:tempdb.mdftempdevPRIMARYN/A864 MB3562.50
tempdbC:tempdb_mssql_2.ndftemp2PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_3.ndftemp3PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_4.ndftemp4PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_5.ndftemp5PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_6.ndftemp6PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_7.ndftemp7PRIMARYN/A864 MB08100.00
tempdbC:tempdb_mssql_8.ndftemp8PRIMARYN/A864 MB08100.00
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)750130.000.02
aspvvvnetdb_log.ldf8416.00 (0.41 MB)732.00 (0.03 MB)15040.000.00
BestellabwicklungV11.ldf1081388.00 (1.36 MB)420.00 (0.02 MB)472670.000.01
BestellabwicklungV11.mdf59937560.00 (36.68 MB)18.00 (0.01 MB)579950.040.29
BestellabwicklungV11.ndf181088.00 (1.06 MB)00.00 (0.00 MB)33700.000.01
dbDokumentSQL.mdf613768.00 (3.68 MB)18.00 (0.01 MB)1724140.000.02
dbDokumentSQL_1.ldf321084.00 (1.06 MB)732.00 (0.03 MB)465100.000.01
dbWarden.mdf513120.00 (3.05 MB)18.00 (0.01 MB)128300.000.02
dbWarden_log.ldf12112.00 (0.11 MB)23600.00 (0.59 MB)15346830.000.00
master.mdf633400.00 (3.32 MB)9327464.00 (7.29 MB)23682440.010.08
mastlog.ldf13408.00 (0.40 MB)1074145568.00 (44.50 MB)7433620.040.36
model.mdf369816.00 (9.59 MB)216.00 (0.02 MB)36600.010.07
modellog.ldf9992.00 (0.97 MB)944.00 (0.04 MB)228210.000.01
MSDBData.mdf1459112.00 (8.90 MB)76728.00 (0.71 MB)4001310.010.07
MSDBLog.ldf38468.00 (0.46 MB)165788.00 (0.77 MB)2801870.000.01
ReportServer.mdf794768.00 (4.66 MB)18.00 (0.01 MB)250700.000.03
ReportServer_log.ldf111000.00 (0.98 MB)420.00 (0.02 MB)14100.000.00
ReportServerTempDB.mdf492760.00 (2.70 MB)18.00 (0.01 MB)73600.000.02
ReportServerTempDB_log.ldf7984.00 (0.96 MB)524.00 (0.02 MB)14420.000.00
schul.ldf201208.00 (1.18 MB)332173236.00 (71.52 MB)337629560.070.59
schule116254069824.00 (3974.44 MB)2173356376.00 (348.02 MB)1290109252474.2235.21
tempdb.mdf402240.00 (2.19 MB)13176.00 (0.17 MB)797580.000.02
tempdb_mssql_2.ndf9240.00 (0.23 MB)6160.00 (0.16 MB)8020.000.00
tempdb_mssql_3.ndf9344.00 (0.34 MB)5264.00 (0.26 MB)2730.000.00
tempdb_mssql_4.ndf10288.00 (0.28 MB)5208.00 (0.20 MB)48670.000.00
tempdb_mssql_5.ndf10408.00 (0.40 MB)6328.00 (0.32 MB)5150.000.00
tempdb_mssql_6.ndf10408.00 (0.40 MB)6328.00 (0.32 MB)4060.000.00
tempdb_mssql_7.ndf7280.00 (0.27 MB)4200.00 (0.20 MB)69180.000.00
tempdb_mssql_8.ndf6216.00 (0.21 MB)3136.00 (0.13 MB)5540.000.00
templog.ldf111000.00 (0.98 MB)39821624.00 (21.12 MB)383690.020.18
umfrageNEU.ldf82356413742.00 (6263.42 MB)15837188.00 (7.02 MB)1462673559026.1251.08
umfrageNEU.mdf26721493304.00 (1458.30 MB)1521664.00 (1.63 MB)93188421.4211.89
 
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 MonitoringTrueInProcessJan 16 2017 6:05AM0.000.00
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)]TrueSuccessJan 16 2017 2:00AM0.190.08
 
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
Database Type File Name Backup Set Name Start Date End Date Size (GB) Age (hh)
CL70085_dbSchulverwaltungSQLFullf:\Dropbox\SQL\CL70085_dbSchulverwaltungSQL.bakBackup P.N-StartJan 15 2017 2:05PMJan 15 2017 2:05PM0.6816
 
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
 
Generated on Jan 16 2017 6:05AM with dbWarden v2.5.2
   Gruppenzugehörigkeit: