DPA network round-trip abnormal

cmi

Bonjour,

Sur DPA j'ai des piques anormaux dans les ressources indiquant le Round trip.

Je n'arrive pas à savoir ce qui provoque ces anomalies.

Il s'agit d'un serveur qui est sur un machine virtuelle, Windows 2008, SQL standard 2014

Est-ce que vous pourriez me donner des pistes de recherche ?

Merci par avance pour votre aide,

Christian

attachments.zip

darichar

DPA's round trip metric originates from the DPA server while connected to your SQL instance. A simple query "select 1" is executed and the time it takes to return is the data shown in DPA's charts. It is a "loose" representation of network round trip since hopefully the "select 1" executes very quickly. HOwever, there are things on both the DPA and SQL servers that could affect it.

Some thoughts I have are:

• It looks like the metric spikes roughly every 5 minutes, but none of the other metrics seems to correlate to that.
• I would also drill into the wait time data for the instance to see if there are any correlations there. In other words, does a set of SQLs execute every 5 minutes or so.
• Is the DPA server busy at those times as well? If the source of the query is slow, it may take a bit for the query to be processed.
• Do you have SAM, NPM or other tools from SolarWinds that could help provide more details about the server and network?

With all of this said, 16 ms does not seem too bad either.