18 January 2008

SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!

It's a new year and, with it, we come bearing gifts!  We have a pretty significant update to SQL Server 2005 Best Practices Analyzer.  It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools.  And all of these rules have rich documentation telling you what need to know.

Here is the official announcement:

http://blogs.msdn.com/sqlcat/archive/2008/01/18/sql-server-2005-best-practices-analyzer-january-2008-now-available.aspx

Paul A. Mestemaker II
Program Manager
SQLCAT – Best Practices

Filed under: ,
 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Noticias externas said:

It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server

18 January 08 at 5:08 PM
# Imran said:

The BPA is not able to connect to a remote server or a Named instance on the local server. Is this by design?

24 January 08 at 9:25 AM
# Paul Mestemaker said:

Imran and I are discussing offline.  SQL Server 2005 BPA can only connect to SQL Server 2000 and 2005 based servers.  It cannot connec to SQL Server 2008.  If anybody else has issues with BPA, please submit a question to http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1.

-Paul

28 January 08 at 8:20 PM
# esmith1844 said:

In running the SQL 2005 BPA (Jan/08) I am getting a critical error.. Outdated system Driver that can cause paging detected - SQL Server Processes are Paged Out.. I have followed the directions updating the server BIOS, network card firmware and driver to the latest as well as the OS - TCPIS.SYS also identified in the issue description. I have also tried disabling the TCP Chimney Offload.. to no avail as I still get the 17890 error in the Application log of the server. The server is an HP DL 360 - G5, 32GB of RAM, W2K3 server x64, the server network cards are HP NC373i, SQL Server 2005 SP2 + Cumulative Updates to 3175.. .

Even with the latest of all of the above results in the same error 17890 - 'A significant part of sql server process memory has been paged out...' at start up.. any suggestions???

What do I do now???  Any suggestions?

20 February 08 at 12:02 PM
# Andre1602 said:

esmith1844 I have the exact same issue on a HP DL580 G5. Did you find a solution?

29 February 08 at 12:59 AM
# PaulB said:

We are also seeing error 17890 in our environment, any suggestions?

14 April 08 at 12:12 PM
# NM said:

Ditto, did anyone find a solution?

15 May 08 at 10:10 AM
# SQLMan said:

Having the exact same issue with a Dell 2950.  Any ideas anyone?

20 May 08 at 5:27 PM
# Fran said:

I'm trying to run SQL 2005 BPA 2008 against a SQL 2000 server but get the following error:

Dcom got error "<error description>" from the computer <computer name> when attempting to activate the server: <server component>8BC3F05E-D86B-11D0-A075-00C04FB68820

Has anyone had this problem?

Additional Info:

The server is running Windows NT 5.0 (Build 2195: Service Pack 4)

The SQL Server version is Microsoft SQL Server  2000 - 8.00.2039

02 June 08 at 11:04 AM
# Paul Mestemaker said:

For the 17890 errors... take a look in your event log to see when the last time it happened (Event ID 17890 in the Application event log).  Let's say it happened on Feb 1... you ran BPA on Feb 8... corrected the issue on Feb 15.  BPA will continue to detect the old entries in the event log.  If you do not see any new errors after Feb 15, you are ok.

-Paul

04 June 08 at 3:25 PM

Leave a Comment

Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.

(required) 
(optional)
(required) 

About Paul Mestemaker

I am a Program Manager on the SQL Server Manageability Team at Microsoft. I am a proud University of Michigan alumnus. I graduated with a business degree from the Stephen M. Ross School of Business in 2005.
Page view tracker