Re: SqlConnection and DB connection failures detection


"Tomasz" <tomasz.szkudlarek@xxxxxxxxx> wrote in message
news:1158652443.301957.248280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Ignacio Machin ( .NET/ C# MVP ) wrote:
| > >> Why ?
| > >> This will seriusly hamper the performance/scalability of both the DB
and
| > >> the
| > >> app
| > >
| > > So, should i connect each time i want to launch a query (only insert
| > > queries i'm performing)?
| >
| > YES !!
|
| Ok, i changed this - my code is now much more simplified!
| Now question - after performing insert query I'm closing connection,
| but my process still exists in SQL Server Activity Monitor (even if i
| close my app) with "Sleeping" status. I believe that this is what you
| said about functionality of MS SQL (Damm i will order an MS SQL
| bible-like book immediatelly!). How long server will keep this process
| ?

The physical connection drops after ~6 minutes, provided no logical
connections exists.

Is it good idea to play with such timeouts to improve performance
| (App is going to work 24h/day)?
|

No.

| Then second question - I'm using SQL Server authentication instead of
| AD one, i think this is better solution for more missions-critical
| apps, is it true ?

Authentication is all about security, not about being mission-critical. When
using integrated security, there is no way to expose the credentials used to
authenticate, while using SQL authentication, you can expose your secrets.

Theoretically even if the whole my network is down
| this application will still work (SQL server is on the same PC). What
| would you say ?
|

Yep. And authentication is less of a concern, credentials aren't going over
the network anyway.



Willy.


.

Relevant Pages

  • Re: Authentication problem continued
    ... SQL Server is configured for Windows Authentication only and not mixed ... I'm still having trouble getting my app to authenticate correctly. ... but only on my developement machine and not another box. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SqlConnection and DB connection failures detection
    ... Now question - after performing insert query I'm closing connection, ... but my process still exists in SQL Server Activity Monitor (even if i ... close my app) with "Sleeping" status. ... Then second question - I'm using SQL Server authentication instead of ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... In the case of AS.NET app, being hosted by ISP, it is very likely the users are not windows domain user. ... the membership provider uses SQL Server or SQL Server Express. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • Re: How to deploy a DB-using Webservice to a shared server??
    ... Set the IIS app to use Windows authentication. ... In your app that calls the web service, ... authentication to the SQL server with one last condition. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Authentication problem continued
    ... This is the exception I get if on my test box if I haven't run ... I have a SQL Server login established now and I can log in on my ... SQL Server is configured for Windows Authentication only and not ... I'm still having trouble getting my app to authenticate correctly. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading