SQL Server Memory Incress

  • Hi

    over SQL 2000 server memory getting too much memory in the server.  We using SP3 and merge replication. As a result of this systems are too slow.

    Pleace help me to solve this problum.

    thanks

    Nevil - Sri Lanka

  • You may try to set max memory for SQL Server under the Memory tab in the SQL Server Properties dialog.

  • I am allready set max memory for SQL Server. But system too slow.

    I found this error in SQL Sever Log " SuperSocket Info: Bind failed on TCP port 1433."

    Please help me .

     

  • Can you give some idea of the memory on the server and your setting? Also, do you mean that the server responds slow? That merges timeout or take too long or something else?

  • Before seeing the error: "SuperSocket Info: Bind failed on TCP port 1433", did you change your IP? If so, the following link may help,

    http://support.microsoft.com/kb/319578

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply