Open Objects Value

Jul 31, 2000

SQL server 6.5 stopped responding. The last error messages in the SQL Server Error Log / NT Event log suggested that I increase the Open Objects / Open Databases values. I rebooted the server, increase the configuration values, and rebooted the server again for the new configuration to take affect. I suspect that the front-end application does not release the objects properly when it should; therefore increasing Open Objects / Databases configuration values will only be a temporary fix until they reach the new maximum in some time. However to prove that I need to be able to determine how many open objects / databases are on the server at a point of time. Is there a procedure or a method to determine how many open objects / dtabases are on server?

Any comments or suggestions are greatly appreciated.

Thank you
Marina Somers

View 1 Replies

Open Objects Parameter May Be Too Low.......

Sep 18, 2001

SQL 6.5
NT 4.3.3

Recently in the error.log the following message appeared:

Warning: Open Objects paramter may be too low
attempt was made to free up descriptors in localdes()
Run sp_configure to increase parameter value

Please indicate why this message appears and what measures must be taken to prevent it from re-occuring.

Thank You in advance!

View 2 Replies View Related

Cannot Open Objects Using SSDT

Jun 4, 2015

I have SQL server 2014 database installed on a Windows 2012 server and SSDT also got installed ( 2013 shell)

I can connect to a database and see all objects using SSDT , but I cannot write any queries or modify any of the objects,

I am new to the SSDT, and this is the first time I am going to configure SSDT to work with SQL Server.

View 7 Replies View Related

How To List All The Open Objects On The SQL Server

Apr 1, 2004

Hi, is there a way to find all the objects that are currently open on the server, that includes:

Tables, Views, SPs, Extended SPs, Triggers, Rules, Defaults, Indexes on the tables?

I can get some information from syslockinfo table but I can find a way to get the full picture.

Any help on that would be appreciated.

Dim

View 9 Replies View Related

Script Needed To Edit Open Objects In Sybase

Feb 23, 2006

Currently I must manually complete the following commands to set a new valuefor the "open objects" and "open indexes". I need a way script this processin a batch file.COMMANDS RAN: This is nothing to script, these commands obtain the currentvalues for open objects and open indexes.isql -Usa -Pmanager -SCOP1_DSexecute sp_countmetadata "open objects"execute sp_countmetadata "open indexes"goRESULTS: below are the results, there are 5124 user objects and 2122 userindexes. I need a way to be able to multiple these numbers by a set valueand then use the new value and reset the user objects and user indexes. Thequestion is how do I isolate the results for each result so I can run thecalculations below. Here is the calculation I need:current user objects * 1.05 = new valuecurrent user indexes * 1.1 = new valueThere are 5124 user objects in all database(s), requiring 6985 Kbytes ofmemory.The 'open objects' configuration parameter is currently set to 500.(return status = 0)There are 2122 user indexes in all database(s), requiring 5902 Kbytes ofmemory.The 'open indexes' configuration parameter is currently set to 5000.(return status = 0)SETTING THE NEW VALUES: Once I have the new values, I can set the ojects andindexes as seen below.1> execute sp_configure "open objects", 53802> execute sp_configure "open indexes", 23343> go

View 2 Replies View Related

How To Open Multiple SqlConnection Objects In A SqlServer Project

Jun 5, 2006

I have a sql server project where I have added 1 stored procedure (named StoredProcedure1) and 1 class (named MyClass). MyClass has two functions Func1() and Func2(). The stored procedure simply instantiates MyClass and calls Func1().

Func1() creates a SqlConnection object using "context connection=true" - opens the connection and then calls Func2(). Func2() also creates a SqlConnection object using "context connection=true" - and attempts to open the connection. However when attempting to the Open() call inside Func2(), the code just exits. What gives? The code is pasted below, thanks!

*******THE STORED PROCEDURE**************
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using SqlServerProject1;

public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void StoredProcedure1()
{
// Put your code here
MyClass obj = new MyClass();
obj.Func1();
obj = null;
}
};

*******THE CLASS "MYCLASS"**************
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public class MyClass
{
public MyClass()
{

}

public void Func1()
{
using ( SqlConnection conn = new SqlConnection("context connection=true") )
{
conn.Open();

Func2();
conn.Close();
}
}

public void Func2()
{
using ( SqlConnection conn = new SqlConnection("context connection=true") )
{
if ( conn.State != ConnectionState.Open )
conn.Open();

if ( conn.State == ConnectionState.Open )
conn.Close();
}
}
}