如何在sql server中释放ssisdb内存.. [英] How to Release ssisdb memory in sql server..

问题描述

全部好，

我已经创建了一个ssis包，它每天通过sql server agent job每小时运行..我试图问的是在运行包时它不是释放物理内存。日常物理内存大小增加，我的网站下降...非常慢响应..

如果您有任何想法，请告诉我。





谢谢

Venkat。

解决方案

< blockquote>请点击此链接：包的SQL Server代理作业 [ ^ ]并转到疑难解答部分。

HI ALL,
I Have created one ssis package it is running daily basis on hourly through sql server agent job..Wht i am trying to ask is while running the package it is doesn't release physical ram memory.Day by day by physical memory size is increases and my site is gng to down...Very slow response..
Can you please let me know if u have any idea..


Thanks
Venkat.

解决方案

Follow this link: SQL Server Agent Jobs for Packages[^] and go to Troubleshooting section.

这篇关于如何在sql server中释放ssisdb内存..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！