We have a SQL 2005 database running on a Windows 2003 Server. We recently added two new data servers and used Windows 2008 Server. We have tried R2 and non-R2, plus Windows 2003 Server, on these two new servers, and in all cases performance
is so slow as to be unacceptable. Clients access the data via a Windows 2008 Server running Terminal Services and hit a custom application. We have tried many different configurations using backup servers, test servers, Windows 7, Windows Vista,
Windows Server et. al. - oddly a very old XP client running the application against a 2003 server performs about 7 times faster than either Windows 7, Windows Vista, or Windows Server clients running same. We have attempted to run the client application
compiled under VS 2005, VS 2008, and VS 2010 - using .NET 2.0 to 4.0, under every configuration we can come up with. What's odd is that neither the client nor the server are taxed for resources. Memory is fine, processor time is fine, network traffic
looks normal. Any ideas would be greatly appreciated.
View Complete Post