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.

    Ram Kumar, Jan 19, 2006
    #2

  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.
    satya, Jan 20, 2006
    #2

Share This Page