INF: Change the Location of Temporary Files for Full-Text Searches (817296)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
IMPORTANT: This article contains information about modifying the registry.
Before you modify the registry, make sure to back it up and make sure that you
understand how to restore the registry if a problem occurs. For information
about how to back up, restore, and edit the registry, click the following
article number to view the article in the Microsoft Knowledge Base: 256986 Description of the Microsoft Windows Registry SUMMARYThis article describes how to change the location of the
temporary files that are used during full-text searches of binary large objects
(BLOBs).MORE INFORMATIONBy default, the Microsoft Search service uses the default
full-text path for temporary storage when a full-text index is created on an
image column. Depending on the type of file (.doc, .htm, and other file types)
and the size of the file that is stored in the image column, the temporary
files may experience heavy use. This use causes high I/O activity and space
use. Because the system does not typically have the I/O throughput of a RAID
array, move the temporary storage location to a RAID 0 disk array.
Additionally, if possible, keep that location separate from the storage
location of your full-text catalogs.
In a default installation of SQL
Server 2000, the default full-text path is Program Files\Microsoft SQL
Server\Mssql\Ftdata. This path is used as both the location of temporary files
that are used when BLOB data is indexed and the default root path where new
full-text catalogs are created. You can change this path by editing the
following registry key:
Default instance: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\FullTextDefaultPath
Named instance: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer\FullTextDefaultPath
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using Registry
Editor incorrectly. Use Registry Editor at your own risk.
On Microsoft Windows 2000 Server-based computer
running Windows Clustering, the temporary folder must be on a local disk on
each node. Additionally, you must not set the path of the temporary files to
the same location as the page files of the server (Pagefile.sys). A script
named Settemppath.vbs was previously used to change this location. However,
Settemppath.vbs does not affect the temporary location for SQL Server 2000
full-text temporary files, but it may affect the temporary location for other
products that use the Microsoft Search service.
| Modification Type: | Major | Last Reviewed: | 6/13/2003 |
|---|
| Keywords: | kbinfo KB817296 kbAudDeveloper |
|---|
|