Poor performance

Hi

I have the following structure:

At server, I have SQL Server 2005 with a database running in compability mode 8.0 (SQL 2000). At desktops (cliente side) I have SQL Server 2005 Express. The base on the desktops access the base on the server to a copy of data through Linked Server. Both bases are in compability mode 8.0.

This is my problem:

The copy of data using a ad-hoc query INSERT INTO LOCAL-DATABASE ... SELECT .... FROM REMOTE-DATABASE (WAN) takes much more time than if I use MSDE in the desktops.

I would like to know what problem can be cause this delay.

Thanks

Did you check 'Collation Compatible' option in the linked server options?

|||

Yes I did. This option is defined "FALSE". Is It right?

Tks

|||It should be set to TRUE.

Poor performance

Hi

I have the following structure:

At server, I have SQL Server 2005 with a database running in compability mode 8.0 (SQL 2000). At desktops (cliente side) I have SQL Server 2005 Express. The base on the desktops access the base on the server to a copy of data through Linked Server. Both bases are in compability mode 8.0.

This is my problem:

The copy of data using a ad-hoc query INSERT INTO LOCAL-DATABASE ... SELECT .... FROM REMOTE-DATABASE (WAN) takes much more time than if I use MSDE in the desktops.

I would like to know what problem can be cause this delay.

Thanks

Did you check 'Collation Compatible' option in the linked server options?

|||

Yes I did. This option is defined "FALSE". Is It right?

Tks

|||It should be set to TRUE.

Poor Linked Sybase Server performance

Hi
I have a problem with performance when I execute proc against linked Sybase
Server.
Here is a strings I used to add a server:
sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
Execute of proc is taking a second when it run directly on Sybase, is taking
about 20 sec.
I've never noticed any network problems in our environment before.
Any ideas?
Does anybody know a better alternative to connect to Sybase?
Try the instructions on the sybase website for creating a linked server.
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C26C4E8F-D554-47E8-B207-04AF2A6954A9@.microsoft.com...
> Hi
> I have a problem with performance when I execute proc against linked
Sybase
> Server.
> Here is a strings I used to add a server:
> sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
> sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
> Execute of proc is taking a second when it run directly on Sybase, is
taking
> about 20 sec.
> I've never noticed any network problems in our environment before.
> Any ideas?
> Does anybody know a better alternative to connect to Sybase?

Poor Linked Sybase Server performance

Hi
I have a problem with performance when I execute proc against linked Sybase
Server.
Here is a strings I used to add a server:
sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
Execute of proc is taking a second when it run directly on Sybase, is taking
about 20 sec.
I've never noticed any network problems in our environment before.
Any ideas?
Does anybody know a better alternative to connect to Sybase?Try the instructions on the sybase website for creating a linked server.
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:C26C4E8F-D554-47E8-B207-04AF2A6954A9@.microsoft.com...
> Hi
> I have a problem with performance when I execute proc against linked
Sybase
> Server.
> Here is a strings I used to add a server:
> sp_addlinkedserver N'hetco_sybase', ' ', N'MSDASQL', N'hetco_sybase'
> sp_addlinkedsrvlogin N'hetco_sybase', false, null, N'sa', 'sa_password'
> Execute of proc is taking a second when it run directly on Sybase, is
taking
> about 20 sec.
> I've never noticed any network problems in our environment before.
> Any ideas?
> Does anybody know a better alternative to connect to Sybase?sql

Pls help me on the following sql select - I get an error message

Hi
I get an error : ODBC ERROR - Incorrect syntax near , from Crystal SQL
reports.
Your help is really appreciated
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code"
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SELECT
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
"nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03-3
1
00:00:01.00'}Radha,
Why did you use , at the where condition?
National_Oxygen_Pte_Ltd_Custo=ADmer_Budg
et."Customer No_" ,
National_Oxygen_Pte_Ltd_Custom=ADer_Budg
et."Item Category Code")
Is this a column?

Pls help me on the following sql select

