Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-20 : 17:43:59
Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices. These Best Practices typically relate to the usage and administration aspects of SQL Server databases and ensure that your SQL Servers are managed and operated well.

Article Link.

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-11-25 : 12:11:40
Please note the below if you have already installed this (prior to 24/11). You will need to download the beta refresh from the same link (the old version binaries are version 1.0.17 and the new ones are 1.0.20)

Hi All
We've identified an undesired potential side effect caused by one of the checks performed by the Best Practices Analyzer Beta Tool (BPA) released on 11/12.

It is recommended to not use the "Check Downlevel Clients" rule (under "Deprecation" category). Errors may occur on other connections on the server being scanned only while the rule is running.

To disable this rule from BPA and avoid unintentional execution you can run the following statements against the repository database:

DELETE FROM dbo.bpa_bestpractices WHERE bestpractice_id='DOWNLEVELCLIENTS'
DELETE FROM dbo.bpa_jobs WHERE NOT EXISTS (
SELECT * FROM dbo.bpa_job_bestpractices jbp WHERE
bpa_jobs.job_name=jbp.job_name)


A newer build of BPA has been posted to the web removing the aformentioned rule. Uninstall of previous build is required.

Go to Top of Page

zzx375
Starting Member

1 Post

Posted - 2003-12-03 : 17:18:58
If my memory is correct you will need the .NET Framework 1.1 installed on your server in order to use this tool.
Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-12-04 : 07:42:45
Not on your server(s), just where you install the tool, generally you would not install this on a server (especially as it is in beta)
Go to Top of Page
   

- Advertisement -