Bogdan_Ch's questions

We have a huge .NET application from 3rd party that would be time consuming to disassemble and understand the code. It is compiled in Release mode. Connection strings to the MS SQL databases are defined to be in config file and they seem to be correct. There are more then 6 different databases it uses.

However when app starts, it throws an error like "a network related or instance specific error occurred while establishing a connection to sql server" Traces of the application doesnt provide enough information where it tries to connect when it fails.

Is it possible to profile which connection a .NET application is trying to open without knowing in advance which SQL server name it tries to connect? SQL Profile traces connections on server side opened from other machines, but what is the best tool there to see on a specific machine to which SQL server it connects (with a possibility to see a non-succesfull connections as well)

I mean CACHE from InterSystems (http://www.intersystems.com/cache/)

Does this database stable enough ? Does the vendor provide prompt support for issues and bugs ? Will the database files grow faster (comparing with the same amount of data in traditional RDBMS) ?

I would like to read an opinion of a DBA who have ever managed a CACHE database and also had in the past an experience with an enterprise version of any traditional RDBMS (like MS SQL, Oracle, DB2). Were your daily DBA tasks very different and what was your biggest challenge with that ?

I will also appreciate if one can share an opinion of how CACHE from InterSystems can be compared with other object-oriented database management systems (OODBMS)

Microsoft advices to use /3Gb switch in Boot.ini in order to get more memory for a process running on 32bit system.

Currently I need a lot of memory for devenv process (Visual Studio 2008) because I have a complex solution that has a lot of projects and forms and consumes a lot of resources in design time.

I would like to ask, if anybody knows, what are negative aspects of using /3Gb switch, are there any circumstances where it is not recommended to use it.