"Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in message
news:406a219f_4@news.athenanews.com...
> Hi,
>
> I am using a full-text catalog to perform search inside a 1GB table. I
> have created fulltext catalog as usual methods, selected the necessary
> fields for the catalog from the table. When I want to make a stress test
> over the search fucntion, it deoesnt return any data if I use more then 7
> concurrent connections.
>
> I heard that, this was a problem on sql server version 7. But this is
a
> sql server 2000 version. And from the white paper of full text catalogs,
it
> says it is able to handle up to 5124 concurrent connections to a fulltext
> catalog.
>
> What would be causing this ?
>
> PS: Computer's props: Dual P3 500 Mhz, 1GB Ram, 18 GB SCSI HDD, Win2k
> Server, Sql Server 2K Standard Ed. Computer only works for sql server
> processes, not other process bothers the computer.
>
> Thanks and Best Regards.
>
> Murtix Van Basten.
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:uALwGlsFEHA.692@TK2MSFTNGP09.phx.gbl...
> Murtix,
> When you say a "1GB Table", do you mean 1GB rows or the overall size of
this
> table? Also, how long are you waiting for the queries to return results
and
> what is the expected number of results per query? SQL FT Indexing and FT
> Search query performance is a function of the total number rows as well as
> the expected number of rows returned. Are you using the exact SQL FTS
query
> in each of the 7 concurrent connection or is each query different? Could
you
> post an example of your SQL FTS query?
>
> Also, what is the return value for this query: EXEC sp_fulltext_service
> 'resource_usage'
>
> Regards,
> John
>
>
>
> "Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in
message
> news:406a219f_4@news.athenanews.com...
> > Hi,
> >
> > I am using a full-text catalog to perform search inside a 1GB table.
I
> > have created fulltext catalog as usual methods, selected the necessary
> > fields for the catalog from the table. When I want to make a stress test
> > over the search fucntion, it deoesnt return any data if I use more then
7
> > concurrent connections.
> >
> > I heard that, this was a problem on sql server version 7. But this
is
> a
> > sql server 2000 version. And from the white paper of full text catalogs,
> it
> > says it is able to handle up to 5124 concurrent connections to a
fulltext
> > catalog.
> >
> > What would be causing this ?
> >
> > PS: Computer's props: Dual P3 500 Mhz, 1GB Ram, 18 GB SCSI HDD, Win2k
> > Server, Sql Server 2K Standard Ed. Computer only works for sql server
> > processes, not other process bothers the computer.
> >
> > Thanks and Best Regards.
> >
> > Murtix Van Basten.
> >
> >
>
>

"Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in message
news:406a6f30_5@news.athenanews.com...
> John,
>
> the table has 784.000 rows. Table has 19 columns, and most important
> column (BODY) is Long Text type. Only 5 columns are being used in the FTS
> indexing. That is one of them.
>
> when I run it as 1 concurrent user, it takes 3-5 seconds to get a
> result. I expect not more than 40 results per query. It can be less or
none.
> I use WAS Tool to run a stress test on the web[age that triggers the
query.
> And I use same exact parameters for each 7 concurrent connection. When I
put
> 8th one, the return is nothing.
>
> You can see the webpage that triggers the FTS from:
>
http://www.learnasp.com/search/a.asp?keyword=dsn&sortby=2&direction=1&list=aspngfreeforall&LangList=English&limit=40
>
> The FTS query is:
>
> SET @statement = 'SELECT TOP ' + @num_matches + ' ''1000'' As Rank,
list_,
> messageid_, M.creatstamp_, hdrfrom_, hdrsubject_' + ' FROM messages_ AS M
> INNER JOIN lists_ ON M.list_ = lists_.name_ ' + ' WHERE 1=1' + @add_pred
+
> @list_security + @lang_pred + @order_by
> -- Execute the SELECT statement.
> EXEC (@statement)
>
> messages_ is the table. If you wanna see, I can paste the whole SP.
>
> Regards.
>
> Murtix Van Basten.
>
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:uALwGlsFEHA.692@TK2MSFTNGP09.phx.gbl...
> > Murtix,
> > When you say a "1GB Table", do you mean 1GB rows or the overall size of
> this
> > table? Also, how long are you waiting for the queries to return results
> and
> > what is the expected number of results per query? SQL FT Indexing and FT
> > Search query performance is a function of the total number rows as well
as
> > the expected number of rows returned. Are you using the exact SQL FTS
> query
> > in each of the 7 concurrent connection or is each query different? Could
> you
> > post an example of your SQL FTS query?
> >
> > Also, what is the return value for this query: EXEC
sp_fulltext_service
> > 'resource_usage'
> >
> > Regards,
> > John
> >
> >
> >
> > "Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in
> message
> > news:406a219f_4@news.athenanews.com...
> > > Hi,
> > >
> > > I am using a full-text catalog to perform search inside a 1GB
table.
> I
> > > have created fulltext catalog as usual methods, selected the necessary
> > > fields for the catalog from the table. When I want to make a stress
test
> > > over the search fucntion, it deoesnt return any data if I use more
then
> 7
> > > concurrent connections.
> > >
> > > I heard that, this was a problem on sql server version 7. But this
> is
> > a
> > > sql server 2000 version. And from the white paper of full text
catalogs,
> > it
> > > says it is able to handle up to 5124 concurrent connections to a
> fulltext
> > > catalog.
> > >
> > > What would be causing this ?
> > >
> > > PS: Computer's props: Dual P3 500 Mhz, 1GB Ram, 18 GB SCSI HDD, Win2k
> > > Server, Sql Server 2K Standard Ed. Computer only works for sql server
> > > processes, not other process bothers the computer.
> > >
> > > Thanks and Best Regards.
> > >
> > > Murtix Van Basten.
> > >
> > >
> >
> >
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:ebtBRlyFEHA.3984@TK2MSFTNGP10.phx.gbl...
> can you paste the entire sp here?
>
> You aren't doing TSQL paging are you?
> "Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in
message
> news:406a6f30_5@news.athenanews.com...
> > John,
> >
> > the table has 784.000 rows. Table has 19 columns, and most important
> > column (BODY) is Long Text type. Only 5 columns are being used in the
FTS
> > indexing. That is one of them.
> >
> > when I run it as 1 concurrent user, it takes 3-5 seconds to get a
> > result. I expect not more than 40 results per query. It can be less or
> none.
> > I use WAS Tool to run a stress test on the web[age that triggers the
> query.
> > And I use same exact parameters for each 7 concurrent connection. When I
> put
> > 8th one, the return is nothing.
> >
> > You can see the webpage that triggers the FTS from:
> >
>
http://www.learnasp.com/search/a.asp?keyword=dsn&sortby=2&direction=1&list=aspngfreeforall&LangList=English&limit=40
> >
> > The FTS query is:
> >
> > SET @statement = 'SELECT TOP ' + @num_matches + ' ''1000'' As Rank,
> list_,
> > messageid_, M.creatstamp_, hdrfrom_, hdrsubject_' + ' FROM messages_ AS
M
> > INNER JOIN lists_ ON M.list_ = lists_.name_ ' + ' WHERE 1=1' +
@add_pred
> +
> > @list_security + @lang_pred + @order_by
> > -- Execute the SELECT statement.
> > EXEC (@statement)
> >
> > messages_ is the table. If you wanna see, I can paste the whole SP.
> >
> > Regards.
> >
> > Murtix Van Basten.
> >
> >
> > "John Kane" <jt-kane@comcast.net> wrote in message
> > news:uALwGlsFEHA.692@TK2MSFTNGP09.phx.gbl...
> > > Murtix,
> > > When you say a "1GB Table", do you mean 1GB rows or the overall size
of
> > this
> > > table? Also, how long are you waiting for the queries to return
results
> > and
> > > what is the expected number of results per query? SQL FT Indexing and
FT
> > > Search query performance is a function of the total number rows as
well
> as
> > > the expected number of rows returned. Are you using the exact SQL FTS
> > query
> > > in each of the 7 concurrent connection or is each query different?
Could
> > you
> > > post an example of your SQL FTS query?
> > >
> > > Also, what is the return value for this query: EXEC
> sp_fulltext_service
> > > 'resource_usage'
> > >
> > > Regards,
> > > John
> > >
> > >
> > >
> > > "Murtix Van Basten" <rdagdelenjNOSPAM31@comcastNOSPAM.net> wrote in
> > message
> > > news:406a219f_4@news.athenanews.com...
> > > > Hi,
> > > >
> > > > I am using a full-text catalog to perform search inside a 1GB
> table.
> > I
> > > > have created fulltext catalog as usual methods, selected the
necessary
> > > > fields for the catalog from the table. When I want to make a stress
> test
> > > > over the search fucntion, it deoesnt return any data if I use more
> then
> > 7
> > > > concurrent connections.
> > > >
> > > > I heard that, this was a problem on sql server version 7. But
this
> > is
> > > a
> > > > sql server 2000 version. And from the white paper of full text
> catalogs,
> > > it
> > > > says it is able to handle up to 5124 concurrent connections to a
> > fulltext
> > > > catalog.
> > > >
> > > > What would be causing this ?
> > > >
> > > > PS: Computer's props: Dual P3 500 Mhz, 1GB Ram, 18 GB SCSI HDD,
Win2k
> > > > Server, Sql Server 2K Standard Ed. Computer only works for sql
server
> > > > processes, not other process bothers the computer.
> > > >
> > > > Thanks and Best Regards.
> > > >
> > > > Murtix Van Basten.
> > > >
> > > >
> > >
> > >
> >
> >
>
>