sql 2000 and sql 7

Question

Post reply

sql 2000 and sql 7

Viewing 10 posts - 1 through 11 (of 11 total)

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi qwerty,

quote:
I have performance problem when I create a select from sql 2000 into sql 7
How can I solve this problem

posting the query might be helpful

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

qwerty SSC Rookie Points: 34 More actions · Answer 2

Hi Frank,

The query is just a simple "Select * from [SQLserver7].database.dbo.table".

I have performance problem when I execute this query from the query analyzer from sql 2000 on another server.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

quote:
The query is just a simple "Select * from [SQLserver7].database.dbo.table".

How many rows are to be returned?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

qwerty SSC Rookie Points: 34 More actions · Answer 4

about 74000 rows, but I get timeout when I execute the query.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

quote:
about 74000 rows, but I get timeout when I execute the query.

not that much, did you set the Query time-out in QA under Tools-> Options ->Connection to some value <> 0 ?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

qwerty SSC Rookie Points: 34 More actions · Answer 6

Yes, the value is <> 0

this is the hardware situation.

Server A: windows 2000, SQL 2000

Server B: windows NT, SQL 7

From Server A, I do select from a table on Server B.

The result from the select, I do insert in

a table on Server A.

Here I get a performance problem, because the select takes about 45 min. The table on server B is indexed.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

quote:
Yes, the value is <> 0
this is the hardware situation.
Server A: windows 2000, SQL 2000
Server B: windows NT, SQL 7

from my understanding, this number specifies the seconds SQL Server waits. The 0 indicates 'wait till judgement day'

Maybe this will help?

Äh, you have the permissions on SQL 7 server?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

qwerty SSC Rookie Points: 34 More actions · Answer 8

qwerty

SSC Rookie

Points: 34

July 28, 2003 at 6:50 am

#467259

Yes, I have full permissions on SQL 7 server.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 9

quote:
Yes, I have full permissions on SQL 7 server.

ok, I guess someone else will come up with Profiler, which I'm not familiar with .

Last chance:

Did you try SELECT TOP 1 ...?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

qwerty SSC Rookie Points: 34 More actions · Answer 10

qwerty

SSC Rookie

Points: 34

July 28, 2003 at 7:04 am

#467266

Yes