how detect sqlserver tie leaks asp.net applications?


i'm now doing gui contrast asp.net 2.0 application.
the rdbms sql server 2005. horde win server 2003 / iis 6.0.



i have source formula concentration since involuntary an outmost association who's releasing code.



i've beheld concentration performs good i restart iis nonetheless after testing, after i have uninterrupted closed browser integrate hours, concentration starts slower slower. i wondering intrepidity due bad shutting tie use programmers : i'm suspecting an open tie trickle database here.



i speculation .net rubbish gourmet eventually tie but... take while, no?



i've got sql server supervision studio i notice activity guard there definitely few connectors uninterrupted database.



from that's being conspicuous above, here questions associated sure doubt :




  1. is there any proceed know sql
    server 2005 connectors are
    open since they're sharp be
    used tie pool if
    they're open since used an
    application?


  2. does somone know good
    online/paper resources where i could
    learn performance
    counters kind tools
    to assistance lane down kind of
    issues?


  3. if opening counters best
    solution, variables i
    should watch?




Comments

Post a Comment

Popular posts from this blog

list macos calm editors formula editors

i searched found maudite's doubt text editors nonetheless windows. as have doubt guessed, i am perplexing out there any text/code editors mac besides i know of. i'll correct post consolidate editors listed. free textwrangler xcode mac vim aquamacs closer uncanny emacs jedit editra eclipse netbeans kod textmate2 - gpl brackets atom.io commercial textmate bbedit subethaedit coda sublime calm 2 smultron webstorm peppermint articles associated subject faceoff, best calm editor ever? maceditors.com, mac editors comforts compared thank everybody total suggestions.
Read more

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

what's best proceed good purify url structure smoke-stack yield has? do i need iis this? there proceed i arrange mapping record asp .net? the site i wish hundreds pages, already deployed. i slight requires slightest volume changes possible. note: i do not wish suggestions urls friendly i do wish suggestions best control permitted urls emanate mappings. i fundamentally wish have any route ends aspx have aspx progression instead feeling folder an index.aspx inside it. -> edit: i'm controlling iis 6.0
Read more

jaxb - xjc - reworking generated typesafe enum category members

when compiling following simpletype xjc accumulate (from jaxb package)... <xs:simpletype name="test"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenumclass/> </xs:appinfo> </xs:annotation> <xs:restriction base="xs:string"> <xs:enumeration value="4"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenummember name="four"/> </xs:appinfo> </xs:annotation> </xs:enumeration> <xs:enumeration value="6"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenummember name="six"/> </xs:appinfo> </xs:annotation> </xs:enumeration> </xs:restriction> </xs:simpletype> i finish adult following enum java (import statements comments removed) @xmlenum public ...
Read more