December 23, 2008 at 11:51 am
We ran SQLBPA against our SQL Server 2005 EEx64(SP2)
on Windows 2003 x64(SP2). In SQLBPA we got some critical issues. One of them is as below:
Error Host: [...] - Outdated system driver that can cause paging detected ABC There are known issues that exist in Windows and various Device Drivers which can trigger conditions that result in working set of all processes currently running on the machine to be trimmed. This will cause excessive paging and result in drastic reduction in performance of all applications on the machine (specifically SQL Server).We found that TCPIP.SYS present with version [5.2.3790.4318] and BXVBDA.SYS is also present. So we recommend you to disable TCP Chimney.
To disable TCP chimney I followed below steps:
To disable TCP Chimney apply either the Windows Server 2003 patch in this article http://support.microsoft.com/default.aspx?scid=kb;EN-US;948496 or use the following manual steps:
1. Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
2. Double-click the EnableTCPChimney registry entry.
3. In the Edit DWORD Value dialog box, type 0 in the Value data box, and then click OK.
4. Restart the server.
But Step3 we already have the DWORD value as 0. So why the SQLBPA is again recommending to disable TCP chimney as it is already disabled
plz advice me
December 23, 2008 at 3:09 pm
I guess it wants you to update the driver too.
* Noel
December 23, 2008 at 4:27 pm
could you please tell me what kind of drivers do I need to update
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply