O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

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 ...

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