SQL Server Performance Forum – Threads Archive
Log package execution to SQL Server
In DTS package properties under Logging, should "Log package execution to SQL Server" be checkd? Is it better to leave it unchecked? Then wouldn’t the execution be faster? Any tips? CanadaDBAI suggest you to check this option, if that DTS package is failed when it is scheduled then it gives better insight for the reasons and where it failed. Performance of package execution is not affected at all with this option. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Good information Satya! Thank you for the complete answer.
quote:Originally posted by satya
I suggest you to check this option, if that DTS package is failed when it is scheduled then it gives better insight for the reasons and where it failed. Performance of package execution is not affected at all with this option.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
CanadaDBA
]]>