Open Obects Param

Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?
Use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to
set it to?
|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:

>Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?

Open Obects Param

Does anyone know how to check the current amount of "Open Objects"? I am ge
tting an error that says my Open Objects parameter is set too low. If I can
not tell what it is currently set at, how can I tell how high to set it to?Use sp_configure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting
an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set
at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:

>Does anyone know how to check the current amount of "Open Objects"? I am getting a
n error that says my Open Objects parameter is set too low. If I cannot tell what i
t is currently set at, how can I tell how high to set it to?

Open Obects Param

Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?Use sp_configure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:2F1B9867-385F-4984-B6E4-B62F538BBB53@.microsoft.com...
> Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open
Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to
set it to?|||Execute sp_configure and check the open objects run_value.
You can find more info on this setting in books online under
the help topic open objects Option
-Sue
On Tue, 27 Apr 2004 07:11:03 -0700, "Rich"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know how to check the current amount of "Open Objects"? I am getting an error that says my Open Objects parameter is set too low. If I cannot tell what it is currently set at, how can I tell how high to set it to?

Open Connections

Is there a normal amount of open sql connections? We have about 300
open connections and I do not know if that is a lot of not.Voss,
It all depends on how many users you have and the software that they are
using. E.g. a web interface might hold very few shared connections for
everybody to use, but an Access frontend to SQL Server will hold more
connections open. Etc. etc.
I just quick checked two servers, one has 150 connections and the other has
2000 connections. Neither of these are worrying me, because I know what
they are being used for and approximately the number of people connecting.
FWIW,
RLF
<voss@.talentzoo.com> wrote in message
news:1190638728.921070.109640@.w3g2000hsg.googlegroups.com...
> Is there a normal amount of open sql connections? We have about 300
> open connections and I do not know if that is a lot of not.
>