- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- In database session when doing replication
In database session when doing replication
8 years 3 months ago #12489
by kaoru
In database session when doing replication was created by kaoru
Hi,
I'm currently debugging my SSIS replication from Source system to Greenplum.
A few days ago I have timeout issue, some of the packages get timeout error.
My last setting is COMMAND_TIMEOUT=1200, now I have to set COMMAND_TIMEOUT=12000.
When I looked into the session tracker, I found something strange repeated queries :
- select count(*)::float4
- select avg(pg_column_size(Ta.description))::float4
it seems that it looped all the column and start doing those count and avg ...
My question is :
- is that code normal ?
- will that impacted on query performance ?
Thank u
I'm currently debugging my SSIS replication from Source system to Greenplum.
A few days ago I have timeout issue, some of the packages get timeout error.
My last setting is COMMAND_TIMEOUT=1200, now I have to set COMMAND_TIMEOUT=12000.
When I looked into the session tracker, I found something strange repeated queries :
- select count(*)::float4
- select avg(pg_column_size(Ta.description))::float4
it seems that it looped all the column and start doing those count and avg ...
My question is :
- is that code normal ?
- will that impacted on query performance ?
Thank u
Please Log in or Create an account to join the conversation.
8 years 3 months ago #12510
by Moderator
Replied by Moderator on topic Re: In database session when doing replication
Probably not. The OLEDB provider does not generate the queries. Try to change some replication parameters, and see if the queries are no longer issued.
Also, consider using PGNP Optimizer to change queries "on-the-fly".
Also, consider using PGNP Optimizer to change queries "on-the-fly".
Please Log in or Create an account to join the conversation.
8 years 3 months ago #12518
by kaoru
Replied by kaoru on topic Re: In database session when doing replication
Hi,
Last time we experienced an database error.. so that count query popped up.
Confirmed now we're not having it again, and the performance is going back to normal.
thank u
Last time we experienced an database error.. so that count query popped up.
Confirmed now we're not having it again, and the performance is going back to normal.
thank u
Please Log in or Create an account to join the conversation.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- In database session when doing replication
Time to create page: 0.051 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- In database session when doing replication