Working with best practices
Now that you have your SQL Servers defined in the BPA tool, you
are ready to create best practices and scan the SQL Server(s). In order to
create a best practice, click the Best Practices link on the left navigation
bar (Figure F) and choose Create Best Practice (at the bottom of the
screen).
In this screen, you can enter a Best Practice Name (Figure G) and choose
the category of your choice. If you choose all categories, you can select any
of the Rules (best practices) you desire. If you are unsure of which of these
rules to use, you can click on the question mark (?) icon for a definition of
each one.
Once you have selected all of your rules, click Save Best Practice. After you
save it, you can execute it by clicking on the down arrow of each best practice
and click Scan SQL Servers (Figure H). Once the scan is complete, you
can review your best practices by viewing the Reports (Figure I).
I have shown you how to harness the power of this Microsoft tool to analyze
your SQL Servers against standard best practices. By testing each scenario on a
SQL Server on your testing network, you can become familiar with this tool and
how it works, prior to implementing it on your production SQL Servers to make
them run at optimum efficiency.
»
See All Articles by Columnist Steven S. Warren
» 
IE 7
Firefox 2.0
Comment and Contribute
