Re: Yukon Stability
From: John Kane (jt-kane_at_comcast.net)
Date: 10/22/04
- Next message: John Kane: "Re: Incremental population stops"
- Previous message: John Kane: "Re: FTS ON View in Yukon ?"
- In reply to: Rob: "Re: Yukon Stability"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 22 Oct 2004 10:48:30 -0700
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
"Rob" <robnews@iGive.com> wrote in message
news:f0823485.0410171623.1e30724f@posting.google.com...
> 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".
>
> "John Kane" <jt-kane@comcast.net> wrote in message
news:<#GxBEC7rEHA.2328@TK2MSFTNGP10.phx.gbl>...
> > 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
> >
> >
> > "Rob" <robnews@iGive.com> wrote in message
> > news:f0823485.0410110814.8366024@posting.google.com...
> > > 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
- Next message: John Kane: "Re: Incremental population stops"
- Previous message: John Kane: "Re: FTS ON View in Yukon ?"
- In reply to: Rob: "Re: Yukon Stability"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
