In every active system, there are running queries during almost every given time frame and their duration affect the system’s performance significantly. The longer the duration of the queries is the worse the system’s performance become, mainly because waiting queries for resources held by running queries are delayed for longer periods of time and that … Continue reading Monitoring long queries