BLUF: I'm looking for a way to test the database for latency without generating network traffic.
I'm familiar with, but not proficient with databases, and I don't really know SQL. I've laways been a hardware/software troubleshooter and recently transitioned into a netwrok monitoring role where Solarwinds is the preferred tool. We've recently been having soem problems with an EOC dashboard not loading all of the data. We sent log files to Solarwinds support, they advised that they noticed a lot of "Long Running Querry" errors and that such errors are typically a sign of database latency, either from the EOC database, or the NPM database.
While doing some research, it was noticed that the problem doesn't occur during times with low network usage. We hadn't noticed this before because it's a new dashboard and not many people know it is there. Also, we don't have a lot of users accessing EOC in general. My thinking is that if it loads fine during low network usage, it might just be network latency and not database latency causing problems.
I'd like to be able to test the database over the weekend, give it the workload of a normal day, without having the network traffic of a normal day. Unfortunately, I don't know how to do this, so I was hoping someone might be able to give soem help.