Wednesday, March 7, 2012

AWE and the SP4...

When the SQL Server SP4 was released I was informed it had some issues with
AWE.
Is those issues are still exist? Is it safe to installs SP4? My SQL Server
installation left with default AWE settings (value of 0). Since AWE is not
enabled, applying SP4 should not be any issue in my case.
Thanks,
Larry
Hi
No problem for you. You do not have to apply the patch to bring you to
version 2040 from 2039
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
> When the SQL Server SP4 was released I was informed it had some issues
> with
> AWE.
> Is those issues are still exist? Is it safe to installs SP4? My SQL
> Server
> installation left with default AWE settings (value of 0). Since AWE is
> not
> enabled, applying SP4 should not be any issue in my case.
> Thanks,
> Larry
>
|||You are suggesting that I can live without SP4?
See the link below what Microsoft says....
http://www.microsoft.com/sql/techinf...sqlserver.mspx
This link prompted me to apply the SP4.
What is version 2039/2040? My SQL Server installation says 8.00.760
?
Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi
> No problem for you. You do not have to apply the patch to bring you to
> version 2040 from 2039
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:O0GnXdgxFHA.2136@.TK2MSFTNGP10.phx.gbl...
>
|||Hi
No. Apply SP4, but if you are not using AWE memory, you do not have to apply
the hotfix to SP4 to fix the AWE memory issue.
8.00.2039 = SP4
You currently have SP3 installed.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
> You are suggesting that I can live without SP4?
> See the link below what Microsoft says....
> http://www.microsoft.com/sql/techinf...sqlserver.mspx
> This link prompted me to apply the SP4.
> What is version 2039/2040? My SQL Server installation says 8.00.760
> ?
> Thank you,
> Larry
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:Oj%23tNugxFHA.2212@.TK2MSFTNGP15.phx.gbl...
>
|||Thank you for the suggestion.
How did you derive the equation "8.00.2039 = SP4" ?
Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23u786BhxFHA.3188@.TK2MSFTNGP14.phx.gbl...
> Hi
> No. Apply SP4, but if you are not using AWE memory, you do not have to
apply[vbcol=seagreen]
> the hotfix to SP4 to fix the AWE memory issue.
> 8.00.2039 = SP4
> You currently have SP3 installed.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:e67oU$gxFHA.3300@.TK2MSFTNGP09.phx.gbl...
http://www.microsoft.com/sql/techinf...sqlserver.mspx[vbcol=seagreen]
issues[vbcol=seagreen]
is
>
|||Hi
The outdated list http://www.aspfaq.com/show.asp?id=2160 and
http://support.microsoft.com/default...b;en-us;321185 and from
installing it and looking at the version numbers.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OaYHIGhxFHA.2728@.TK2MSFTNGP14.phx.gbl...
> Thank you for the suggestion.
> How did you derive the equation "8.00.2039 = SP4" ?
> Thank you,
> Larry
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23u786BhxFHA.3188@.TK2MSFTNGP14.phx.gbl...
> apply
> http://www.microsoft.com/sql/techinf...sqlserver.mspx
> issues
> is
>
|||Thank you,
Larry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:epVvHNhxFHA.3236@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> The outdated list http://www.aspfaq.com/show.asp?id=2160 and
> http://support.microsoft.com/default...b;en-us;321185 and from
> installing it and looking at the version numbers.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
> news:OaYHIGhxFHA.2728@.TK2MSFTNGP14.phx.gbl...
http://www.microsoft.com/sql/techinf...sqlserver.mspx[vbcol=seagreen]
to[vbcol=seagreen]
SQL[vbcol=seagreen]
AWE
>

No comments:

Post a Comment