You are a database administrator for AIOTestKing.com. You are responsible for monitoring the performance of your SQL Server 2005 computers. You have a SQL Server Integration Services (SSIS) package that usually takes 10 minutes to run. Today, the package is taking more than one hour to run. You suspect memory is too low. You need to identify the problem. What should you do?
A.
Redesign the SQL Server Integration Services (SSIS) package so that it runs only when no exclusive table locks are in use.
B.
Check the time-out values in the SQL Server Integration Services (SSIS) package.
C.
Use the System Monitor to monitor the SQL Server Integration Services (SSIS) pipeline counters.
D.
Use SQL Server Profiler to monitor the Scans event category counters.
Explanation:
SQL Server 2005 Integration Services (SSIS) includes a set of performance counters for monitoring the performance of the data flow engine. To add a new log setting that includes all performance counters do the following: In Control Panel, click Administrative Tools, and then click Performance. In the Performance dialog box, expand Performance Logs and Alerts, right-click Counter Logs, and then click New Log Settings. Type the name of the log. For example, type MyLog. In the MyLog dialog box, click Add Counters. In the Add Counters dialog box, select SQL Server:SSISPipeline in the Performance object box.
Select the All Counters check box, and then close the dialog box.