Once you have gathered the data, you can take advantage of several techniques that should improve network performance. These techniques include:
Using small packets for most database activity
Using larger packet sizes for tasks that perform large data transfers
Using stored procedures to reduce overall traffic
Filtering data to avoid large transfers
Isolating heavy network users from ordinary users
Using client control mechanisms for special cases
