Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [instance]

An occurrence of a database component. This can mean very different things depending on the platform.

DB2 - An instance is a logical database manager environment where you catalog databases and set configuration parameters. Depending on your needs, you can create more than one instance on the same physical server providing a unique database server environment for each instance.

Oracle - A set of memory structures that manage data files. Every database has at least one instance. An instance can exist without a database. In RAC multiple instances share the same database. Database here is used in the Oracle sense of the word.

SQL Server - The software, memory structures and data files. A computer can have more than one instance. One instance can be designated the default, but secondary instances must be named. Some things are shared between instances.

If you are familiar with what instance means on other databases, please add.

103 questions
34
votes
3 answers

Is the SQL Server Express memory and CPU limit per instance?

If I have 8GB of RAM in a server and I run 4 instances of SQL Server Express, will the total memory limit used by SQL Server be 1GB or 4GB? Would it be advisable to run multiple instances like this to enable each database to make better use of…
wizzardmr42
  • 460
  • 1
  • 4
  • 8
15
votes
3 answers

What is shared between two instances on the same server?

We want to install multiple instances of SQL Server on a single Windows server. We cannot use VMs because the server is bare metal Windows 2008 R2. For security purposes we need to ensure that the two instances share nothing, including management,…
BOb
  • 151
  • 1
  • 3
14
votes
3 answers

What's the most effective way to duplicate an instance on SQL 2008?

We've got a simple database instance with just enough data in the databases to keep it useful, and we can use it for demonstration purposes, and I want to put a copy of it on my laptop so I can use it for dev work when I'm not at the office. (The…
jcolebrand
  • 6,376
  • 4
  • 43
  • 67
13
votes
2 answers

How do I change the instance name in MS SQL 2005 without installing a new instance?

I have an instance that really has nothing on it, it's merely been installed (it was intended for one project, but that never actually got done on this server, the project was done in duplicate on another server) so since I have the instance, I want…
jcolebrand
  • 6,376
  • 4
  • 43
  • 67
11
votes
3 answers

Upstart script in ubuntu for mongodb

I am new to linux and mongodb. I've already installed mongodb on ubuntu but I want to run one more instance on different port. As I understood from other questions and forums , there must be upstart…
Erhan A
  • 223
  • 1
  • 2
  • 6
10
votes
2 answers

Delete an oracle instance, the right way

I want to delete an oracle instance (oracle 10.2.0.4.0) created in the AIX 6.0 OS. I know i can delete all the dbf and ctl files in the Terminal but i thinks that's no the best way to do it. I think must be a cleaner way to do that. Thanks in…
Jorge Vega Sánchez
  • 993
  • 3
  • 15
  • 22
10
votes
4 answers

SQL Server 2008 R2: Problems after computer name change

I'm having a confusing problem after changing the computer name of a remote server hosting a local SQL Server instance. Basically, a remote server was moved from one site to another. In order to facilitate this, I backed up and restored the old…
Geo Ego
  • 271
  • 1
  • 2
  • 8
8
votes
1 answer

Is it possible to determine the default Collation and server version of a database without a full restore?

I work for a company who regularly receives large SQL database backups from clients for support purposes. We support multiple SQL versions and collations, but currently have to manually confirm our client's SQL versions before restoring to the…
Austin
  • 93
  • 4
8
votes
5 answers

How to uniquely identify SQL instance

I need to find a way how to identify SQL Instance no matter what changes were done to SQL Server and\or Windows Server where it is running, because we're collecting remotely information about instances into our operational database and still…
R1cky
  • 277
  • 1
  • 4
  • 10
7
votes
3 answers

For Oracle, we mount the instance to the database or mount the database to the instance?

From Oracle Docs: Start the instance, and mount and open the database. This can be done in unrestricted mode, allowing access to all users, or in restricted mode, allowing access for database administrators only. .... To mount a database to a…
Just a learner
  • 2,082
  • 7
  • 36
  • 57
7
votes
4 answers

Why would one need multiple instances of same Oracle database?

I came across the following statement in this article: An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance to be able to manipulate that data, the instance must open the…
Parag Meshram
  • 378
  • 2
  • 3
  • 11
7
votes
4 answers

Trick to remember which instance I am working with

I work as a BI developer and always switch between different instances on a same server. However, sometimes I forget the right instance and for example may cause to truncate a table on the other. I know this is not a technical question but rather…
programmer21
  • 81
  • 5
7
votes
2 answers

How can I find a table in the whole instance?

I am trying to create a report which selects data from a table called costomersHR. I cannot find it as we have hundreds of databases in the instance. How can I search for a table in the whole instance?
alonk
  • 301
  • 1
  • 4
  • 11
6
votes
5 answers

Is it advantageous to scale out using multiple SQL Server instances on the same server?

For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server? What will I gain and what will I lose? Tagged sql-server-2012 because it's the most…
孔夫子
  • 4,330
  • 3
  • 30
  • 50
6
votes
2 answers

Unable to change servername after VM Clone

For reasons out of my control I must find a solution to this issue. Simply reinstalling the instance is not an option. The server name that appears as server_id 0 in sys.servers is still showing the old servername. I'm getting an error when running…
Geoff Dawdy
  • 1,143
  • 7
  • 23
  • 53
1
2 3 4 5 6 7