Grids are slow to refresh when opening windows/sorting grid columns using SQL Server

Modified on Thu, 03 Aug 2017 at 11:13 AM

Grids are slow to refresh or there is a several second delay when opening windows and sorting grid columns using SQL Server


Make sure that the TCP/IP protocol is enabled and that a static IP address is specified for the protocol and for the SQL Server computer.  This will ensure that the client computer does not have to do a DNS lookup or create a named pipe which could take a second or two.  Also, make sure that the TCP/IP protocol is enabled under the Native Client and that they are in the following order:  Shared Memory, TCP/IP, Named Pipes.

Also, make sure that the following patch is on your SQL server (as this is not yet available for R2, DM suggestions that everyone use SQL Server 2008 (R1) until R2 has been on the market longer).  Click here to read the article


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article