Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Mar 30, 2005

The SQL Server Best Practices Analyzer - Page 2

By Steven Warren

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

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM