开发者

separate database for SSIS logging

I read it somewhere"

"A separate database should be created if SSIS logging is required. (Do not use the Sysdtslog90 table in either master or msdb. This is not a security related concern but could be a performance issue since SSIS can generate a lot of logging data. Microsoft recommends creating a separate database for logging."

Why? Just to keep thing开发者_如何学Pythons separate and be more organized or there is a deeper meaning to this?

Regards

Manjot


a performance issue since SSIS can generate a lot of logging data

To be able to finely control the I/O path of the logging data: on which LUN, how many spindles etc.


If it's generating a lot of log information, it may compete with the other database functions if they are sharing the same physical disks. This means both your logging and your database could take a performance hit.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