Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
Hash Match Left Semi Join
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT[base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECTCONTAINS))
Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> Hash Match Left Semi Join
> HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW 0
> 1.0
> |--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT[base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECTCONTAINS))
|||Thanks. I did check in event viewer and came across this warning when I tried
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:

> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application log
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> 0.42534244
>
>
|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/default...b;en-us;317746
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried[vbcol=seagreen]
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
or[vbcol=seagreen]
log[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),[vbcol=seagreen]
0[vbcol=seagreen]
[zz].[zz][vbcol=seagreen]

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].&#
91;KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
Hash Match Left Semi Join
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT[base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[
zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECTCONTAINS))Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz
].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
> Hash Match Left Semi Join
> HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.
0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW
0
> 1.0
> |--Clustered Index Scan(OBJECT[base].[dbo].[zz].[
PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT[base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].
1;zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECTCONTAINS))|||Thanks. I did check in event viewer and came across this warning when I trie
d
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:

> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application lo
g
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> 0.42534244
>
>|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/defaul...kb;en-us;317746
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried[vbcol=seagreen]
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
>
or[vbcol=seagreen]
log[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),[vbcol=seagreen]
0[vbcol=seagreen]
[zz].[zz][vbcol=seagreen]

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
Hash Match Left Semi Join
HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT:([base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECT:(CONTAINS))Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> Hash Match Left Semi Join
> HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW 0
> 1.0
> |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT:([base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECT:(CONTAINS))|||Thanks. I did check in event viewer and came across this warning when I tried
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:
> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application log
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> > Hi
> >
> > I am testing the usage of FULL TEXT feature and somehow it is not working
> > for me.
> > I have 2 rows in a table zz with values
> > this is a sta test
> > test
> >
> > Now when I run the following query I do not get any rows back
> > but the full text index is used.
> >
> > select zz from zz where contains ( *,'sta')
> > |--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> > Hash Match Left Semi Join
> > HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> > 0.0 2.4346894E-2 36
> 0.42534244
> > [zz].[zz] NULL PLAN_ROW 0
> > 1.0
> > |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> > 40 4 3
> > Clustered Index Scan Clustered Index Scan
> > OBJECT:([base].[dbo].[zz].[PK_zz])
> > [zz].[zz] 2.0 3.7578501E-2
> > 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> > NULL PLAN_ROW 0 1.0
> > |--Remote Scan(OBJECT:(CONTAINS))
>
>|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
> > Can you post the results of the following queries?
> >
> > select FulltextCatalogProperty('CatalogName', 'ItemCount')
> >
> > replacing CatalogName with the name of your catalog. If the value is 1
or
> > the number of tables you are full text indexing you will have to run a
> > population. If you have already run a population, check the application
log
> > using event viewer to see if there are error messages from MSSCI or
> > MSSearch.
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> > "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote
in
> > message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> > > Hi
> > >
> > > I am testing the usage of FULL TEXT feature and somehow it is not
working
> > > for me.
> > > I have 2 rows in a table zz with values
> > > this is a sta test
> > > test
> > >
> > > Now when I run the following query I do not get any rows back
> > > but the full text index is used.
> > >
> > > select zz from zz where contains ( *,'sta')
> > > |--Hash Match(Left Semi Join,
HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> > > Hash Match Left Semi Join
> > > HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> > > 0.0 2.4346894E-2 36
> > 0.42534244
> > > [zz].[zz] NULL PLAN_ROW
0
> > > 1.0
> > > |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> > > 40 4 3
> > > Clustered Index Scan Clustered Index Scan
> > > OBJECT:([base].[dbo].[zz].[PK_zz])
> > > [zz].[zz] 2.0 3.7578501E-2
> > > 8.0700003E-5 76 3.7659202E-2
[zz].[zz]
> > > NULL PLAN_ROW 0 1.0
> > > |--Remote Scan(OBJECT:(CONTAINS))
> >
> >
> >

Full text memory usage

Hi
I work with SQL 2005 and I know how it uses RAM but I know just some basic
stuff about Full-text catalogs and since we plan to implement them in the
future I need to know a few things.
1. Can you set min and max memory for full text service like it can be set
for SQL service?
2. Does it start using RAM as it needs it until it hits maximum and then
release it only if some other process needs RAM like SQL does?
3. How much RAM could be expected for Full text sevice to use on 20GB
catalog? (just estimate)
4. On x86 windows, full text service is limited to max 3GB of RAM (with /3GB
switch in boot.ini probably). Is on x64 Windows limitation 4GB and on IA64
there is no such limitations? Can you confirm that?
Thanks
Tom
answers inline.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tom" <tomman@.hotmail.com> wrote in message
news:OI3fNNUfHHA.444@.TK2MSFTNGP04.phx.gbl...
> Hi
> I work with SQL 2005 and I know how it uses RAM but I know just some basic
> stuff about Full-text catalogs and since we plan to implement them in the
> future I need to know a few things.
> 1. Can you set min and max memory for full text service like it can be set
> for SQL service?
No.
> 2. Does it start using RAM as it needs it until it hits maximum and then
> release it only if some other process needs RAM like SQL does?
Not really, like any other windows application it can see up to 2 Gigs on a
32 bit system, on a 64 bit system it may see then entire physical memory. It
uses what it needs. Depending on the other applications running on this
server its working memory set may be paged to disk. It makes extensive use
of the file system cache.

> 3. How much RAM could be expected for Full text sevice to use on 20GB
> catalog? (just estimate)
We have about 12 20 gig catalogs - memory used is 40 Mgs.
That depends on your queries mainly. The indexer runs in process with SQL
Server.
> 4. On x86 windows, full text service is limited to max 3GB of RAM (with
> /3GB switch in boot.ini probably). Is on x64 Windows limitation 4GB and on
> IA64 there is no such limitations? Can you confirm that?
That is correct on 64 bit systems applications provided they are coded for
it can see the entire physical ram. So your entire catalogs could be in ram
on systems with larger memory.
>
> Thanks
> Tom
>
|||With SQL Server 2005, you typically will try to limit it to not starve the
OS. So, in an X64 environment with 12GB -- I might give 10 to SQL and allow
2 for the OS (everything else).
When you introduce full-text on this system of total 12GB, how do you
prevent FTE from starving the OS?
So, I would set 8GB for SQL and leave 4GB for the OS+FTE+everything else.
Is there nothing to guarentee that FTE doesn't over utilize that 4GB and
cause OS level latency?
I thought there might be some level of governing this by using the:
ft crawl bandwidth (max) & ft notify bandwidth (max)
sp_configure options but it doesn't seem that is what the purpose of those
are for.
Thanks,
Robert Towne
|||the full-text engine does not compete with the OS. SQL Server will complete
with other application, like sql fts. Set
sp_configure 'max server memory'
to 2 gigs less than the total memory, so fts has enough memory to operate.
"sql411@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
message news:0988A377-5262-4986-98CF-17BAAD4C9D32@.microsoft.com...
> With SQL Server 2005, you typically will try to limit it to not starve the
> OS. So, in an X64 environment with 12GB -- I might give 10 to SQL and
> allow
> 2 for the OS (everything else).
> When you introduce full-text on this system of total 12GB, how do you
> prevent FTE from starving the OS?
> So, I would set 8GB for SQL and leave 4GB for the OS+FTE+everything else.
> Is there nothing to guarentee that FTE doesn't over utilize that 4GB and
> cause OS level latency?
> I thought there might be some level of governing this by using the:
> ft crawl bandwidth (max) & ft notify bandwidth (max)
> sp_configure options but it doesn't seem that is what the purpose of those
> are for.
>
> Thanks,
> Robert Towne
>
|||OK, i was thinking that FTE in 2005 ran in a seperate memory space than what
is specified in SQL Server's 'max server memory'. Very helpful to know &
many thanks..
"Hilary Cotter" wrote:

> the full-text engine does not compete with the OS. SQL Server will complete
> with other application, like sql fts. Set
> sp_configure 'max server memory'
> to 2 gigs less than the total memory, so fts has enough memory to operate.
>
|||I thought the same as Robert.
So if FTS operates with large full-text indexes they will be cached in
memory space under SQLService?
How can I determin how much memory that SQL uses is actually used for
full-text catalog and how much for other data?
I usually use "Database pages" counter to see how much data and indexes are
cached in RAM.
Tom
"sql411@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
message news:4A8CC880-DB65-4DBA-8EDE-A67BB88DF9FE@.microsoft.com...
> OK, i was thinking that FTE in 2005 ran in a seperate memory space than
> what
> is specified in SQL Server's 'max server memory'. Very helpful to know &
> many thanks..
> "Hilary Cotter" wrote:
>
|||SQL FTE doesn't use much ram, but SQL Server will apply memory pressure on
all other applications on this box. That is why it is important to cap sql
server so SQL FTE has room to operate.
I don't think ms has exposed counters to determine how much memory of the
SQL Engine SQL FTS uses (some of the indexing operations are integrated into
the engine), but the indexes are not caches in SQL Server's data cache. They
are part of the file system cache.
"Tom" <tomman@.hotmail.com> wrote in message
news:ur1wkEzgHHA.4064@.TK2MSFTNGP02.phx.gbl...
>I thought the same as Robert.
> So if FTS operates with large full-text indexes they will be cached in
> memory space under SQLService?
> How can I determin how much memory that SQL uses is actually used for
> full-text catalog and how much for other data?
> I usually use "Database pages" counter to see how much data and indexes
> are cached in RAM.
> Tom
>
> "sql411@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
> message news:4A8CC880-DB65-4DBA-8EDE-A67BB88DF9FE@.microsoft.com...
>