Hi
I get an ODBC ERROR - Incorrect syntax near , from crystal reports 8.5. any
help is realy appreciated
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SELEC
T
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
"nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03-3
1
00:00:01.00'}Hi Radha
Just try this way
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
FROM
nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE
(National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN (SELEC
T
National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts '2005-03-3
1
00:00:01.00'}
please let me know if there are any issues
thanks and regards
Chandra
"Radharaj" wrote:

> Hi
> I get an ODBC ERROR - Incorrect syntax near , from crystal reports 8.5. an
y
> help is realy appreciated
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_" ,
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code") NOT IN (SEL
ECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer No_",
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category Code" FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts '2005-03
-31
> 00:00:01.00'}|||That won't do if you're hitting against sqlserver.
Sqlserver does not support row constructors so such query will fail.
Try this instead:
SELECT
National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
FROM
"nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
National_Oxygen_Pte_Ltd_Customer_Budget
WHERE NOT exists (SELECT *
FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
WHERE
National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
'2005-03-01 00:00:00.00'} AND
National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
'2005-03-31 00:00:01.00'}
-oj
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
> Hi Radha
> Just try this way
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
> FROM
> nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN
> (SELECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
> nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts
> '2005-03-31
> 00:00:01.00'}
> please let me know if there are any issues
> thanks and regards
> Chandra
>
> "Radharaj" wrote:
>|||Hi Chandra
Thanks for your response. However I am still getting the same error message
Regards
Raj
"Chandra" wrote:
> Hi Radha
> Just try this way
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget.[Customer No_],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Mar Amount],
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code],
> FROM
> nox.dbo.[National Oxygen Pte Ltd$Customer Budget]
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE
> (National_Oxygen_Pte_Ltd_Customer_Budget
.[Customer No_] ,
> National_Oxygen_Pte_Ltd_Customer_Budget.[Item Category Code]) NOT IN (SEL
ECT
> National_Oxygen_Pte_Ltd_Sales Invoice_Line.[Customer No_],
> National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne.[Item Category Code] FROM
> nox.dbo.[National Oxygen Pte Ltd$Sales Invoice Line]
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne WHERE
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne.[Shipment Date] < {ts '2005-03
-31
> 00:00:01.00'}
> please let me know if there are any issues
> thanks and regards
> Chandra
>
> "Radharaj" wrote:
>|||Hii oj
thanks a ton!! It works
Regards
Raj
"oj" wrote:

> That won't do if you're hitting against sqlserver.
> Sqlserver does not support row constructors so such query will fail.
> Try this instead:
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE NOT exists (SELECT *
> FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
> WHERE
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
> No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
> AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
> Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
> AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
> '2005-03-31 00:00:01.00'}
> --
> -oj
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
>
>|||Dear Oj
Thanks a ton!! It works
Regards
Raj
"oj" wrote:

> That won't do if you're hitting against sqlserver.
> Sqlserver does not support row constructors so such query will fail.
> Try this instead:
> SELECT
> National_Oxygen_Pte_Ltd_Customer_Budget."Customer No_",
> National_Oxygen_Pte_Ltd_Customer_Budget."Mar Amount",
> National_Oxygen_Pte_Ltd_Customer_Budget."Item Category Code",
> FROM
> "nox"."dbo"."National Oxygen Pte Ltd$Customer Budget"
> National_Oxygen_Pte_Ltd_Customer_Budget
> WHERE NOT exists (SELECT *
> FROM "nox"."dbo"."National Oxygen Pte Ltd$Sales Invoice Line"
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne
> WHERE
> National_Oxygen_Pte_Ltd_Sales Invoice_Line."Customer
> No_" =National_Oxygen_Pte_Ltd_Customer_Budget
."Customer No_"
> AND National_Oxygen_Pte_Ltd_Sales_Invoice_Li
ne."Item Category
> Code" =National_Oxygen_Pte_Ltd_Customer_Budget
."Item Category Code"
> AND National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" >= {ts
> '2005-03-01 00:00:00.00'} AND
> National_Oxygen_Pte_Ltd_Sales_invoice_li
ne."Shipment Date" < {ts
> '2005-03-31 00:00:01.00'}
> --
> -oj
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:F136E31C-9006-4817-B854-A0AB994F5E8C@.microsoft.com...
>
>