Professional Web Applications Themes

linked server performance - Microsoft SQL / MS SQL Server

For SQL Server these row numbers are relatively small. I'm not sure that using CPU usage is saying much in terms of performance unless this is not an isolated problem. Obviously, the more rows, the longer it would take to process. The question is whether there is a major difference and the performance is slower than expected. I would look at index usage, memory utilization, paging, locking, etc. >-----Original Message----- >Hi: > >We are using sql2000 sp2. We need to join 2 tables in one >sql server with another table in another sql server and >insert results into a new ...

  1. #1

    Default linked server performance

    For SQL Server these row numbers are relatively small.
    I'm not sure that using CPU usage is saying much in terms
    of performance unless this is not an isolated problem.
    Obviously, the more rows, the longer it would take to
    process. The question is whether there is a major
    difference and the performance is slower than expected. I
    would look at index usage, memory utilization, paging,
    locking, etc.

    >-----Original Message-----
    >Hi:
    >
    >We are using sql2000 sp2. We need to join 2 tables in one
    >sql server with another table in another sql server and
    >insert results into a new table. Basically query is like
    >this:
    >select a.*, b.c1, c.c3 into table1 from test1 a inner
    join
    >sv2.db.dbo.temp2 b on a.lgid = b.lgid inner join
    >sv2.db.dbo.temp3 c on b.lgid = c.lgid
    >
    >We use the above code in our VB application. table1 is
    >always very big(has over 50,000 rows), when the size of
    >temp2 and temp3 are small, it runs quickly. But when
    >sometimes temp2 and temp3 get big(over 15,000), it spikes
    >up CPU on sv2. Is there any way to get around with the
    >performance problem? Thanks.
    >.
    >
    DJoe Guest

  2. #2

    Default Re: linked server performance

    On Tue, 1 Jul 2003 17:29:15 -0700, "Dean" <dean5> wrote:
    >We are using sql2000 sp2. We need to join 2 tables in one
    >sql server with another table in another sql server and
    >insert results into a new table. Basically query is like
    >this:
    >select a.*, b.c1, c.c3 into table1 from test1 a inner join
    >sv2.db.dbo.temp2 b on a.lgid = b.lgid inner join
    >sv2.db.dbo.temp3 c on b.lgid = c.lgid
    >
    >We use the above code in our VB application. table1 is
    >always very big(has over 50,000 rows), when the size of
    >temp2 and temp3 are small, it runs quickly. But when
    >sometimes temp2 and temp3 get big(over 15,000), it spikes
    >up CPU on sv2. Is there any way to get around with the
    >performance problem? Thanks.
    So it spikes, let it! How long does it take? 50k rows is tiny,
    nowadays, unless you're running this query once a second or something.

    J.

    JXStern Guest

Similar Threads

  1. Saving Linked files on the server
    By mlemelin in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: December 12th, 08:09 PM
  2. Linked SWF loadMovie performance is pathetic
    By MetaHipster webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 2
    Last Post: January 20th, 07:23 PM
  3. Performance with linked tables
    By Eddie Simons in forum ASP Database
    Replies: 1
    Last Post: September 25th, 10:46 AM
  4. Help with linked server qry (error doing delete!)
    By Philip in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 12th, 09:10 PM
  5. Create and Drop tables in a linked server
    By Jason Yan in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 05:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139