{"id":290,"date":"2014-10-28T10:15:52","date_gmt":"2014-10-28T09:15:52","guid":{"rendered":"http:\/\/www.codereview.co\/?p=290"},"modified":"2014-10-24T09:28:16","modified_gmt":"2014-10-24T08:28:16","slug":"location-of-full-text-temporary-folder-in-sql-server","status":"publish","type":"post","link":"http:\/\/www.codereview.co\/index.php\/sql-server-tutorials\/location-of-full-text-temporary-folder-in-sql-server\/","title":{"rendered":"Location of full text temporary folder in SQL Server"},"content":{"rendered":"<p><span style=\"color: #000000;\"><strong>Scenario<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">The process of creating, building, and maintaining full-text search capabilities is quite a daunting task. During the installation of Full-Text Search for SQL Server 2000, one of the folders gets installed in a not-so-conspicuous location that could potentially be troublesome as the server gets busier. To get a good start on building and maintaining an efficient Full-Text Search process, move the temporary folder used by the Microsoft Search service.<\/span><span style=\"color: #000000;\"><strong>\u00a0<\/strong><\/span><!--more--><\/p>\n<p><span style=\"color: #000000;\"><strong>Solution<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">One of the easiest things you can do to optimize your full-text process is to change the location of the Gatherer Service&#8217;s temporary folder. This folder is created in one of two locations during the installation of SQL Server:<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\">The Temporary folder of the user account that was used to <strong>install<\/strong> SQL Server (i.e., C:\\Documents and Settings\\timcullen\\Local Settings\\Temp\\gthrsvc)<\/span><\/li>\n<li><span style=\"color: #000000;\">C:\\WINDOWS\\TEMP\\gthrsvc<\/span><\/li>\n<\/ul>\n<p><span style=\"color: #000000;\">To find out where this folder was installed, choose the server in Enterprise Manager, expand <em>Support Services<\/em>, right-click <em>Full-Text Search<\/em>, and choose <em>Properties<\/em>:<\/span><\/p>\n<p><span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-293\" src=\"http:\/\/i2.wp.com\/www.codereview.co\/wp-content\/uploads\/2014\/10\/18.jpg?resize=272%2C300\" alt=\"1\" srcset=\"http:\/\/i2.wp.com\/www.codereview.co\/wp-content\/uploads\/2014\/10\/18.jpg?resize=272%2C300 272w, http:\/\/www.codereview.co\/wp-content\/uploads\/2014\/10\/18.jpg 402w\" sizes=\"(max-width: 272px) 100vw, 272px\" data-recalc-dims=\"1\" \/><\/span><\/p>\n<p><span style=\"color: #000000;\">As you can see by the location, it is easy to overlook this location when specifying exception folders in anti-virus software. To fix this you can either include the location exclusion in your server build documentation to make sure it&#8217;s not missed, or move the folder. The latter option is likely the best option, since writing to this folder will compete for I\/O with all of the other operating system requests. If possible, move the folder to its own physical disk array; if not possible, then move it to another physical disk array, since the process of building and populating full-text catalogs is I\/O intensive. To move the full-text temporary folder, use the <strong>SetTempPath.vbs<\/strong> file. This file is most often in the C:\\Program Files\\Common Files\\System\\MSSearch\\Bin folder. Once you&#8217;ve decided where to move the folder, open a command prompt and navigate to the folder where the .vbs file is located and type <strong>cscript SetTempPath.vbs &#8220;<em>newfolderlocation<\/em>&#8220;<\/strong>:<\/span><\/p>\n<p><span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone  wp-image-294\" src=\"http:\/\/i0.wp.com\/www.codereview.co\/wp-content\/uploads\/2014\/10\/26.jpg?resize=341%2C125\" alt=\"2\" srcset=\"http:\/\/i0.wp.com\/www.codereview.co\/wp-content\/uploads\/2014\/10\/26.jpg?resize=341%2C125 300w, http:\/\/www.codereview.co\/wp-content\/uploads\/2014\/10\/26.jpg 607w\" sizes=\"(max-width: 341px) 100vw, 341px\" data-recalc-dims=\"1\" \/><\/span><\/p>\n<p><span style=\"color: #000000;\">Once you successfully change the location of the temporary folder you must re-start the service for it to take effect. Also, you cannot put the folder directly on a drive (i.e., C:\\-it must be one level down), and you cannot put it in the same folder location as the pagefile.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>Thanks for reading this article,<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Next steps :<\/strong><\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><b><strong>Add this article to your database toolkit<\/strong><\/b><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>Share this with your colleagues because Sharing is Learning<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>Comment below if you need any assistance<\/strong><\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Scenario The process of creating, building, and maintaining full-text search capabilities is quite a daunting task. During the installation of Full-Text Search for SQL Server 2000, one of the folders gets installed in a not-so-conspicuous location that could potentially be troublesome as the server gets busier. To get a good start on building and maintaining [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,32,3],"tags":[152,153,13,12,151],"_links":{"self":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/290"}],"collection":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/comments?post=290"}],"version-history":[{"count":5,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/290\/revisions"}],"predecessor-version":[{"id":401,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/posts\/290\/revisions\/401"}],"wp:attachment":[{"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/media?parent=290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/categories?post=290"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.codereview.co\/index.php\/wp-json\/wp\/v2\/tags?post=290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}