Hey Steve,
Really appreciate you taking out time. What I missed telling is that application is running on two different linux servers pulling data from SQL Server, and there is a Disk IO i.e. I am writing data back on the disk as csv files. So, I was just wondering whether the writing to disk is taking time i.e. the application is not able to process data at a rate transferred by the SQL Server or there is some problems on the SQL server not flushing the data to the network. The problem is that the NIC
cards on both ends are of 1Gbps, and I am seeing a throughput of only 25% on the SQL server machine.
Is there a way to figure this out. What metrics should I be looking at. I was looking at few tools i.e. vmstat and iostat on linux, but am not sure what metrics should be seen.
I am not sure if I am able to explain it well
. Am new to perf engineering and hence so many questions and thoughts
.
Thanks,
Amit.