virtual memory though I
don't know how this option is set on your server. You can use Performance
Monitor to determine what resources are being used. For more information on
how to set Max Server Memory option affecting MSSearch, you can refer to
Microsoft SQL Server Books Online with the keyword 'Server Memory Options'
as the search topic.
If you have installed and are running the Full-Text Search support, then
you must set the max server memory option manually to leave enough memory
for the MSSearch service to run. Ideally, you want to allocate as much
memory as possible to SQL Server without causing the system to swap pages
to disk. As you increase the amount of SQL Server memory, ensure that there
is sufficient disk space to grow the
operating system's virtual memory
support file (Pagefile.sys) to accommodate additional memory. For
information about the virtual memory support file, see your
Windows NT
documentation. The amount of memory specified must be sufficient for the
SQL Server static memory needs (kernel overhead, open objects, locks, and
so on), as well as for the data cache (also called buffer cache). Use
statistics from
Windows NT Performance Monitor to help you adjust the
memory value if necessary. Change this value only when you add or remove
memory, or when you change how you use your system.
Please download the Component Checker under
http://www.microsoft.com/data
to check MDAC version. You can apply the latest MDAC version on your server
and try again.