Yukon Stability

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 11 Oct 2004 17:14 GMT

We're about to deploy a new application, based primarily on FTS.
Because it is an isolated use, I'd like to take advantage of the FTS
features in Yukon. Is Yukon stable enough to go into a limited
production environment? I understand that there is at least one more
beta release to go.

We'd put it on its on server, etc. It would only be used for the FTS
queries, tables, etc.

Thanks ahead of time.

Rob

Reply to this Message

John Kane - 11 Oct 2004 17:36 GMT

Rob,
That's a tough question to answer... Yes, SQL Server 2005 (Yukon) is
currently in Beta2 and there will be another beta (Beta3) either late this
year or early next year with RTM officially announced as sometime in the 1st
half of 2005. Yukon Beta2 is "feature complete" and this includes the FTS
functionality with new features and improved performance for FT Indexing and
Search. However, SQL Server 2005 is still a beta product and unless you have
talked to Microsoft to get addition support using a beta product, I would
hesitate to recommend that you use this version in a production environment
as what you do if something other than FTS broke and you had a "server down"
situation? Microsoft typically does not support beta products and while I'm
very positive you can get support for many issues in these newsgroups, it is
nothing like direct support that Microsoft can provide to you in case of a
"server down".

What SQL Server 20005 FTS features &/or issues are compelling you to
implement Yukon in a production environment that cannot be done using SQL
Server 2000 FTS?

Thanks,
John

> We're about to deploy a new application, based primarily on FTS.
> Because it is an isolated use, I'd like to take advantage of the FTS
[quoted text clipped - 8 lines]
>
> Rob

Reply to this Message

Rob - 18 Oct 2004 01:23 GMT

Mostly the performance gains, and the multi-column ranking /
weighting. I'd have Yukon on its own box, and only use it for the FTS
ability. It's an more or less standalone feature on our site, and
we'd let the public know that it was "beta".

> Rob,
> That's a tough question to answer... Yes, SQL Server 2005 (Yukon) is
[quoted text clipped - 30 lines]
> >
> > Rob

Reply to this Message

John Kane - 22 Oct 2004 18:48 GMT

Rob,
Yes, the SQL Sever 2005 (Yukon) FT Indexing performance gains are very
significant and order-of-magnitude better than SQL Server 2000. However,
this gain is only of benefit if you are FT Indexing a table with millions of
rows (20+ million). Are you FT Indexing tables of this size? Yes, you can
have both SQL Server 2000 and Yukon (as a named instance) on the same box,
but I'd very careful and would not recommend that you install SQL Sever 2005
(beta2) on the same machine as SQL Server 2000 as Yukon will in some way
affect your SQL Server 2000 functionality as there are specific beta issues
related to SQL-DMO not working correctly in this environment.

Let me know, if you have any other Yukon FTS questions.
Thanks,
John

> Mostly the performance gains, and the multi-column ranking /
> weighting. I'd have Yukon on its own box, and only use it for the FTS
[quoted text clipped - 35 lines]
> > >
> > > Rob

Reply to this Message