|
Home > Archive > Microsoft SQL Server forum > May 2005 > Increase number of process(thread)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Increase number of process(thread)
|
|
| Do Park via SQLMonster.com 2005-05-26, 11:23 am |
| Hello all,
A software that connects SQL Server via ODBC uses 12 process at the same
time when I look at the process info(panel). Is it possible to increase
number of process (or thread) for a specific database? Is there any
parameter?
Thanks in advance,
Do.
--
Message posted via http://www.webservertalk.com
| |
| Erland Sommarskog 2005-05-26, 8:24 pm |
| Do Park via webservertalk.com (forum@nospam.webservertalk.com) writes:
> A software that connects SQL Server via ODBC uses 12 process at the same
> time when I look at the process info(panel). Is it possible to increase
> number of process (or thread) for a specific database? Is there any
> parameter?
You can change the number of permitted connections with
sp_configure 'user connections', 100 -- 100 is an example here
This is a server-wide setting. There is no per-database setting for this
(and neither would it be really meaningful).
However, the default for this option is 0, which means that the server
configures as it goes on.
Are you getting any error messages about running out of connections?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
| dbmonitor 2005-05-27, 7:23 am |
|
Do Park via webservertalk.com wrote:
> Hello all,
>
> A software that connects SQL Server via ODBC uses 12 process at the same
> time when I look at the process info(panel). Is it possible to increase
> number of process (or thread) for a specific database? Is there any
> parameter?
>
> Thanks in advance,
> Do.
>
> --
> Message posted via http://www.webservertalk.com
You will find that this is a programed function of the software itself,
not SQL Server.
See if there is a configuration setting you can use to adjust it.
You could also download a copy of the database monitor I have developed
which will tell you what load the software application is having on the
server. This will help determine if it is safe to up the number of
connections or not. It will also tell you if they are locking
themselves out.
You can download it from http://dbmonitor.tripod.com.
|
|
|
|
|