I had a thought and wanted to know if it is worth doing.
I have an application, only one installed to be precise, on a 2003 64-bit Terminal Server that accesses a SQL 2008 database for my end users. "Start the following program on Connection" is already checked with the path and file name is pre-defined in their RDP session.
The App & DB server are currently connected through a Cisco Switch which only has 100Megabit ports and I need to keep them for Domain connectivity.
First, I wanted to know, as I have a spare Gigabit NIC, on both App & DB server, if I used a Cross-Over cable to directly connect the two of them would I see better performance for the Terminal Server end-users?
Secondly, If it is worthwhile and I can get better perfomance how would I prioritize the Application Traffic to the DB Server over the Gigabit connection?