Welcome to Sign in | Help

Re: help... nr. maxim de conexiuni a fost atins

  •  09-25-2007, 8:00 PM

    Re: help... nr. maxim de conexiuni a fost atins

    Am rezolvat problema. Folosind Conexiunea Dedicata pentru Administrator (DAC) am reusit sa ma conectez la sever. Si de acolo folosind sintaxa:

    sp_configure 'user connections', 10
    go
    reconfigure

    am resetat numarul de conexiuni maxim la 10. (dintr-un maxim de 32,767 permise)

    Sfat legat de setarea nr. de conexiuni:

    If you must use this option, do not set the value too high, because each connection takes approximately 28 kilobytes (KB) of overhead regardless of whether the connection is being used. If you exceed the maximum number of user connections, you receive an error message and are not able to connect until another connection becomes available.

    Mai am o intrebare legat de:

    Did I mention that DAC won’t timeout?  So don’t forget to close it!

    Exista ceva sintaxa pt. inchidere? Sau se inchide automat cand inchid consola?

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems