I would appreciate a simple piece of code (VB) to provide network bytes sent and received from Performance Counters on a workstation (or is there another place?)
Have Win-2000 application using MS-Access database on server and depending on size of backend database, there are some very ugly transfers of data. Most likely culprit is poorly written SQL (gee, let's get all fields in all records...), but with over 900 queries, I dread the manual approach.
I already have code that will automatically insert traces into all subroutines in all modules and provide lapse times, but now would like to get bytes over the network (one look at the lights on the NetGear switch will blind you).
Thank you for your assistance.
Have Win-2000 application using MS-Access database on server and depending on size of backend database, there are some very ugly transfers of data. Most likely culprit is poorly written SQL (gee, let's get all fields in all records...), but with over 900 queries, I dread the manual approach.
I already have code that will automatically insert traces into all subroutines in all modules and provide lapse times, but now would like to get bytes over the network (one look at the lights on the NetGear switch will blind you).
Thank you for your assistance.
