Post reply

dbWarden - A Free SQL Server Monitoring Package

  • April 15, 2013 at 3:51 pm

    #1606640

    This looks very great, but it doesn't seem to work on my systems.

    @@Version

    Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

    Feb 10 2012 19:39:15

    Copyright (c) Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I get a number of errors which seem to boil down to not being able to confirm that fields exist

    Here are the results of running the script:

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 32

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 69

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 58

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 60

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 61

    Invalid column name 'Blocked_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 62

    Invalid column name 'Blocked_Login'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 63

    Invalid column name 'Blocked_SQL_Text'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 64

    Invalid column name 'Blocking_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 65

    Invalid column name 'Offending_Login'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 66

    Invalid column name 'Offending_SQL_Text'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 89

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 95

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'OFFENDING_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'OFFENDING_LOGIN'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 114

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'OFFENDING_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'OFFENDING_LOGIN'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 2714, Level 16, State 6, Line 6

    There is already an object named '#TEMP' in the database.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 65

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 68

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 75

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'Category'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 34

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 35

    Invalid column name 'Category'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 36

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 56

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 57

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 58

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 77

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'BufferCacheHitRatio'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'PageLifeExpectency'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'BatchRequestsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'CompilationsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'ReCompilationsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'UserConnections'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'LockWaitsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'PageSplitsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'ProcessesBlocked'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'CheckpointPagesPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'StatDate'.

    Msg 207, Level 16, State 1, Procedure usp_MemoryUsageStats, Line 76

    Invalid column name 'DBUsageMB'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 41

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 41

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 65

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 65

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 60

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 61

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 62

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 63

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 81

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 87

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 106

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsHistoryId'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsDateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'StartTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'StopTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 73

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 74

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 74

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 75

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 76

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 77

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsHistoryId'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsDateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'StartTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'StopTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'QueryHistoryID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'login_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'CPU'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'physical_reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'host_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'program_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 95

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 96

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 96

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 97

    Invalid column name 'Session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 99

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 100

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'QueryHistoryID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'login_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'CPU'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'physical_reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'host_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'program_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'Session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 60

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 60

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 61

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 61

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 62

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 62

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 63

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 64

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 65

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 65

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 85

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 85

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 86

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 86

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 87

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 87

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 88

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 89

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 89

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 143

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 143

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 144

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 144

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 145

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 145

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 146

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 147

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 148

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 148

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 258

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 258

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 259

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 259

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 260

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 260

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 261

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 262

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 263

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 263

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 281

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 281

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 282

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 282

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 283

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 283

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 284

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 285

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 285

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 338

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 338

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 339

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 339

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 340

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 340

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 341

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 342

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 343

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 343

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FilePercentEmpty'.

    DATA DICTIONARY: 0 tables & 0 fields added

    DOCUMENTED TABLE: AlertSettings

    DOCUMENTED TABLE: BlockingHistory

    DOCUMENTED TABLE: CPUStatsHistory

    DOCUMENTED TABLE: DatabaseSettings

    DOCUMENTED TABLE: DataDictionary_Fields

    DOCUMENTED TABLE: DataDictionary_Tables

    DOCUMENTED TABLE: FileStatsHistory

    DOCUMENTED TABLE: HealthReport

    DOCUMENTED TABLE: JobStatsHistory

    DOCUMENTED TABLE: MemoryUsageHistory

    DOCUMENTED TABLE: PerfStatsHistory

    DOCUMENTED TABLE: QueryHistory

    DOCUMENTED FIELD: AlertSettings.CellList

    DOCUMENTED FIELD: AlertSettings.EmailList

    DOCUMENTED FIELD: AlertSettings.EmailList2

    DOCUMENTED FIELD: AlertSettings.Name

    DOCUMENTED FIELD: AlertSettings.QueryValue

    DOCUMENTED FIELD: AlertSettings.QueryValue2

    DOCUMENTED FIELD: AlertSettings.QueryValue2Desc

    DOCUMENTED FIELD: AlertSettings.QueryValueDesc

    DOCUMENTED FIELD: BlockingHistory.Blocked_HostName

    DOCUMENTED FIELD: BlockingHistory.Blocked_LastWaitType

    DOCUMENTED FIELD: BlockingHistory.Blocked_Login

    DOCUMENTED FIELD: BlockingHistory.Blocked_Program

    DOCUMENTED FIELD: BlockingHistory.Blocked_SPID

    DOCUMENTED FIELD: BlockingHistory.Blocked_SQL_Text

    DOCUMENTED FIELD: BlockingHistory.Blocked_Status

    DOCUMENTED FIELD: BlockingHistory.Blocked_WaitTime_Seconds

    DOCUMENTED FIELD: BlockingHistory.Blocking_SPID

    DOCUMENTED FIELD: BlockingHistory.BlockingHistoryID

    DOCUMENTED FIELD: BlockingHistory.DateStamp

    DOCUMENTED FIELD: BlockingHistory.DBName

    DOCUMENTED FIELD: BlockingHistory.Offending_HostName

    DOCUMENTED FIELD: BlockingHistory.Offending_LastWaitType

    DOCUMENTED FIELD: BlockingHistory.Offending_Login

    DOCUMENTED FIELD: BlockingHistory.Offending_NTUser

    DOCUMENTED FIELD: BlockingHistory.Offending_Program

    DOCUMENTED FIELD: BlockingHistory.Offending_SPID

    DOCUMENTED FIELD: BlockingHistory.Offending_SQL_Text

    DOCUMENTED FIELD: BlockingHistory.Offending_Status

    DOCUMENTED FIELD: BlockingHistory.Offending_WaitType

    DOCUMENTED FIELD: CPUStatsHistory.CPUStatsHistoryID

    DOCUMENTED FIELD: CPUStatsHistory.DateStamp

    DOCUMENTED FIELD: CPUStatsHistory.OtherProcessPerecnt

    DOCUMENTED FIELD: CPUStatsHistory.SQLProcessPercent

    DOCUMENTED FIELD: CPUStatsHistory.SystemIdleProcessPercent

    DOCUMENTED FIELD: DatabaseSettings.DBName

    DOCUMENTED FIELD: DatabaseSettings.LogFileAlerts

    DOCUMENTED FIELD: DatabaseSettings.LongQueryAlerts

    DOCUMENTED FIELD: DatabaseSettings.Reindex

    DOCUMENTED FIELD: DatabaseSettings.SchemaTracking

    DOCUMENTED FIELD: DataDictionary_Fields.FieldDescription

    DOCUMENTED FIELD: DataDictionary_Fields.FieldName

    DOCUMENTED FIELD: DataDictionary_Fields.SchemaName

    DOCUMENTED FIELD: DataDictionary_Fields.TableName

    DOCUMENTED FIELD: DataDictionary_Tables.SchemaName

    DOCUMENTED FIELD: DataDictionary_Tables.TableDescription

    DOCUMENTED FIELD: DataDictionary_Tables.TableName

    DOCUMENTED FIELD: FileStatsHistory.DBName

    DOCUMENTED FIELD: FileStatsHistory.DriveLetter

    DOCUMENTED FIELD: FileStatsHistory.FileGrowth

    DOCUMENTED FIELD: FileStatsHistory.FileMBEmpty

    DOCUMENTED FIELD: FileStatsHistory.FileMBSize

    DOCUMENTED FIELD: FileStatsHistory.FileMBUsed

    DOCUMENTED FIELD: FileStatsHistory.FileName

    DOCUMENTED FIELD: FileStatsHistory.FilePercentEmpty

    DOCUMENTED FIELD: FileStatsHistory.FileStatsDateStamp

    DOCUMENTED FIELD: FileStatsHistory.FileStatsHistoryID

    DOCUMENTED FIELD: FileStatsHistory.FileStatsID

    DOCUMENTED FIELD: HealthReport.DateStamp

    DOCUMENTED FIELD: HealthReport.GeneratedHTML

    DOCUMENTED FIELD: HealthReport.HealthReportID

    DOCUMENTED FIELD: JobStatsHistory.AvgRunTime

    DOCUMENTED FIELD: JobStatsHistory.Category

    DOCUMENTED FIELD: JobStatsHistory.Enabled

    DOCUMENTED FIELD: JobStatsHistory.JobName

    DOCUMENTED FIELD: JobStatsHistory.JobStatsDateStamp

    DOCUMENTED FIELD: JobStatsHistory.JobStatsHistoryId

    DOCUMENTED FIELD: JobStatsHistory.JobStatsID

    DOCUMENTED FIELD: JobStatsHistory.LastRunOutcome

    DOCUMENTED FIELD: JobStatsHistory.LastRunTime

    DOCUMENTED FIELD: JobStatsHistory.RunTimeStatus

    DOCUMENTED FIELD: JobStatsHistory.StartTime

    DOCUMENTED FIELD: JobStatsHistory.StopTime

    DOCUMENTED FIELD: MemoryUsageHistory.BufferCacheHitRatio

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPageLifeExpectancy

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolCommitMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolCommitTgtMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolDataPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolFreePagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolPlanCachePagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolReservedPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolStolenPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolTotalPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.CursorUsageMB

    DOCUMENTED FIELD: MemoryUsageHistory.DateStamp

    DOCUMENTED FIELD: MemoryUsageHistory.DBMemoryRequiredMB

    DOCUMENTED FIELD: MemoryUsageHistory.DBUsageMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemConnectionsMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemHashSortIndexMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemLocksMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemQueryOptimizeMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemSQLCacheMB

    DOCUMENTED FIELD: MemoryUsageHistory.MemoryUsageHistoryID

    DOCUMENTED FIELD: MemoryUsageHistory.SystemPhysicalMemoryMB

    DOCUMENTED FIELD: MemoryUsageHistory.SystemVirtualMemoryMB

    DOCUMENTED FIELD: PerfStatsHistory.BatchRequestsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.BufferCacheHitRatio

    DOCUMENTED FIELD: PerfStatsHistory.CheckpointPagesPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.CompilationsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.LockWaitsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.PageLifeExpectency

    DOCUMENTED FIELD: PerfStatsHistory.PageSplitsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.PerfStatsHistoryID

    DOCUMENTED FIELD: PerfStatsHistory.ProcessesBlocked

    DOCUMENTED FIELD: PerfStatsHistory.ReCompilationsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.StatDate

    DOCUMENTED FIELD: PerfStatsHistory.UserConnections

    DOCUMENTED FIELD: QueryHistory.Collection_Time

    DOCUMENTED FIELD: QueryHistory.CPU

    DOCUMENTED FIELD: QueryHistory.Database_Name

    DOCUMENTED FIELD: QueryHistory.Host_Name

    DOCUMENTED FIELD: QueryHistory.Login_Name

    DOCUMENTED FIELD: QueryHistory.Login_Time

    DOCUMENTED FIELD: QueryHistory.Physical_Reads

    DOCUMENTED FIELD: QueryHistory.Program_Name

    DOCUMENTED FIELD: QueryHistory.QueryHistoryID

    DOCUMENTED FIELD: QueryHistory.Reads

    DOCUMENTED FIELD: QueryHistory.Session_ID

    DOCUMENTED FIELD: QueryHistory.SQL_Text

    DOCUMENTED FIELD: QueryHistory.Start_Time

    DOCUMENTED FIELD: QueryHistory.Writes[/Code]

  • April 15, 2013 at 3:58 pm

    #1606644

    ShawnTherrien (4/15/2013)

    I get a number of errors which seem to boil down to not being able to confirm that fields exist

    Here are the results of running the script:

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 32

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 69

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 58

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 60

    Invalid column name 'Blocked_WaitTime_Seconds'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 61

    Invalid column name 'Blocked_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 62

    Invalid column name 'Blocked_Login'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 63

    Invalid column name 'Blocked_SQL_Text'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 64

    Invalid column name 'Blocking_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 65

    Invalid column name 'Offending_Login'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 66

    Invalid column name 'Offending_SQL_Text'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 89

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 95

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'OFFENDING_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'OFFENDING_LOGIN'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 93

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 114

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'OFFENDING_SPID'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'OFFENDING_LOGIN'.

    Msg 207, Level 16, State 1, Procedure ti_blockinghistory, Line 112

    Invalid column name 'BLOCKED_WAITTIME_SECONDS'.

    Msg 2714, Level 16, State 6, Line 6

    There is already an object named '#TEMP' in the database.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 65

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 68

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 75

    Invalid column name 'job_id'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'Category'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 76

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 34

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 35

    Invalid column name 'Category'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 36

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 56

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 57

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 58

    Invalid column name 'last_run_outcome'.

    Msg 207, Level 16, State 1, Procedure usp_JobStats, Line 77

    Invalid column name 'name'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'BufferCacheHitRatio'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'PageLifeExpectency'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'BatchRequestsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'CompilationsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'ReCompilationsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'UserConnections'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'LockWaitsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'PageSplitsPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'ProcessesBlocked'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'CheckpointPagesPerSecond'.

    Msg 207, Level 16, State 1, Procedure usp_PerfStats, Line 175

    Invalid column name 'StatDate'.

    Msg 207, Level 16, State 1, Procedure usp_MemoryUsageStats, Line 76

    Invalid column name 'DBUsageMB'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 37

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUStats, Line 60

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 41

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 41

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 65

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 65

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 60

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 61

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 62

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 63

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 81

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 87

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 86

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 106

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'SQLProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'SystemIdleProcessPercent'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'OtherProcessPerecnt'.

    Msg 207, Level 16, State 1, Procedure usp_CPUProcessAlert, Line 104

    Invalid column name 'DateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsHistoryId'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobStatsDateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'StartTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'StopTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 46

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 73

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 74

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 74

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 75

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 76

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 77

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsHistoryId'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobStatsDateStamp'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'Enabled'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'StartTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'StopTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'RunTimeStatus'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 97

    Invalid column name 'LastRunOutcome'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'JobName'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'AvgRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningJobs, Line 111

    Invalid column name 'LastRunTime'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'QueryHistoryID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'login_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'CPU'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'physical_reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'host_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 58

    Invalid column name 'program_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 95

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 96

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 96

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 97

    Invalid column name 'Session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 99

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 100

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'QueryHistoryID'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'login_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'CPU'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'writes'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'physical_reads'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'host_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'sql_text'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 120

    Invalid column name 'program_name'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'start_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'collection_time'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'Session_id'.

    Msg 207, Level 16, State 1, Procedure usp_LongRunningQueries, Line 140

    Invalid column name 'login_name'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 60

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 60

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 61

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 61

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 62

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 62

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 63

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 64

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 65

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 65

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 56

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 85

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 85

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 86

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 86

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 87

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 87

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 88

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 89

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 89

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 81

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 143

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 143

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 144

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 144

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 145

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 145

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 146

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 147

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 148

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 148

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 139

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 258

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 258

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 259

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 259

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 260

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 260

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 261

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 262

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 263

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 263

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 254

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 281

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 281

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 282

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 282

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 283

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 283

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 284

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 285

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 285

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 277

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 338

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 338

    Invalid column name 'FileName'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 339

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 339

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 340

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 340

    Invalid column name 'FileStatsID'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 341

    Invalid column name 'FilePercentEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 342

    Invalid column name 'Filename'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 343

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 343

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBSize'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBUsed'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FileMBEmpty'.

    Msg 207, Level 16, State 1, Procedure usp_CheckFiles, Line 334

    Invalid column name 'FilePercentEmpty'.

    DATA DICTIONARY: 0 tables & 0 fields added

    DOCUMENTED TABLE: AlertSettings

    DOCUMENTED TABLE: BlockingHistory

    DOCUMENTED TABLE: CPUStatsHistory

    DOCUMENTED TABLE: DatabaseSettings

    DOCUMENTED TABLE: DataDictionary_Fields

    DOCUMENTED TABLE: DataDictionary_Tables

    DOCUMENTED TABLE: FileStatsHistory

    DOCUMENTED TABLE: HealthReport

    DOCUMENTED TABLE: JobStatsHistory

    DOCUMENTED TABLE: MemoryUsageHistory

    DOCUMENTED TABLE: PerfStatsHistory

    DOCUMENTED TABLE: QueryHistory

    DOCUMENTED FIELD: AlertSettings.CellList

    DOCUMENTED FIELD: AlertSettings.EmailList

    DOCUMENTED FIELD: AlertSettings.EmailList2

    DOCUMENTED FIELD: AlertSettings.Name

    DOCUMENTED FIELD: AlertSettings.QueryValue

    DOCUMENTED FIELD: AlertSettings.QueryValue2

    DOCUMENTED FIELD: AlertSettings.QueryValue2Desc

    DOCUMENTED FIELD: AlertSettings.QueryValueDesc

    DOCUMENTED FIELD: BlockingHistory.Blocked_HostName

    DOCUMENTED FIELD: BlockingHistory.Blocked_LastWaitType

    DOCUMENTED FIELD: BlockingHistory.Blocked_Login

    DOCUMENTED FIELD: BlockingHistory.Blocked_Program

    DOCUMENTED FIELD: BlockingHistory.Blocked_SPID

    DOCUMENTED FIELD: BlockingHistory.Blocked_SQL_Text

    DOCUMENTED FIELD: BlockingHistory.Blocked_Status

    DOCUMENTED FIELD: BlockingHistory.Blocked_WaitTime_Seconds

    DOCUMENTED FIELD: BlockingHistory.Blocking_SPID

    DOCUMENTED FIELD: BlockingHistory.BlockingHistoryID

    DOCUMENTED FIELD: BlockingHistory.DateStamp

    DOCUMENTED FIELD: BlockingHistory.DBName

    DOCUMENTED FIELD: BlockingHistory.Offending_HostName

    DOCUMENTED FIELD: BlockingHistory.Offending_LastWaitType

    DOCUMENTED FIELD: BlockingHistory.Offending_Login

    DOCUMENTED FIELD: BlockingHistory.Offending_NTUser

    DOCUMENTED FIELD: BlockingHistory.Offending_Program

    DOCUMENTED FIELD: BlockingHistory.Offending_SPID

    DOCUMENTED FIELD: BlockingHistory.Offending_SQL_Text

    DOCUMENTED FIELD: BlockingHistory.Offending_Status

    DOCUMENTED FIELD: BlockingHistory.Offending_WaitType

    DOCUMENTED FIELD: CPUStatsHistory.CPUStatsHistoryID

    DOCUMENTED FIELD: CPUStatsHistory.DateStamp

    DOCUMENTED FIELD: CPUStatsHistory.OtherProcessPerecnt

    DOCUMENTED FIELD: CPUStatsHistory.SQLProcessPercent

    DOCUMENTED FIELD: CPUStatsHistory.SystemIdleProcessPercent

    DOCUMENTED FIELD: DatabaseSettings.DBName

    DOCUMENTED FIELD: DatabaseSettings.LogFileAlerts

    DOCUMENTED FIELD: DatabaseSettings.LongQueryAlerts

    DOCUMENTED FIELD: DatabaseSettings.Reindex

    DOCUMENTED FIELD: DatabaseSettings.SchemaTracking

    DOCUMENTED FIELD: DataDictionary_Fields.FieldDescription

    DOCUMENTED FIELD: DataDictionary_Fields.FieldName

    DOCUMENTED FIELD: DataDictionary_Fields.SchemaName

    DOCUMENTED FIELD: DataDictionary_Fields.TableName

    DOCUMENTED FIELD: DataDictionary_Tables.SchemaName

    DOCUMENTED FIELD: DataDictionary_Tables.TableDescription

    DOCUMENTED FIELD: DataDictionary_Tables.TableName

    DOCUMENTED FIELD: FileStatsHistory.DBName

    DOCUMENTED FIELD: FileStatsHistory.DriveLetter

    DOCUMENTED FIELD: FileStatsHistory.FileGrowth

    DOCUMENTED FIELD: FileStatsHistory.FileMBEmpty

    DOCUMENTED FIELD: FileStatsHistory.FileMBSize

    DOCUMENTED FIELD: FileStatsHistory.FileMBUsed

    DOCUMENTED FIELD: FileStatsHistory.FileName

    DOCUMENTED FIELD: FileStatsHistory.FilePercentEmpty

    DOCUMENTED FIELD: FileStatsHistory.FileStatsDateStamp

    DOCUMENTED FIELD: FileStatsHistory.FileStatsHistoryID

    DOCUMENTED FIELD: FileStatsHistory.FileStatsID

    DOCUMENTED FIELD: HealthReport.DateStamp

    DOCUMENTED FIELD: HealthReport.GeneratedHTML

    DOCUMENTED FIELD: HealthReport.HealthReportID

    DOCUMENTED FIELD: JobStatsHistory.AvgRunTime

    DOCUMENTED FIELD: JobStatsHistory.Category

    DOCUMENTED FIELD: JobStatsHistory.Enabled

    DOCUMENTED FIELD: JobStatsHistory.JobName

    DOCUMENTED FIELD: JobStatsHistory.JobStatsDateStamp

    DOCUMENTED FIELD: JobStatsHistory.JobStatsHistoryId

    DOCUMENTED FIELD: JobStatsHistory.JobStatsID

    DOCUMENTED FIELD: JobStatsHistory.LastRunOutcome

    DOCUMENTED FIELD: JobStatsHistory.LastRunTime

    DOCUMENTED FIELD: JobStatsHistory.RunTimeStatus

    DOCUMENTED FIELD: JobStatsHistory.StartTime

    DOCUMENTED FIELD: JobStatsHistory.StopTime

    DOCUMENTED FIELD: MemoryUsageHistory.BufferCacheHitRatio

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPageLifeExpectancy

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolCommitMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolCommitTgtMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolDataPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolFreePagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolPlanCachePagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolReservedPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolStolenPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.BufferPoolTotalPagesMB

    DOCUMENTED FIELD: MemoryUsageHistory.CursorUsageMB

    DOCUMENTED FIELD: MemoryUsageHistory.DateStamp

    DOCUMENTED FIELD: MemoryUsageHistory.DBMemoryRequiredMB

    DOCUMENTED FIELD: MemoryUsageHistory.DBUsageMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemConnectionsMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemHashSortIndexMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemLocksMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemQueryOptimizeMB

    DOCUMENTED FIELD: MemoryUsageHistory.DynamicMemSQLCacheMB

    DOCUMENTED FIELD: MemoryUsageHistory.MemoryUsageHistoryID

    DOCUMENTED FIELD: MemoryUsageHistory.SystemPhysicalMemoryMB

    DOCUMENTED FIELD: MemoryUsageHistory.SystemVirtualMemoryMB

    DOCUMENTED FIELD: PerfStatsHistory.BatchRequestsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.BufferCacheHitRatio

    DOCUMENTED FIELD: PerfStatsHistory.CheckpointPagesPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.CompilationsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.LockWaitsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.PageLifeExpectency

    DOCUMENTED FIELD: PerfStatsHistory.PageSplitsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.PerfStatsHistoryID

    DOCUMENTED FIELD: PerfStatsHistory.ProcessesBlocked

    DOCUMENTED FIELD: PerfStatsHistory.ReCompilationsPerSecond

    DOCUMENTED FIELD: PerfStatsHistory.StatDate

    DOCUMENTED FIELD: PerfStatsHistory.UserConnections

    DOCUMENTED FIELD: QueryHistory.Collection_Time

    DOCUMENTED FIELD: QueryHistory.CPU

    DOCUMENTED FIELD: QueryHistory.Database_Name

    DOCUMENTED FIELD: QueryHistory.Host_Name

    DOCUMENTED FIELD: QueryHistory.Login_Name

    DOCUMENTED FIELD: QueryHistory.Login_Time

    DOCUMENTED FIELD: QueryHistory.Physical_Reads

    DOCUMENTED FIELD: QueryHistory.Program_Name

    DOCUMENTED FIELD: QueryHistory.QueryHistoryID

    DOCUMENTED FIELD: QueryHistory.Reads

    DOCUMENTED FIELD: QueryHistory.Session_ID

    DOCUMENTED FIELD: QueryHistory.SQL_Text

    DOCUMENTED FIELD: QueryHistory.Start_Time

    DOCUMENTED FIELD: QueryHistory.Writes[/Code]

    I've seen errors like that when I try to run the script more than once in a single query window. There is something funky going on with how the trigger is created on the BlockingHistory table.

    Give that a try and let me know if it works.

  • April 15, 2013 at 4:40 pm

    #1606651

    HealthReport Job Failed - overflow converting to int.

    Not sure which of these in the "d" set is the offender - changed them all to bigint for belts and braces:

    UPDATE c

    SET c.NumberReads = d.NumberReads,

    c.KBytesRead = d.KBytesRead,

    c.NumberWrites = d.NumberWrites,

    c.KBytesWritten = d.KBytesWritten,

    c.IoStallReadMS = d.IoStallReadMS,

    c.IoStallWriteMS = d.IoStallWriteMS,

    c.Cum_IO_GB = d.Cum_IO_GB

    FROM #FILESTATS c

    LEFT OUTER

    JOIN (SELECT

    b.dbname,

    b.[FileName],

    SUM(CAST(b.NumberReads AS bigint) - CAST(a.NumberReads AS bigint)) AS NumberReads,

    SUM(b.KBytesRead - a.KBytesRead) AS KBytesRead,

    SUM(CAST(b.NumberWrites AS bigint) - CAST(a.NumberWrites AS bigint)) AS NumberWrites,

    SUM(b.KBytesWritten - a.KBytesWritten) AS KBytesWritten,

    SUM(CAST(b.IoStallReadMS AS bigint) - CAST(a.IoStallReadMS AS bigint)) AS IoStallReadMS,

    SUM(CAST(b.IoStallWriteMS AS bigint) - CAST(a.IoStallWriteMS AS bigint)) AS IoStallWriteMS,

    SUM(b.Cum_IO_GB - a.Cum_IO_GB) AS Cum_IO_GB

    FROM [DBWarden].dbo.FileStatsHistory a

    LEFT OUTER

    JOIN #FILESTATS b

    ON a.dbname = b.dbname

    AND a.[FileName] = b.[FileName]

    WHERE a.FileStatsDateStamp = @MinFileStatsDateStamp

    GROUP BY b.DBName,b.[FileName]) d

    ON c.dbname = d.dbname

    AND c.[FileName] = d.[FileName]

  • April 15, 2013 at 4:48 pm

    #1606653

    Thanks SAinCA! There is an updated script on the SourceForge page that contains this fix.

    There are a few other fixes in this update as well. All the gen_Get* stored procs were removed as I found some differences in how BCP behaves in SQL 2012 (none of the procs work in 2012).

  • April 15, 2013 at 5:04 pm

    #1606657

    michaelrounds (4/15/2013)

    Thanks SAinCA! There is an updated script on the SourceForge page that contains this fix.

    There are a few other fixes in this update as well. All the gen_Get* stored procs were removed as I found some differences in how BCP behaves in SQL 2012 (none of the procs work in 2012).

    Thanks, Michael. Must admit, your HTML is far prettier than my amateur attempts. Not sure if it will render with IE6, which some of our slow-moving customers still have, and how Lotus Notes will deal with it, but it's a great look.

    Due to a very poor design, the DB that threw the file stats error uses over 40GB of read-write in a day - crazy!

    Last thought (for today): could you consider some flexibility in the number of characters each Blocking and Victim cell shows, please? It's set at LEFT(<SQL>,100) at present, which truncates the important text because the parameters are listed first, thus the SP or inline SQL is missed. I took out the LEFT() entirely in favor of seeing everything irrespective.

    Cheers!

  • April 15, 2013 at 5:11 pm

    #1606660

    michaelrounds (4/15/2013)

    I've seen errors like that when I try to run the script more than once in a single query window. There is something funky going on with how the trigger is created on the BlockingHistory table.

    Give that a try and let me know if it works.

    Worked. 😀

    Every object creation/alter giving me those errors, I broke out into it's own window and it worked fine alone. Wouldn't even work in the main script if I highlighted and just ran specific code.

  • April 16, 2013 at 10:59 am

    #1606924

    Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.

    Thanks.

  • April 16, 2013 at 11:11 am

    #1606935

    Looks like everything but the longest running jobs are working. I got my first daily health check email.

    My only feedback for what I'm seeing so far is that it would be great to add some filters in the HTML. Maybe "Show All" and "Show Problems" or maybe just loading all of the problem data up front and having a full listing after all of the problem data has been shown.

    I mean it's great. I just set this up on a dev box with like 30 databases and the email was pages long. Not a deal breaker, but my first thoughts are how this would scale with 10 servers.

    I also had to modify the Long Running Query QueryText on the email to get something meaningful that I could work with. The first xxx characters to the left weren't helpful in this case other than just alerting me that there was a problem with something. Still that was helpful 🙂

  • April 16, 2013 at 11:21 am

    #1606939

    SAinCA (4/16/2013)

    Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.

    Thanks.

    If the CellList field is NULL in AlertSettings, you should stop getting the text alerts.

  • April 16, 2013 at 11:28 am

    #1606943

    ShawnTherrien (4/16/2013)

    Looks like everything but the longest running jobs are working. I got my first daily health check email.

    My only feedback for what I'm seeing so far is that it would be great to add some filters in the HTML. Maybe "Show All" and "Show Problems" or maybe just loading all of the problem data up front and having a full listing after all of the problem data has been shown.

    I mean it's great. I just set this up on a dev box with like 30 databases and the email was pages long. Not a deal breaker, but my first thoughts are how this would scale with 10 servers.

    I also had to modify the Long Running Query QueryText on the email to get something meaningful that I could work with. The first xxx characters to the left weren't helpful in this case other than just alerting me that there was a problem with something. Still that was helpful 🙂

    What's not working with the long running jobs? Are you getting an error?

  • April 16, 2013 at 12:09 pm

    #1606966

    michaelrounds (4/16/2013)

    SAinCA (4/16/2013)

    Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.

    Thanks.

    If the CellList field is NULL in AlertSettings, you should stop getting the text alerts.

    Great - just what I needed. Thanks.

  • April 16, 2013 at 1:00 pm

    #1607005

    I'm still struggling with the Health Report. I see now that every time the job runs, I get an email. That was being sent out all along but was going to my junkmail. (How dumb is Outlook that an email from MY HOME DOMAIN gets sent to junk??). So every time I run dba_HelathReport > Start Job at Step I get the email.

    Trouble is, the email is blank, not a thing in it, which makes sense since I still see

    SELECT [GeneratedHTML] FROM [dba].[dbo].[HealthReport] order by DateStamp desc

    NULL

    NULL

    NULL

    NULL

    I am pretty sure if I get HTML to generate then it will be in the email and I will be all set.

    Has anyone else run into this or have an idea?

  • April 16, 2013 at 1:48 pm

    #1607027

    I'm now running this in a production environment on 8 servers. I have some suggested fixes for you

  • Expand [Filename] to NVARCHAR(255) when creating table #BACKUPS. I have some long database names leading to long backup paths and with nvarchar(128) the stored procedure was reporting an error due to truncation.
  • Personally, I would have stored FileMBSize as an int in table FileStatsHistory, but you have it as nvarchar. Thus, you need to Cast to an int when performing comparisons. In usp_CheckFiles the code selects from FileStatsHistory into #TEMP and leaves FileMBSize as nvarchar. Then you perform a comparison of "t.FileMBSize < t2.FileMBSize" and that ends up comparing a text value to a numeric value, which results in incorrect results (I was receiving e-mails saying a log file had grown when instead it had shrunk; very perplexing). The solution I went with was to explicitly define #TEMP before creating it, though another option would be to perform the cast on FileMBSize when implicitly creating #TEMP or even to add a cast in tht comparison query looking for FileMBSize increasing.
  • Also in usp_CheckFiles, you are excluding tables 'model' and 'tempdb' (which is the correct logic). However, those table names are stored in FileStatsHistory as '[model]' and '[tempdb]' so your IN clauses need to have "NOT IN ('model','tempdb','[model]','[tempdb]')". Furthermore, population of #TEMP3 in that procedure needs "IN ('tempdb','[tempdb]')"
  • My log files commonly grow, so I chose to update usp_CheckFiles to ignore log files less than 200 MB in size. This could potentially be an option if you add an options table
  • I have a long-running sql backup job that runs using RedGate's Sql Backup and runs via a stored procedure. Thus, I chose to create an AlertExclusions table with two columns: Category_Name and FilterLikeClause. Category_Name has a foreign key relationship to AlertSettings.Category_Name. The Alert Settings table has one row with values 'LongRunningQueries' and 'sqlBackup'. I then updated usp_LongRunningQueries to left outer join to my Alert Exclusions table and filter, like this:

    • SELECT QueryHistoryID, collection_time, start_time, login_time, session_id, CPU, reads, writes, physical_reads, [host_name], [Database_Name], login_name, sql_text, [program_name]

    FROM [dba].dbo.QueryHistory QH

    LEFT OUTER JOIN [dba].dbo.T_Alert_Exclusions AlertEx

    ON AlertEx.Category_Name = 'LongRunningQueries' AND QH.sql_text LIKE AlertEx.FilterLikeClause

    WHERE (DATEDIFF(ss,start_time,collection_time)) >= @QueryValue

    AND (DATEDIFF(mi,collection_time,GETDATE())) < (DATEDIFF(mi,@LastCollectionTime, collection_time))

    AND [Database_Name] NOT IN (SELECT [DBName] FROM [dba].dbo.DatabaseSettings WHERE LongQueryAlerts = 0)

    AND sql_text NOT LIKE 'BACKUP DATABASE%'

    AND sql_text NOT LIKE 'RESTORE VERIFYONLY%'

    AND sql_text NOT LIKE 'ALTER INDEX%'

    AND sql_text NOT LIKE 'DECLARE @BlobEater%'

    AND sql_text NOT LIKE 'DBCC%'

    AND sql_text NOT LIKE 'WAITFOR(RECEIVE%'

    AND AlertEx.Category_Name Is Null

  • I updated usp_LongRunningQueries to make the following change just in case somebody enters a blank value in the CellList column instead of a null value. It would be good to make this change whereever an e-mail and/or cell info is being retrieved from the AlertSettings table

    • -- Change from

    If @CellList Is Not Null

    -- To

    If IsNull(@CellList, '') <> ''

  • April 16, 2013 at 3:00 pm

    #1607054

    gkiss 73362 (4/16/2013)

    I'm still struggling with the Health Report. I see now that every time the job runs, I get an email. That was being sent out all along but was going to my junkmail. (How dumb is Outlook that an email from MY HOME DOMAIN gets sent to junk??). So every time I run dba_HelathReport > Start Job at Step I get the email.

    Trouble is, the email is blank, not a thing in it, which makes sense since I still see

    SELECT [GeneratedHTML] FROM [dba].[dbo].[HealthReport] order by DateStamp desc

    NULL

    NULL

    NULL

    NULL

    I am pretty sure if I get HTML to generate then it will be in the email and I will be all set.

    Has anyone else run into this or have an idea?

    When that happens, it's usually because of a NULL value in a result set (missing COALESCE) during the HTML generation part of the proc. The latest update of dbWarden (latest version is 2.3.3 as noted in the comments at the top of the file) was an attempt at fixing these issues.

  • April 16, 2013 at 3:45 pm

    #1607069

    michaelrounds (4/16/2013)

    What's not working with the long running jobs? Are you getting an error?

    Ahh, it "was":

    Message

    Executed as user: NT SERVICE\SQLAgent$WEEKLY. Procedure usp_JobStats has no parameters and arguments were supplied. [SQLSTATE 42000] (Error 8146). The step failed.

    But I grabbed the new script you put out in the last day. That cleared this up the job issue. It also cleared up the errors I was getting yesterday with the multiple alter statements in the same query window 🙂

    • Viewing 15 posts - 46 through 60 (of 186 total)

    You must be logged in to reply to this topic. Login to reply