Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
Can you name five of the Perfmon counters for SSIS and the value they provide?
Nice?
Vote!
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
counter
1 Answer
Nice?
Vote!
SQLServer:SSIS Service
SSIS Package Instances - Total number of simultaneous SSIS Packages running
SQLServer:SSIS Pipeline
BLOB bytes read - Total bytes read from binary large objects during the monitoring period.
BLOB bytes written - Total bytes written to binary large objects during the monitoring period.
BLOB files in use - Number of binary large objects files used during the data flow task during the monitoring period.
Buffer memory - The amount of physical or virtual memory used by the data flow task during the monitoring period.
Buffers in use - The number of buffers in use during the data flow task during the monitoring period.
Buffers spooled - The number of buffers written to disk during the data flow task during the monitoring period.
Flat buffer memory - The total number of blocks of memory in use by the data flow task during the monitoring period.
Flat buffers in use - The number of blocks of memory in use by the data flow task at a point in time.
Private buffer memory - The total amount of physical or virtual memory used by data transformation tasks in the data flow engine during the monitoring period.
Private buffers in use - The number of blocks of memory in use by the transformations in the data flow task at a point in time.
Rows read - Total number of input rows in use by the data flow task at a point in time.
Rows written - Total number of output rows in use by the data flow task at a point in time.
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
1
answer
Can you name 5 or more of the main SSIS tool box widgets and their functionality?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis
ssis-interview-question
Nice?
Vote!
1
answer
Can you name 5 or more of the native SSIS connection managers?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis
ssis-interview-question
Nice?
Vote!
1
answer
Name the three main tabs in the Visual Studio interface for SSIS Packages and the associated purpose.
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
junior-sql-server-developer-interview-questions
Nice?
Vote!
1
answer
Can you explain different options for dynamic configurations in SSIS?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis
ssis-interview-question
configuration
Nice?
Vote!
1
answer
How would you restart package from previous failure point?What are Checkpoints and how can we implement in SSIS?
asked
1 year
ago
in
SSIS Interview Questions and Answers
by
R
(
19,530
points)
ssis-interview-question
ssis
checkpoint