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
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment