O'Reilly logo

SQL Server 2008: Administration in Action by Rod Colledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15.3. Data collection

Once configured for data collection, a SQL Server instance is enabled with three default system collection sets and the ability to define custom sets if required. In both cases, there are a number of important considerations about upload frequencies/methods and retention periods. All of these properties can be accessed and modified in SQL Server Management Studio under the Management > Data Collection folder by right-clicking on a collection set and choosing Properties.

15.3.1. Upload method and frequency

Each data collection set has its own data collection and upload method, with the two options being Non-cached and Cached. As the name suggests, the cached method collects and caches data locally before uploading to the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required