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

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

# Rob said:

Suggestion for the next release (SQL2008) - allow end user to set a specific date to scan back to.  It has been extremely frustrating to correct an issue only to have it show up again in new scans.  So, if I fixed all the issues a month ago and I want to see only what the new issues are, I set that date as the starting point.  Selecting "Do not this issue again..." is not enough because I want to know if the same issue crops back up.

11 August 08 at 7:50 AM

# cool4now said:

Running the upgraded BPA on the same servers I ran the previous version on, I am now getting the Outdated system driver at [C:\WINDOWS\system32\ntoskrnl.exe] error with file version 5.2.3790.4035.  How could the latest SP have an outdated system drivers?  I am getting this on 2003 x86 32-bit R2 Enterprise with SQL Server 2005 Enterprise and 2003 x86 32-bit R2 Standard with SQL 2005 Developer, both O/S running w/SP2 and SQL 2005 SP2.  Is this a bug?

26 August 08 at 2:13 PM

# Rob said:

Is it possible to completely clear all results of scans and basically reset SQLBPA to the point when it was first installed?  Issues I have corrected continue to appear even though i believe I have corrected them.  I don't want to ignore the issue because I want to be sure I actually corrected the problem.  Uninstalling and reinstalling does not seem to clear out results.  Deleting all the repost files also does not clear the results.  Where are the results stored?

05 September 08 at 9:42 AM

# Don Cavin said:

1)  Can you clear out your event logs to avoid the situation of seeing old (but corrected errors)?

2)  Is there some ability to extend the bpa, to setup your own rules, etc.?  That would be helpful...something similar to the Oracle Enterprise Manager where you could write your own tcl code to define your own threshold and rules relative to your specific information?

Thanks,

Don Cavin

xwave

10 September 08 at 5:32 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.

Name (required) 

Your URL (optional)

Comments (required) 

  

Enter Code Here: Required

Remember Me?

About Paul Mestemaker