Wednesday 13 August 2008

Management Studio Speedup : Shared Memory

If your client and server are the same server (screams silently), for instance in a local development environment then Shared Memory can help.

As of SQL 2005 it is enabled by default, but incase it isn't or you need to check -

1) Set Shared Memory as Enabled for the sql server -


2) Set Shared Memory as Enabled in the client protocols -


Ref : Default SQL Server Network Configuration

No comments: