Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
Benefits
|
core component of sql 2012 data collection. provicdes one central point for data collection across your db servers and applications. Not limited to performance data unlike sql trace. supports dynamic tuning and is extensible through its API
|
|
|
benefits cont..
|
enables you to adjust the scope of data collections to suit your test and prod environments. Uses a data warehouse, a relational db that enables you to manage the data that you collect by setting different retention periods.
|
|
|
Data collector concepts
|
SQl agent is used to schedule and run collection jobs
ssis is used to execute packages that collect data form individual data providers |
