当SSIS正在运行时，应该如何执行性能? [英] how performance should done when SSIS is process is going on ?

问题描述

正在进行多次操作，这将减慢系统速度，然后提高系统性能.

There are multiple operation going on it is slow down system then which will improve the performance of system.

推荐答案

没有一种快速的解决方案.由于您正在使用SSIS，因此我将开始研究是什么导致数据库服务器上的负载.

调查所有会话，使用事件探查器跟踪长时间运行的操作等.在获取有关特定长时间运行或资源消耗操作的信息之后，请集中精力通过建立索引，重写操作等来增强操作.

还要使用Windows性能监视器，例如，检查CPU和主内存的利用率.如果您要执行大量操作，则可能是由于服务器分页引起的.这是一个具体原因.

Well there is no one quick solution. Since you''re working with SSIS I would start to investigate what is causing the load on the database server.

Investigate all the session, use profiler to track long running operations etc. After digging information about specific long running or resource consuming operations, concentrate on enhancing the by indexing, re-writing the operations and so on.

Also using for example the Windows Performance Monitor, check the utilization of the CPU and the main memory. If you have lot''s of operations going on, one speciifc reason could be paging of the server.

这篇关于当SSIS正在运行时，应该如何执行性能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！