Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime. This will allow you to log the output to 5 providers...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
04-09-2008
Filed under: sql server, package, profiler, ssis, xml, error log, 2005, information, warning, logging, event viewer
Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. What is best way to determine cause? First...