devxlogo

January 30, 2019

Try to avoid -XX:+UseGCLogFileRotation

January 30, 2019

Developers take advantage of the JVM argument -XX:+UseGCLogFileRotation to rotate GC log files. Example: “-XX:+PrintGCDetails -XX:+PrintGCDateStamps -Xloggc:/home/GCEASY/gc.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=20M” As per above example, JVM will rotate GC log file whenever its size reaches 20MB. It will generate files up to 5 files, with extensions gc.log.0, gc.log.1, gc.log.2, gc.log.3, gc.log.4.

Compress and Decompress SQL Functions

January 30, 2019

Compress: Compresses input data and returns the binary data of type VARBINARY(MAX) Decompress: Decompresses compressed input binary data and returns the binary data of type VARBINARY(MAX) Here is small example