Performance using parameters

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Performance using parameters

Postby agierbolini » Wed Dec 12, 2012 6:53 pm

I have a performance issue using parameters in query

SELECT columns From Linkedtable where column = 'value'

Take 1 sec

SELECT columns FROM Linkedtable WHERE column = @parameter

Take about a minute
agierbolini
 
Posts: 2
Joined: Wed Dec 12, 2012 6:42 pm

Re: Performance using parameters

Postby Moderator » Tue Dec 18, 2012 9:38 pm

Hi,
would you send the table DDL and any additional information that can help us reproduce the issue? Is the parameter large? How many rows are in the table? Have you tried to run PGNP Profiler and see how different are the message traces?
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 2 guests

cron