Just to confirm have you specified the named pipes pipe correctly(pointing to the instance you want to connect)?

MJ

Have you tried by disabling antivirus, system level tasks that are running outside of SQL? Might be faulty dirver sort of issue...

MJ

Is the recovery model for KPIMaster database set to SIMPLE?

Check whether any such recovery model change was made for any database which is included under the list of databases backed...

Is it 32-bit or 64-bit SQL Server Edition? Have you tried changing the max server memory to 5.5 or somewhere around 6.0? Also, try changing min server memory to 2...

I don't think it makes any performance impact.

Its just used becasue the remote server collation isdifferent from the source one:

Use Remote Collation:

Determines whether the collation of a remote column or...

Have a look at:

http://blogs.msdn.com/sqlcat/archive/2008/04/10/what-you-should-know-if-you-are-using-logical-ios-to-measure-query-plan-quality.aspx

about What you should know if you are using Logical IOs to measure query plan quality ?

MJ

The following code worked for me:

DECLARE @ServerName varchar(255)

DECLARE @sql as varchar(6000)

DECLARE c1 CURSOR READ_ONLY

FOR

SELECT name

FROM dbo.tbl_serversT

OPEN c1

FETCH NEXT FROM c1

INTO @ServerName

WHILE @@FETCH_STATUS...

Try comparing physical and logical reads on both system by turning on statistics for I/O.

SET statistics io on

MJ

As Gail said compare the execution plans....

MJ

Check whats the cost involved(from execution plan) when you specify the required index by using index hint. Turn on statistics (set statistics io on) and check logical and physical reads.

Do...

To giv it a start:

select name as Job_Name,substring(command,charindex(' -',command),100) as Commandsd,sd.database_name

from msdb..sysjobsteps js join msdb..sysdbmaintplan_jobs jp

on

js.job_id=jp.job_id

join msdb.. sysjobs sj on

js.job_id=sj.job_id

join msdb..sysdbmaintplan_databases sd

on sd.plan_id=jp.plan_id

MJ

How much memory has been allocated to sql server? Are you making use of lock pages in memory option--http://support.microsoft.com/kb/918483.

MJ

Make sure no other program is using those files(any antivirus running in background). Also, if you have utilities like filemon you can view the processses using that file..

HTH

MJ

Try this:

In your DTS package select the Dynamic Properties Task. Open the

properties for that task and click on Add. Next expand the connections

and select the output file to...

Thanks Jeff. I also got one(http://support.microsoft.com/default.aspx?scid=kb;en-us;177078) but your's one looks fine.

Thanks again,

MJ