Evaluating database properties

I still remember the days when a DBA's life was not as easy as it is today. Some of the database configurations are very important, and changes in those properties can cause big issues. So, we had to write a customized script to check those database properties, schedule them in SQL Server Agent, and get a report by e-mail every day, so that if any change were found in an important property of the database, we could take action immediately, before it started creating an issue. Life is not that difficult now; we can use PBM to keep an eye on those properties.

Getting ready

The following are the prerequisites for the recipe:

  • SQL Server Denali (2012) CTP 3 or higher
  • Login credentials that have the sysadmin role in SQL ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.