Post reply

Memory leak

  • March 15, 2014 at 11:16 am

    #283481

    Question

    Circumstance. I have two server. First has SQL 2005 installed,second has SQL2008R2 installed. The two server have data to synchronized. We build link server from one to another. Every night about 23:00, one stored procedure (use merge tech)will be executed to synchronized data . After night,the memory of first server increment rapidly(about 15 G).

    Total physical memory of the first server is 128g,about 3 weeks later, the memory was eat up. The application can not connect to the server. Maybe the lock files in memory is enabled. I am not sure.

    I am a chinese. English is shabby.

    Thanks.

  • March 15, 2014 at 12:28 pm

    #1697440

    a linked server , when joined against local data, is very slow.

    what actually happens is the entire table from the linked server is copied over into local tempdb, and THEN the merge occurs.

    as a result, tempdb will use a lot of disk space, and a lot of ram/memory will be used to perform the merge.

    so if the linked server has a million/billion rows of data, that is copied , and finally merged against the local table.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 15, 2014 at 3:31 pm

    #1697447

    You mean the cause of memory leak is merge mechanism by linked server,so what other method you recommendation?thanks.

  • March 16, 2014 at 4:31 am

    #1697473

    No, he means there isn't a memory leak. Linked servers use a lot of memory, but that's not the same as a memory leak.

    There are a lot of ways to do synchronisation between two databases, need a lot more details to recommend anything.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 17, 2014 at 11:45 pm

    #1697849

    would you please give some reference about the memory usage about linked server ?thanks

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

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