• To disable Shared Memory protocol for SQL Server 1. Click Start
  • Protocols for MSSQLSERVER
    		•

    Disable the Shared Memory Protocol




    Download 170.47 Kb.
    bet22/36
    Sana21.03.2017
    Hajmi170.47 Kb.
    #843
    1   ...   18   19   20   21   22   23   24   25   ...   36

    Disable the Shared Memory Protocol


    Under certain stress conditions (such as clients accessing SQL Server from the same computer), the SQL Server Shared Memory protocol may lower BizTalk Server performance. You can resolve this problem by disabling the use of the Shared Memory network protocol in the SQL Server Client Network Utility.

    To disable Shared Memory protocol for SQL Server 


    1. Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, click Configuration Tools, and then click SQL Server Configuration Manager.

    2. In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for MSSQLSERVER.

    3. Right-click Shared Memory, and then click Disable.

    4. Click SQL Server Services, right-click SQL Server (MSSQLSERVER), and then click Stop. After the service has stopped, right-click SQL Server (MSSQLSERVER) again, and then click Start.

    5. Close SQL Server Configuration Manager.



    Download 170.47 Kb.
    1   ...   18   19   20   21   22   23   24   25   ...   36




    Download 170.47 Kb.
    Bosh sahifa
    Aloqalar
        Bosh sahifa
    Dərs
    Mühazirə
    Qaydalar
    Referat
    Xülasə
    Yazı


    Disable the Shared Memory Protocol

    Download 170.47 Kb.