Need help to optimize our SQL 2005 installation, as we're experiencing latency and timeouts from several clients when connecting.? ? Need to improve performance with memory, indexing, and any other items which will get rid of the problems we're having.
Getting this error on the client side app when connecting:
Timeout expired (ErrCode=-2147217871, Line=1020, ProcName=Microsoft OLE DB Provider for SQL Server)
It happens? on all pages.
We were using SQL 2005 on a Windows XP machine before, with only 4GB RAM, and we were not getting this latency problem.? We moved the databases to? a new, much more robust, server running Windows 2003 Enterprise X64 and when we attached the databases and ran the app the latency started to appear.
Thank you.