[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 739
  • Last Modified:

Why is Microsoft SQL Server 2005 Best Practices Analyzer reporting that I have an outdated system driver?

The report shows the following.

Outdated system driver [C:\WINDOWS\system32\ntkrnlpa.exe] of System [CRM1] that can cause paging detected. File version is [5.2.3790.4035]

The version of the file is 5.2.3790.4035 and I believe that this is the latest version. Is there a later versiobn of this file that I'm unaware of.
0
MDAVIS-BATER
Asked:
MDAVIS-BATER
  • 5
  • 3
1 Solution
 
Mark WillsTopic AdvisorCommented:
Depends on the version of the op system...

4035 was realeased in March 2007 as a security update. There has been more recent versions...

for example, there is a hot fix version ; Ntkrnlpa.exe 5.2.3790.4301  27-May-2008  and because it is not "formally" released (ie it is a hotfix), then there is a more recent version, but just not part of the public / service pack down loads yet...

see : http://support.microsoft.com/kb/953600
0
 
MDAVIS-BATERAuthor Commented:
So  your saying that the  Microsoft SQL Server 2005 Best Practices Analyzer is aware of this hotfix although it has not been publically made available yet?
0
 
Mark WillsTopic AdvisorCommented:
Sounds a bit like it...  Hotfixes are available to the public if there is a requirement for it, it is a "pull" release though (ie you have to ask). But, what I am saying is, it is checking each version that is available (regardless), I do not think it is cleaver enough to determine / ascertain if it is public domain or not, or, if you may need it or not. And that was just the one instance I found, there may have been in-between releases.

I guess the bottom line is the analyzer was correct. It does seem that there is a more recent version available... It is supposed to alert you to these incidents, and allow you the opportunity to uprade - but only if appropriate, it cannot decide that for you, just bring it to your attention. Would be good if it gave you the direct link, but then, would be bypassing the whole Hotfix > Cumulative Update > Service Pack philosphy of MS releases.

The tool was updated Jan / Feb 2008 (version  9.00.1007.00) and did have a few improvements, including (I thought) reasons for the "rules" and better documentation - one of the "big" improvements was explanations for the rules and the addition of about 60 new rules...

It has been updated again in August (mainly for SQL2008), and is available from : http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63&displaylang=en 

0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
Mark WillsTopic AdvisorCommented:
Found these couple of postings from the team weblog - describes what we are discussing... from the program manager himself...

Paul A. Mestemaker II
Program Manager
SQLCAT - Best Practices

the full article is : http://blogs.msdn.com/sqlcat/archive/2008/01/18/sql-server-2005-best-practices-analyzer-january-2008-now-available.aspx
scott_a said:  
So I have 1 critical issue but in order to resolve it, apply some hotfixes, I have to log a support request with Microsoft.
 
Surely if it is a recommended best practice I should be able to download the hotfixes without opening a support request with Microsoft. The how to resolve it link points to the following KB's  937745, 933564, 927396 or says I should simply apply cumulative update 3 which also isn't available for download.
 
This is the text for the critical issue:
 
"On versions of SQL Server before 9.0.3171.0, a known issue can degrade query performance on 32-bit and 64-bit systems with 2 gigabytes (GB) or more of memory..."
 
??
 
Scott
 
# January 22, 2008 5:28 PM 
Paul Mestemaker said:  
Hey Scott,
 
Thanks for your feedback.  SQL BPA is a tool meant to identify *potential* causes of problems as determined by Microsoft.  We think it's pretty good, but cannot perfectly detect 100% of issues.  If we could detect when something is definitely wrong, we'd just build that logic into SQL Server itself.
 
In this specific instance, it is a very broad recommendation (every 64-bit server below 9.0.3171.0 with 2+GB of memory)... the fix is to get a CU that you can request from the web.  Cumulative Updates are, well, cumulative :).... so you can request CU#5 from the web... or if you don't want to pick up the other fixes, you can probably call CSS and request access to CU#3.
 
CU#5 Knowledge Base:
 
http://support.microsoft.com/kb/943656
 
CU#5 Download:
 
http://go.microsoft.com/?linkid=6294451
 
There are risks associated with changing your environment without proper levels of testing.  So please keep that in mind.
 
Paul A. Mestemaker II
Program Manager
SQLCAT - Best Practices
 
# January 22, 2008 6:23 PM 

Open in new window

0
 
MDAVIS-BATERAuthor Commented:
Hi Mark,

I have the August 2008 version installed (9.0.242.0). I don't know if I am getting the memory issue at this stage, I might know if I apply SP2 on SQL2005.
0
 
Mark WillsTopic AdvisorCommented:
Sorry, did not explain why I included that.

That was an example of the BPA suggesting a newer version which was a hotfix or a Cumulative Upgrade. Was not suggesting that it was the same reason, just another example of BPA finding a "later version", and the Program Managers rationale saying that it will do that ie suggest a new version which is a hotfix (which is what happened to you albeit a different hotfix) or a CU where you need to request it from MS.

Does that make sense ?
0
 
MDAVIS-BATERAuthor Commented:
Yes that does make sense. I think I will wait for SP2 to be installed then I will re-look at this issue. SP2 logs errors in the event log. If I start getting the issues then I will request the hotfix.
0
 
Mark WillsTopic AdvisorCommented:
Definitely update to SP2 if not already done so. Mind you there are a few new hotfixes that BPA might still report on. And really, would not worry too much if it does, just use it as a guide and decide if the reasons for the hotfix is something that concerns you "now" versus waiting for the next SP release.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now