forked from lausser/check_mssql_health
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ChangeLog
229 lines (229 loc) · 9.15 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
* 2023-09-22 2.7.5
update version&changelog for PR#52, thanks tectumopticum
* 2022-08-31 2.7.4
detect recovering mirror databases (requires sa privilege)
* 2022-04-20 2.7.3
leave some time for the first backup of new databases (--mitigation ok=24)
* 2021-08-05 2.7.2.2
bugfix in database-free perfdata
* 2020-12-10 2.7.2.1
Merge pull request #45 from GalipoliX/patch-1, improve a query in availability-mode
* 2020-11-25 2.7.2
database-online is more strict now, restoring is a bad state
* 2020-11-11 2.7.1.2
write a message if no availability groups were found
* 2020-11-10 2.7.1.1
bugfix in availability-group-health
* 2020-11-02 2.7.1
improve availability-group-health, check synchronization_state+health
* 2020-10-26 2.7
Update GLPlugin, commandline parameters can be set as environment variables
* 2020-07-17 2.6.4.17
Merge pull request #42 from ulikl/fix_long_running_jobs
* 2020-04-04 2.6.4.16
fix a bug in is_online()
* 2019-07-17 2.6.4.15
apply filter --nooffline and --notemp to the backup-modes
encrypt password
* 2018-03-22 2.6.4.14
fix a bug in password decoding
* 2018-03-16 2.6.4.13
add db max size as threshold in database-size
* 2017-07-29 2.6.4.12
fix currentdb with a - in the database name
* 2017-05-29 2.6.4.11
update glplugin
* 2017-04-18 2.6.4.10
the same, forgotten to fix it in database-online
* 2017-04-12 2.6.4.9
fix a bug in database-*, is_primary_replica does not exist in sqlsrv 2012
* 2017-02-08 2.6.4.8
ignore alwayson replicas in database-free
* 2016-11-03 2.6.4.7
bugfix in database-free with zero-size filestreams. (Thanks Ivo)
* 2016-09-20 2.6.4.6
ignore database snapshots in database-free
* 2016-08-12 2.6.4.5
fix a bug in database-free (was introduced in 2.6.4.2)
* 2016-08-10 2.6.4.4
added Extraopts to the dist
* 2016-08-05 2.6.4.3
availability-group-health only for primary replica
* 2016-08-03 2.6.4.2
Remove a uninitialized-message in database-free&db-user
* 2016-07-29 2.6.4.1
availability-group-health only for versions >= 11.x
* 2016-07-26 2.6.4
add --mode availability-group-health
* 2016-06-23 2.6.3.1
use AlwaysOn tables only if enabled
* 2016-06-23 2.6.3
fix create-database-user, fix execute error handling
* 2016-06-20 2.6.2.4
update GLPlugin (encode)
cleanup deprecated files
* 2016-06-03 2.6.2.3
update GLPlugin
* 2016-05-11 2.6.2.2
unset syb_flush_finish
use NOLOCK for msdb.dbo.backupset, otherwise selects during backups take too long
* 2016-05-02 2.6.2.1
set syb_flush_finish
* 2016-04-19 2.6.2
let sql statements run into their private timeouts
fix create-monitoring-user
* 2016-04-04 2.6.1
improve backup-age runtime for large number of databases
* 2016-03-23 2.6
add modes database-*free-details, database-filegroup-free, database-file-free
improved calculation of free space
* 2016-02-09 2.5
add glplugin submodule
* 2016-01-27 2.3.1.1
bugfix in backup-age (The multi-part identifier "ar.replica_id" could not be bound). Korinthenkacker!
* 2016-01-27 2.3.1
bugfix in database-modes ("-" in database name)
* 2016-01-24 2.3
add method sqsh and sqlrelay (to redesign)
* 2016-01-24 2.2.2
add sybase database* (to redesign)
* 2016-01-19 2.2.1
fix aps detection
* 2016-01-15 2.2
add aps modes
* 2015-08-10 2.1
add more modes
* 2015-07-13 2.0.3
new directory layout, standalone
* 2015-04-23 2.0.2.1
update GLPlugin[SNMP]
* 2.0.2 2015-01-08
mitigation of stderr and sql errors in sql-runtime is possible
* 2.0.1 2014-10-01
update GLPlugin
* 2.0 2014-07
complete redesign, based on GLPlugin.pm
* 1.5.20.5 2014-06-06
allow mitigation for failed-jobs if no jobs were run
* 1.5.20.4 2014-06-03
add --commit which forces auto-commit on
* 1.5.20.3 2014-04-01
implement --negate old_level=new_level
output also ok-messages for my-modes
allow floating point numbers in thresholds
* 1.5.20.2 2014-02-28
bugfix in transactions. handles databases with auto-close
* 1.5.20.1 2014-01-07
update configure.ac
add mode jobs-enabled (Thanks Thomas Gelf)
* 1.5.20 2013-12-06
handle wrong io_busy and cpu_busy values (hickups of 500% caused by counter overflows
are replaced by the last valid value. if the error persists dirung 5 plugin runs
the obviously wrong value is reported)
* 1.5.19.3 2013-09-11
fix an uninitialized state_desc
* 1.5.19.2 2013-09-06
parameter --notemp is now usable for many modes
* 1.5.19.1 2013-05-27
fixed a bug in batch-requests, which affected case sensitive colletion systems like SAP (Thanks Andreas Seemueller)
* 1.5.19 2013-02-28
rewrote database-free for sybase
* 1.5.18.1 2013-01-22
fixed a bug in sybase database-free
* 1.5.18 2012-01-03
added asciidoc
* 1.5.17 2012-12-20
fixed a bug in database-free for sybase (many thanks to siemens audiologische technik gmbh!!)
* 1.5.16 2012-11-29
fixed a bug in database-free (where the offline state of 1 db was propagated to some others)
implemented all sorts of thresholds
add mode sql-runtime
* 1.5.15.2 2012-11-22
catch generic error-messages
* 1.5.15.1 2012-11-19
catch a "insufficient-rights"-error-message
* 1.5.15 2012-11-16
add parameter mitigation (which can reduce errorlevels for offline databases or dbs which were never backed up)
tracedebug ouputs a bit more information now
* 1.5.14 2012-11-07
database-free can now handle offline databases
add --offlineok
exclude dbs with recovery model simple from database-logbackup-age
* 1.5.13 2012-10-25
add failed-jobs
add database-online
* 1.5.12 2012-10-24
add database-file-auto-growths (and database-logfile-auto-growths, database-datafile-auto-growths)
add database-file-auto-shrinks (and database-logfile-auto-growths, database-datafile-auto-growths)
add database-file-dbcc-shrinks
* 1.5.11 2012-07-05
add selects for cpu-busy to see the return values with -v
add some enhancements writen by Pall Sigurdsson
* 1.5.10 2012-06-27
split database-backup-age to database-backup-age and database-logbackup-age (Thanks Simon Meggle)
fix warnings for newer Perl versions
fix cpu-busy & io-busy
* 1.5.9.3 2012-04-12
fix warnings for newer Perl versions (Thanks Stephan Classen)
* 1.5.9.2 2012-03-15
bugfix in timeout-alarm handling under windows
* 1.5.9.1 2011-09-19
fix a bug in --currentdb (with a "-" in the database name"). (Thanks Markus Stollwerk)
single ticks around the --name argument under Windows CMD will be removed auto matically
* 1.5.9 2011-08-12
fix a bug in save_state for statefilesdirs with capial letters
* 1.5.8.4 2011-06-29
fix a bug in sybase chained transaction handling
* 1.5.8.3 2011-06-03
sites in an OMD (http://omdistro.org) environment have now private statefile directories
fix a bug in extra-opts
conection-time, connected-users, database-free and backup-age can be used with sybase ase 15.x servers
* 1.5.8.2 2011-01-19
output a nicer error message if a sqlrelay connection fails
* 1.5.8.1 2011-01-03
bugfix in --mode sql (numeric vs. regexp result)
* 1.5.8 2010-12-20
mode sql can now have a non-numerical output which is compared to a string/regexp
new parameter --dbthresholds
new mode report can be used to output only the bad news (short,long,html)
* 1.5.7 2010-09-10
fixed a bug in database-free (too much free space was calculated when more than one datafile of a database was on the same filesystem). (Thanks Juergen Essberger)
new parameter extra-opts
* 1.5.6 2010-08-12
new parameter --dbthresholds. thresholds can now also be deposited in the table check_mssql_health_thresholds
added --currentdb so that the plugin can connect to a non-default database
--with-mymodules-dyn-dir on the commandline overrides the configure-option of the same name
* 1.5.5
backup-age is now an alias for the "official" database-backup-age
catch the "can't change context to database" error
--mode sqlcmd
* 1.5.3 2009-11-02
fixed a bug in mode database-free (results are more accurate now)
added new mode backup-age which checks the age (in hours) of the last backup
* 1.5.2
fixed a bug where database names with special characters showed errors. (Thanks Hugh Ranalli)
* 1.5.1 2009-05-26
added --server which can be used instead of --hostname/port (Thanks Mark Monaghan)
lots of fixes. sql server 2000 should now be fully supported. (Thanks Mereghetti Stefano)
--warning/--critical were ignored for memory-pool-related modes (Thanks Mereghetti Stefano)
* 1.5.0.2 2009-05-05
fixed a bug which led to error messages when using the plugin with sql server 2000 (Thanks Christian Mies)
fixed a bug so sql server 2000 can list-databases (Thanks Mereghetti Stefano)
* 1.5.0.1 2009-04-29
added a security advice to the README (Thanks Mathieu Barret)
fixed a bug in database-free (Thanks Michael Luebben)
fixed a typo (Thanks Bernd Staudacher)
* 1.5 - 2009-03-20
rewrote database-free so that unrestricted growth is taken into account (limit is disk)
added support for SQLRelay
* 1.2 - 2009-03-19
added support for object_name <> SQLServer:... (this caused "unable to aquire"-errors sometimes)
fixed a bug in the PNP template
* 1.1 - 2009-03-11
added modes: transactions, latches-wait-time, locks-waits, locks-timeouts,
locks-deadlocks, sql-recompilations, total-server-memory
beautified the PNP template
fixed counter rollovers after database restart
* 1.0 - 2009-03-10
---------------
Initial release