Data Collection Sets
Utilizing other tools as you fine-tune your SQL Server instance configuration options is much easier now. The Data Collection services within SSMS provide a great way to get that high-level picture of your SQL Server’s execution quickly. This capability is new to SQL Server. Chapter 39 covers this feature in much more depth. However, if you look at Figure 55.13, you can see a server-wide view of disk usage for database on a SQL Server instance. You can also easily drill down into any one of the databases for a more in-depth picture of how the database is being used.
Figure 55.13 Data Collection: Disk Usage.
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
