Maximum FT Catalogs per server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

henderson - 09 Oct 2006 17:14 GMT

Hello, I am trying to see what the limit is on creating FT catalogs per
server. I have found 2 Non MS links stating 256 catalogs per server, but I
really need to confirm this.

Thanks for your help

Reply to this Message

Simon Sabin - 10 Oct 2006 21:40 GMT

Hello henderson,

After 7 minutes I'm at 1700 catalogs, so I guess the 256 is not true. This
is on a Sql2005 server (my laptop)
If you want to see the limit try this

declare @name varchar(100)
declare @i int
set @i = 0
while @i < 10000

begin
set @name = 'catalog' + cast(@i as varchar(10))
exec ('create fulltext catalog ' + @name )
set @i = @i + 1
end

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Hello, I am trying to see what the limit is on creating FT catalogs
> per server. I have found 2 Non MS links stating 256 catalogs per
> server, but I really need to confirm this.
>
> Thanks for your help

Reply to this Message

jtkane@gmail.com - 10 Oct 2006 22:41 GMT

Simon,
The 256 FT Catalog limit is specifc to SQL Server 7.0 and SQL Server
2000 and not a limiting factor in SQL Server 2005. Note, many FTS
issues are SQL Server and OS-platform specific. I've long known about
this limit and while there are to the best of my knowledge no specific
KB article from Microsoft on this limit, I have found the following
quotes and links on Microsoft.com and Support.Microsoft.com:

There is a hard limit of 256 search catalogs per server;
http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stse
08.mspx?mfr=true

However, I find the below quote in the offical Microsoft SQL Support
white paper on deploying FTS using SQL Server 2000:
"You can create a maximum of 256 full-text catalogs on each server."
SQL Server 2000 Full-Text Search Deployment white paper
http://support.microsoft.com/kb/323739

Thanks,
John

SQL Full Text Search Blog
http://jtkane.spaces.live.com/

> Hello henderson,
>
[quoted text clipped - 22 lines]
> >
> > Thanks for your help

Reply to this Message

henderson - 11 Oct 2006 15:41 GMT

Thank you both for your help in this. I should have clarified that I am using
sql server 2000. Anyway. Thanks again. It is really appreaciated!!!!!

> Simon,
> The 256 FT Catalog limit is specifc to SQL Server 7.0 and SQL Server
[quoted text clipped - 45 lines]
> > >
> > > Thanks for your help

Reply to this Message