Hello everyone,
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsiz
e.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 200
0.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:
> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpools
ize.
> My question is how many connections can we make simultaneously to SQL serv
er
> 2000.
> Experts if u can give me an optimal configuration for this it will be real
ly
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...[vbcol=seagreen]
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>
Showing posts with label configuring. Show all posts
Showing posts with label configuring. Show all posts
Monday, March 19, 2012
Connections
Hello everyone,
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsize.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 2000.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:
> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpoolsize.
> My question is how many connections can we make simultaneously to SQL server
> 2000.
> Experts if u can give me an optimal configuration for this it will be really
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
--
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>> Hello everyone,
>> I am configuring the connection pooling for my web application.
>> We are using Sql Server 2000 as backend.
>> I need to specify initial connection poolsize and maximum
>> connectionpoolsize.
>> My question is how many connections can we make simultaneously to SQL
>> server
>> 2000.
>> Experts if u can give me an optimal configuration for this it will be
>> really
>> helpful
>> Thanks
I am configuring the connection pooling for my web application.
We are using Sql Server 2000 as backend.
I need to specify initial connection poolsize and maximum connectionpoolsize.
My question is how many connections can we make simultaneously to SQL server
2000.
Experts if u can give me an optimal configuration for this it will be really
helpful
ThanksWe have left the max worker threads as the default 255 in the sql server 2000.
But we expect 300 to 500 users to connect to the application,
can we increase the max worker threads to 500
and specify the initial connection poolsize as 500 in the conection pool of
the application.
Any help would be greatly appreciated.
Thanks
"Toby" wrote:
> Hello everyone,
> I am configuring the connection pooling for my web application.
> We are using Sql Server 2000 as backend.
> I need to specify initial connection poolsize and maximum connectionpoolsize.
> My question is how many connections can we make simultaneously to SQL server
> 2000.
> Experts if u can give me an optimal configuration for this it will be really
> helpful
> Thanks|||Unless you have 500 simultaneous, persistent, user connections (win9x
clients), there is no need to increase the max worker threads. Sqlserver is
designed to handle thousand of connections with 255 max worker threads fine.
Long story short, your users connect to sqlserver via a web application
(running on IIS?). There isn't a need to increase the #.
--
-oj
"Toby" <Toby@.discussions.microsoft.com> wrote in message
news:81AE8280-C6F3-4082-8047-AD1953FF13F6@.microsoft.com...
> We have left the max worker threads as the default 255 in the sql server
> 2000.
> But we expect 300 to 500 users to connect to the application,
> can we increase the max worker threads to 500
> and specify the initial connection poolsize as 500 in the conection pool
> of
> the application.
> Any help would be greatly appreciated.
> Thanks
> "Toby" wrote:
>> Hello everyone,
>> I am configuring the connection pooling for my web application.
>> We are using Sql Server 2000 as backend.
>> I need to specify initial connection poolsize and maximum
>> connectionpoolsize.
>> My question is how many connections can we make simultaneously to SQL
>> server
>> 2000.
>> Experts if u can give me an optimal configuration for this it will be
>> really
>> helpful
>> Thanks
Thursday, March 8, 2012
Connection to remote server using VPN
Hi - I am a relative newbie to setting up and configuring servers so am a
bit baffled by all the server techno-speak.
My issue - I have a client who is based about 40 miles away who want me to
do some database work for them. I am a freelancer and he is a small company
who relies on a non sql server specific moonlighter for tech support (it's
not as wing and prayer as it might seem!).
They bought MS Small Biz server which includes SQL 2000. I tried to install
it on my XPHome pc but came to the view that you need a 2000/2003 server to
run anything bigger than a 4Gb database. Given that the db will be much
bigger than 4Gb we therefore need to install SQL Server on his server and
run it as a sql server with me installing query analyser and eneterprise
manager on my PC and connect. All fine in theory. Now for security I am
assuming the best way to connect is by using VPN? If this is so, can any
one point me to any info on setting up my end + his end and what may be
required h/w + s/w etc?
His moonlight techie says I need a static IP address... I think I have a
dynamic one, and that all he need to do is set up some filters his end. I
also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has router
and firewall his end.
I looked for past postings and find ref to this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
but now it's dead.
Any help much appreciated!
Happy New Year.
Andythere is a thread going on at www.sqlservercentral.com
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
maybe that will get you on track
jobi
"Andreww" <andrew@.fake.com> wrote in message
news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> Hi - I am a relative newbie to setting up and configuring servers so am a
> bit baffled by all the server techno-speak.
> My issue - I have a client who is based about 40 miles away who want me to
> do some database work for them. I am a freelancer and he is a small
company
> who relies on a non sql server specific moonlighter for tech support (it's
> not as wing and prayer as it might seem!).
> They bought MS Small Biz server which includes SQL 2000. I tried to
install
> it on my XPHome pc but came to the view that you need a 2000/2003 server
to
> run anything bigger than a 4Gb database. Given that the db will be much
> bigger than 4Gb we therefore need to install SQL Server on his server and
> run it as a sql server with me installing query analyser and eneterprise
> manager on my PC and connect. All fine in theory. Now for security I am
> assuming the best way to connect is by using VPN? If this is so, can any
> one point me to any info on setting up my end + his end and what may be
> required h/w + s/w etc?
> His moonlight techie says I need a static IP address... I think I have a
> dynamic one, and that all he need to do is set up some filters his end. I
> also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
router
> and firewall his end.
> I looked for past postings and find ref to this link
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> but now it's dead.
> Any help much appreciated!
> Happy New Year.
> Andy
>|||Jobi - thanks. I took a look and it seems more about how to set things up
once the VPN is set up... which helps.
In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?
Help appreciated... even if it's that I'm in the wrong news group!
Regards
Andy
"jobi" <jobi@.reply2.group> wrote in message
news:bsud5v$fhp$1@.reader08.wxs.nl...
> there is a thread going on at www.sqlservercentral.com
> http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
> maybe that will get you on track
> jobi
> "Andreww" <andrew@.fake.com> wrote in message
> news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> > Hi - I am a relative newbie to setting up and configuring servers so am
a
> > bit baffled by all the server techno-speak.
> >
> > My issue - I have a client who is based about 40 miles away who want me
to
> > do some database work for them. I am a freelancer and he is a small
> company
> > who relies on a non sql server specific moonlighter for tech support
(it's
> > not as wing and prayer as it might seem!).
> >
> > They bought MS Small Biz server which includes SQL 2000. I tried to
> install
> > it on my XPHome pc but came to the view that you need a 2000/2003 server
> to
> > run anything bigger than a 4Gb database. Given that the db will be much
> > bigger than 4Gb we therefore need to install SQL Server on his server
and
> > run it as a sql server with me installing query analyser and eneterprise
> > manager on my PC and connect. All fine in theory. Now for security I am
> > assuming the best way to connect is by using VPN? If this is so, can
any
> > one point me to any info on setting up my end + his end and what may be
> > required h/w + s/w etc?
> >
> > His moonlight techie says I need a static IP address... I think I have a
> > dynamic one, and that all he need to do is set up some filters his end.
I
> > also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
> router
> > and firewall his end.
> >
> > I looked for past postings and find ref to this link
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > but now it's dead.
> >
> > Any help much appreciated!
> >
> > Happy New Year.
> >
> > Andy
> >
> >
>|||"In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?"
Given what little knowledge I have about your situation, I would say that VPN is your best bet. It's going to be the most economical, practical, and easiest way to connect to your client using SQL. Anything else would be expensive and/or unsecure.
But that's just my opinion...
Hope this helps.
Shaun
bit baffled by all the server techno-speak.
My issue - I have a client who is based about 40 miles away who want me to
do some database work for them. I am a freelancer and he is a small company
who relies on a non sql server specific moonlighter for tech support (it's
not as wing and prayer as it might seem!).
They bought MS Small Biz server which includes SQL 2000. I tried to install
it on my XPHome pc but came to the view that you need a 2000/2003 server to
run anything bigger than a 4Gb database. Given that the db will be much
bigger than 4Gb we therefore need to install SQL Server on his server and
run it as a sql server with me installing query analyser and eneterprise
manager on my PC and connect. All fine in theory. Now for security I am
assuming the best way to connect is by using VPN? If this is so, can any
one point me to any info on setting up my end + his end and what may be
required h/w + s/w etc?
His moonlight techie says I need a static IP address... I think I have a
dynamic one, and that all he need to do is set up some filters his end. I
also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has router
and firewall his end.
I looked for past postings and find ref to this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
but now it's dead.
Any help much appreciated!
Happy New Year.
Andythere is a thread going on at www.sqlservercentral.com
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
maybe that will get you on track
jobi
"Andreww" <andrew@.fake.com> wrote in message
news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> Hi - I am a relative newbie to setting up and configuring servers so am a
> bit baffled by all the server techno-speak.
> My issue - I have a client who is based about 40 miles away who want me to
> do some database work for them. I am a freelancer and he is a small
company
> who relies on a non sql server specific moonlighter for tech support (it's
> not as wing and prayer as it might seem!).
> They bought MS Small Biz server which includes SQL 2000. I tried to
install
> it on my XPHome pc but came to the view that you need a 2000/2003 server
to
> run anything bigger than a 4Gb database. Given that the db will be much
> bigger than 4Gb we therefore need to install SQL Server on his server and
> run it as a sql server with me installing query analyser and eneterprise
> manager on my PC and connect. All fine in theory. Now for security I am
> assuming the best way to connect is by using VPN? If this is so, can any
> one point me to any info on setting up my end + his end and what may be
> required h/w + s/w etc?
> His moonlight techie says I need a static IP address... I think I have a
> dynamic one, and that all he need to do is set up some filters his end. I
> also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
router
> and firewall his end.
> I looked for past postings and find ref to this link
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> but now it's dead.
> Any help much appreciated!
> Happy New Year.
> Andy
>|||Jobi - thanks. I took a look and it seems more about how to set things up
once the VPN is set up... which helps.
In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?
Help appreciated... even if it's that I'm in the wrong news group!
Regards
Andy
"jobi" <jobi@.reply2.group> wrote in message
news:bsud5v$fhp$1@.reader08.wxs.nl...
> there is a thread going on at www.sqlservercentral.com
> http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19507
> maybe that will get you on track
> jobi
> "Andreww" <andrew@.fake.com> wrote in message
> news:kwyIb.2561$tH.23625741@.news-text.cableinet.net...
> > Hi - I am a relative newbie to setting up and configuring servers so am
a
> > bit baffled by all the server techno-speak.
> >
> > My issue - I have a client who is based about 40 miles away who want me
to
> > do some database work for them. I am a freelancer and he is a small
> company
> > who relies on a non sql server specific moonlighter for tech support
(it's
> > not as wing and prayer as it might seem!).
> >
> > They bought MS Small Biz server which includes SQL 2000. I tried to
> install
> > it on my XPHome pc but came to the view that you need a 2000/2003 server
> to
> > run anything bigger than a 4Gb database. Given that the db will be much
> > bigger than 4Gb we therefore need to install SQL Server on his server
and
> > run it as a sql server with me installing query analyser and eneterprise
> > manager on my PC and connect. All fine in theory. Now for security I am
> > assuming the best way to connect is by using VPN? If this is so, can
any
> > one point me to any info on setting up my end + his end and what may be
> > required h/w + s/w etc?
> >
> > His moonlight techie says I need a static IP address... I think I have a
> > dynamic one, and that all he need to do is set up some filters his end.
I
> > also have a Lynksys router (BEFSR41) and Norton Proff Fiewall. He has
> router
> > and firewall his end.
> >
> > I looked for past postings and find ref to this link
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> > but now it's dead.
> >
> > Any help much appreciated!
> >
> > Happy New Year.
> >
> > Andy
> >
> >
>|||"In the firts instance, my question was about... is VPN the way to connect a
SQL client to server?"
Given what little knowledge I have about your situation, I would say that VPN is your best bet. It's going to be the most economical, practical, and easiest way to connect to your client using SQL. Anything else would be expensive and/or unsecure.
But that's just my opinion...
Hope this helps.
Shaun
Subscribe to:
Posts (Atom)