Slow 3rd Party Database Program

[hennessy1]

I have a program that uses sql 2008 databases. I recently replaced a server that had sql 2000 with the same program just an older server. Now with this new server the workstations that connect to the database with this program are seeing severly increased lag times from switching screens to entering new data and retrieving previously stored data.

The server has 6 sas drives 4 in raid 10 for the OS and apps and 2 in raid 1 for the databases. It is connected with a quadport server adapter. All the links from there server to the workstations are gigabit links.

The old server did not have this program. The current server running the program locally does not have this problem so I can narrow it down to the network connections I believe. I don't know what else I can try. Any help is greatly appreciated.

 

[D.SKiLL]

you could try using the cliconfig to allow passage through a named port or via the ip. We use this for a similar setup, it improves access time & lagg over a 7 location fiber network.

 

[hennessy1]

Thank you. I will try that as well. What I had done before this post is change the teaming type from IEEE 802.3ad Dynamic Link Aggregation to Adaptive Load Balancing. That seems to have helped a great deal. For some reason though with the previous team it would have spurts of speed then dramatically slow down.