Re: SqlConnection and DB connection failures detection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
? Is it good idea to play with such timeouts to improve performance
(App is going to work 24h/day)?

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 ? 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 ?

Thanks in advance for your help!

--
Best regards
Tomasz

.

Relevant Pages

  • 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. ... Authentication is all about security, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Performance issue after coverting from Framework 1.1 to 2.0
    ... I think that I encountered the same problem: A large program with Framework ... the SQL Server for the dev database. ... when you deploy the app on a different machine where the SQL Server is no ... app was fine on the dev machine. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: C5 woes. How stable is VFP really?
    ... After that I close the SQL server cursor and work with my manual cursor instead. ... a VFP9 app on a really old machine ... app was under more "pressure", VFP showed ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: Is SQL Server the right platform?
    ... In some cases my App is downloaded and purchased by a single user and both ... presumably attached to SQL Server or SQL Server Express. ... using the Compact Edition, can the Compact Edition database later be moved ... msi which can install the prerequisits required. ...
    (microsoft.public.sqlserver.setup)