D Brennan 13.Sep.07 10:35 PM a Web browser LEILEI - 6.5Windows 2003
We've recently upgraded our SQL Server from 2000 to 2005 enterprise ed. on a cluster and added large amounts of RAM, more processors, etc.
After the upgrade several of our LEI activities began running very slowly (queries/deletes/inserts that normally took 15 minutes now take 2+ hours).
Our LEI and Domino server are 6.5.2 and have not changed. We're running Windows 2k3 server and that has not changed, either.
I'm trying to figure out if there may be ODBC problems, driver version problems, Named Pipes/TCPIP or problems that are known to occur between LEI and SQL Server 2005.
Has anybody gone through a SQL upgrade and had trouble with LEI afterwards? Is anybody running SQL 2005 on a cluster and successfully running LEI? Has anybody successfully worked though performance problems with LEI and SQL Server 2005?
Any thoughts that can help me to work though this problem would be appreciated.