Anyone else experience slowness when connecting to a remote SQl 2005 SP3 server? Any apps installed locally on 2008 Server are slow to interact with out 2005 SQL cluster. 2003 Servers are fine. SQL MGMT Studio is also very slow to open and navigate against the remote SQL server. Thanks for any insight.

Hello cwalstib, There may several reasons for the slowness when remote SQL 2005 SP3 server. 1. The Network utilization by other processes is high, which occupies the network bandwidth for remote connection session.2. The remote SQL server works under a high load locally, thus the CPU, memory or network resource could be used up. In order to narrow down the cause of the performance issue more efficiently, you may refer the following steps to perform a Clean Boot of the local Windows Server 2008 based-computer, and you may monitor to see if the performance issue will be re-occur. Step: Perform a Clean Boot 1. Click "Start", go to "Run", and type "msconfig" in the open box to start the System Configuration Utility. 2. Click the "Services" tab, check the "Hide All Microsoft Services" box and click Disable All (if it is not gray). 3. Click the "Startup" tab, click "Disable All" and click "OK". 4. Restart your computer. When the "System Configuration Utility" window appears, please check the box and click "OK". Meanwhile, please also apply the cumulative update package 1 for SQL Server 2005 SP3 on that remote server, and then check if it helps. Cumulative update package 1 for SQL Server 2005 Service Pack 3 http://support.microsoft.com/kb/959195/LN/ If the performance issue still exists, you may consider using Reliability and performance monitor or Process Monitor tool to check and locate which process occupies the resource on that server Performance and Reliability Monitoring Step-by-Step Guide for Windows Server 2008 http://technet.microsoft.com/en-us/library/cc771692.aspx Process Explorer http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx More reference for you. HOW TO: Troubleshoot Application Performance with SQL Server http://support.microsoft.com/kb/224587 Meanwhile, as this issue may be related to SQL server, it is also recommended that you initial a new thread in one of the SQL server forum. The community members and support professionals there have more experience on SQL server and can help you in a more efficient way. SQL Server http://forums.microsoft.com/TechNet/default.aspx?ForumGroupID=93&SiteID=17 Hope the issue will be resolved soon.This posting is provided "AS IS" with no warranties, and confers no rights.

Installing 948496 on the SQL 2005 / Windows 2003 Cluster fixed the issuethanks