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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


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

Featured Database Articles

MS SQL

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


















Thanks for your registration, follow us on our social networks to keep up-to-date