{"id":1105,"date":"2005-08-08T15:12:00","date_gmt":"2005-08-08T20:12:00","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=1105"},"modified":"2005-08-08T15:12:00","modified_gmt":"2005-08-08T20:12:00","slug":"sp4-might-slow-down-your-single-instance-of-sql-server-2000","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/","title":{"rendered":"SP4 might slow down your single instance of sql server 2000"},"content":{"rendered":"

if  Address Windowing Extensions<\/A>(AWE) has been enabled on a single instance of sql server 2000, after applying SP4, you got to apply .2040 hotfix as well, otherwise your SQL server instance only uses 50% of the available physical memory <\/U><\/STRONG>that sucks:).<\/SPAN><\/P>
\n

1) run the following script from SQL Query Analyzer to determine if AWE is enabled on the server<\/STRONG><\/SPAN> :<\/o:p><\/STRONG><\/SPAN><\/SPAN><\/EM><\/P>
\n

sp_configure ‘show advanced options’, 1
go
reconfigure
go
sp_configure ‘awe enabled’
go
<\/SPAN><\/P>
\n

If run_value<\/B> is set to 1, AWE is enabled on the server.<\/FONT>
<\/P><\/SPAN>
\n

2) BTW <\/SPAN>After applying the SP4, just make sure that it has been installed properly as I\u2019ve heard that some broken installations of SP4 are not reported properly. Run the following query in Analyzer and you should get the following results.<\/o:p><\/SPAN><\/P>
\n

 <\/o:p><\/SPAN>Query in Query Analyzer:<\/o:p><\/STRONG><\/SPAN><\/I><\/P>
\n

SELECT SERVERPROPERTY(‘productversion’) 
SELECT SERVERPROPERTY(‘productlevel’)<\/o:p><\/SPAN><\/P>
\n

Result after applying SP4:<\/o:p><\/STRONG><\/SPAN><\/I><\/P>
\n

 <\/o:p><\/SPAN>8.00.2039 
SP4<\/o:p><\/SPAN><\/P>
\n

Result after applying SP4 and its hotfix :<\/o:p><\/STRONG><\/SPAN><\/P>
\n

 <\/o:p><\/SPAN>8.00.2040 
SP4<\/SPAN> <\/o:p><\/SPAN><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

if  Address Windowing Extensions(AWE) has been enabled on a single instance of sql server 2000, after applying SP4, you got to apply .2040 hotfix as well, otherwise your SQL server instance only uses 50% of the available physical memory that sucks:). 1) run the following script from SQL Query Analyzer to determine if AWE is enabled on […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1105","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/comments?post=1105"}],"version-history":[{"count":0,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/posts\/1105\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/media?parent=1105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/categories?post=1105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.devhorizon.com\/reza\/wp-json\/wp\/v2\/tags?post=1105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}