{"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"],"yoast_head":"\nSP4 might slow down your single instance of sql server 2000 - Reza Alirezaei's Blog %<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Reza Alirezaei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/\"},\"author\":{\"name\":\"Reza Alirezaei\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"headline\":\"SP4 might slow down your single instance of sql server 2000\",\"datePublished\":\"2005-08-08T20:12:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/\"},\"wordCount\":163,\"commentCount\":0,\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/\",\"name\":\"SP4 might slow down your single instance of sql server 2000 - Reza Alirezaei's Blog %\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\"},\"datePublished\":\"2005-08-08T20:12:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/2005\\\/08\\\/08\\\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#website\",\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/\",\"name\":\"Reza Alirezaei's Blog\",\"description\":\"Blogging from the field!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/#\\\/schema\\\/person\\\/cdbb24d283697a65951cb4a14e474938\",\"name\":\"Reza Alirezaei\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g\",\"caption\":\"Reza Alirezaei\"},\"url\":\"https:\\\/\\\/blogs.devhorizon.com\\\/reza\\\/author\\\/rezaa\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SP4 might slow down your single instance of sql server 2000 - Reza Alirezaei's Blog %","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/","twitter_misc":{"Written by":"Reza Alirezaei","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/#article","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/"},"author":{"name":"Reza Alirezaei","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"headline":"SP4 might slow down your single instance of sql server 2000","datePublished":"2005-08-08T20:12:00+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/"},"wordCount":163,"commentCount":0,"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/","url":"https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/","name":"SP4 might slow down your single instance of sql server 2000 - Reza Alirezaei's Blog %","isPartOf":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#website"},"datePublished":"2005-08-08T20:12:00+00:00","author":{"@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.devhorizon.com\/reza\/2005\/08\/08\/sp4-might-slow-down-your-single-instance-of-sql-server-2000\/"]}]},{"@type":"WebSite","@id":"https:\/\/blogs.devhorizon.com\/reza\/#website","url":"https:\/\/blogs.devhorizon.com\/reza\/","name":"Reza Alirezaei's Blog","description":"Blogging from the field!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.devhorizon.com\/reza\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.devhorizon.com\/reza\/#\/schema\/person\/cdbb24d283697a65951cb4a14e474938","name":"Reza Alirezaei","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ba940d84e0ecb909e62e93df4c56daf0395c7e53c914467ab2ee73124a7d7b6?s=96&d=mm&r=g","caption":"Reza Alirezaei"},"url":"https:\/\/blogs.devhorizon.com\/reza\/author\/rezaa\/"}]}},"_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}]}}