Hi, i don't know what you want to monitor. There are MON$ tables for monitoring FB.We are using IBExpert for handling databases, which also has monitoring options (it actually requests data from MON$ tables).There also is performance analysis function and a lot more. What we really do is: create the domains/tables. We write Stored Procedures (SP) for every single action (list, edit, delete, ...) and we never let direct acces to tables. Communiaction is all done through SPs.After the project is finished we analyse every SP (with IBExpert) to see they are performing well (there is a nice graph in IBExpert for this).Then we launch it in production. If new features are developed later, we do them on the development server and after testing we synchronize database structure to production server (IBExpert can also do this) About monitoring, we only monitor database health by an automatic backup-restore procedure (run from cron script) As troubleshooting, if something goes wrong usually the daily backup is the key point...but we had database corruption only once. Then i bought a IBSurgeon's FBfirstAID license for 200 EUR and problem was solved easily.
That's all in short. On Wednesday, November 25, 2015 12:34 PM, "mirco.malag...@ingeniaonline.it [firebird-support]" <firebird-support@yahoogroups.com> wrote: Hello Szilveszter,what is your experience about monitoring, analysis and troubleshooting? Thanks a lot,Mirco #yiv9798980123 #yiv9798980123 -- #yiv9798980123ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9798980123 #yiv9798980123ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9798980123 #yiv9798980123ygrp-mkp #yiv9798980123hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9798980123 #yiv9798980123ygrp-mkp #yiv9798980123ads {margin-bottom:10px;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad {padding:0 0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad p {margin:0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad a {color:#0000ff;text-decoration:none;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc {font-family:Arial;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc #yiv9798980123hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc .yiv9798980123ad {margin-bottom:10px;padding:0 0;}#yiv9798980123 #yiv9798980123actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9798980123 #yiv9798980123activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9798980123 #yiv9798980123activity span {font-weight:700;}#yiv9798980123 #yiv9798980123activity span:first-child {text-transform:uppercase;}#yiv9798980123 #yiv9798980123activity span a {color:#5085b6;text-decoration:none;}#yiv9798980123 #yiv9798980123activity span span {color:#ff7900;}#yiv9798980123 #yiv9798980123activity span .yiv9798980123underline {text-decoration:underline;}#yiv9798980123 .yiv9798980123attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9798980123 .yiv9798980123attach div a {text-decoration:none;}#yiv9798980123 .yiv9798980123attach img {border:none;padding-right:5px;}#yiv9798980123 .yiv9798980123attach label {display:block;margin-bottom:5px;}#yiv9798980123 .yiv9798980123attach label a {text-decoration:none;}#yiv9798980123 blockquote {margin:0 0 0 4px;}#yiv9798980123 .yiv9798980123bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9798980123 .yiv9798980123bold a {text-decoration:none;}#yiv9798980123 dd.yiv9798980123last p a {font-family:Verdana;font-weight:700;}#yiv9798980123 dd.yiv9798980123last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9798980123 dd.yiv9798980123last p span.yiv9798980123yshortcuts {margin-right:0;}#yiv9798980123 div.yiv9798980123attach-table div div a {text-decoration:none;}#yiv9798980123 div.yiv9798980123attach-table {width:400px;}#yiv9798980123 div.yiv9798980123file-title a, #yiv9798980123 div.yiv9798980123file-title a:active, #yiv9798980123 div.yiv9798980123file-title a:hover, #yiv9798980123 div.yiv9798980123file-title a:visited {text-decoration:none;}#yiv9798980123 div.yiv9798980123photo-title a, #yiv9798980123 div.yiv9798980123photo-title a:active, #yiv9798980123 div.yiv9798980123photo-title a:hover, #yiv9798980123 div.yiv9798980123photo-title a:visited {text-decoration:none;}#yiv9798980123 div#yiv9798980123ygrp-mlmsg #yiv9798980123ygrp-msg p a span.yiv9798980123yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9798980123 .yiv9798980123green {color:#628c2a;}#yiv9798980123 .yiv9798980123MsoNormal {margin:0 0 0 0;}#yiv9798980123 o {font-size:0;}#yiv9798980123 #yiv9798980123photos div {float:left;width:72px;}#yiv9798980123 #yiv9798980123photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9798980123 #yiv9798980123photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9798980123 #yiv9798980123reco-category {font-size:77%;}#yiv9798980123 #yiv9798980123reco-desc {font-size:77%;}#yiv9798980123 .yiv9798980123replbq {margin:4px;}#yiv9798980123 #yiv9798980123ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9798980123 #yiv9798980123ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9798980123 #yiv9798980123ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9798980123 #yiv9798980123ygrp-mlmsg select, #yiv9798980123 input, #yiv9798980123 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9798980123 #yiv9798980123ygrp-mlmsg pre, #yiv9798980123 code {font:115% monospace;}#yiv9798980123 #yiv9798980123ygrp-mlmsg * {line-height:1.22em;}#yiv9798980123 #yiv9798980123ygrp-mlmsg #yiv9798980123logo {padding-bottom:10px;}#yiv9798980123 #yiv9798980123ygrp-msg p a {font-family:Verdana;}#yiv9798980123 #yiv9798980123ygrp-msg p#yiv9798980123attach-count span {color:#1E66AE;font-weight:700;}#yiv9798980123 #yiv9798980123ygrp-reco #yiv9798980123reco-head {color:#ff7900;font-weight:700;}#yiv9798980123 #yiv9798980123ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ov li a {font-size:130%;text-decoration:none;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9798980123 #yiv9798980123ygrp-sponsor #yiv9798980123ov ul {margin:0;padding:0 0 0 8px;}#yiv9798980123 #yiv9798980123ygrp-text {font-family:Georgia;}#yiv9798980123 #yiv9798980123ygrp-text p {margin:0 0 1em 0;}#yiv9798980123 #yiv9798980123ygrp-text tt {font-size:120%;}#yiv9798980123 #yiv9798980123ygrp-vital ul li:last-child {border-right:none !important;}#yiv9798980123