Thanks!

i will try that

thanks.

about the memory we tried to increase it to almost 20GB that didnt solve the issue.

i ran the query from the article you provided and here is the result, seems...

when the server is "stuck" the output from your query is:

total_mem_mb= 30719

avail_mem_mb=9262

avail_mem_prc=30.15

seems ok, right?

do you have some queries to check I/O latency in sql?

thanks!

guy

the total memory on the server is 30GB.

the minimum memory is set to 0

the maximum memory is set to 10GB. we tried to increase the maximum to 16gb that didnt...

Hi

thank for your answer!

does all provided data implies high I/O utilization in sql?

we encounter a lot of sql clients disconnected at some point of the day, it is all fixed...