Re: Best connection management

Hi,


SQL Server allocates 28KB regardless for every connection. If there are too many clients to connect to the SQL Server, then you should think about this method again.

To be able to consider carefully, you may want to analyze your system by using System Monitor and adding counters for CPU and RAM especially.

Openning and Closing connections may have a performance cost for your application, but sometimes Availability is more important than performance. You of course may add some more memory or tune your application's performance if you encounter a problem about RAM.

It always depends :)

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



"Hornet77" <neuro@xxxxxxxxxx> wrote in message news:%23pkt74T8HHA.5360@xxxxxxxxxxxxxxxxxxxxxxx
Hi Ekrem

thanks for your help ;-)

Ekrem Önsoy ha scritto:
It depends on your hardware resources (especially RAM) on your SQL Server server.

tipically the SQL server will run on a Windows Server 2003r2 with 1 GB of RAM....

but there is no good practice to follow, to prescind from hardware?

Bye


.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)
Loading