SQL Server Performance

DTS performance

Discussion in 'SQL Server DTS-Related Questions' started by Ram Kumar, Jan 19, 2006.

  1. Ram Kumar New Member

    I have a DTS running in a server which is calling stored procedure which is running in another server. Will this cause a performance degradation in the

    I want to know, what resources will be comsumed by DTS when it runs.

  2. satya Moderator

    Instead asking why not test the procedure from Query analyzer by looking at query execution plan, where you can know the system usage. If not schedule a PROFILER and PERFMON traces while the process is running as an assessment.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page