开发者

separate database for SSIS logging

开发者 https://www.devze.com 2022-12-15 07:16 出处:网络
I read it somewhere\" \"A separate database should be created if SSIS logging is required. (Do not use the Sysdtslog90 table in either

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

精彩评论

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