Questions tagged [instance]
An occurrence of a database component. This can mean very different things depending on the platform.
102
questions
2
votes
2
answers
247
views
Creating a global alias for a SQL Server Instance
Forgive me if this is an easy question, but I have tried finding an answer but I really don't know what to search (I'm a software dev, with only some limited DBA experience).
We have test SQL servers ...
- 23
2
votes
1
answer
346
views
How should MAXDOP be configured on stacked instances?
There is good general advice for how to configure Maximum Degree of Parallelism (MAXDOP). However, I am in a special circumstance. There are two instances on my box. If I have 16 cores, how should I ...
- 645
0
votes
0
answers
72
views
SQL Server - connecting to wrong instance?
So, I've ... inherited a SQL server environment. With LanSweeper, I see this particular server has two instances installed: sql001AK and sql001M5. LanSweeper tells me they have similar databases, ...
- 268
-4
votes
2
answers
152
views
How does SSMS grab the name of my server?
In the bottom-right hand side of SSMS's main screen and to the left of where it shows my user-name and the name of the database that I'm in, it gives the name of the server that I'm on. This string is ...
- 645
0
votes
1
answer
46
views
Two instance on one server vs 2 server
I've one server with a database who stress the server and is blocking other db. Developer has optimized the query, but there we need more power. The SQL server is a VM in a vCloud Director tenant, we ...
0
votes
1
answer
770
views
Understanding RAM Usage, ReadThroughput, and Freeable Memory Metrics in PostgreSQL RDS
I'm facing an interesting issue related to RAM usage, ReadThroughput, and Freeable Memory metrics with my PostgreSQL database on an RDS instance, and I'm hoping to get some insights here.
Two months ...
- 11
0
votes
1
answer
45
views
Can database administrators access and modify the database before it's opened?
I'm trying to answer the following question (asked in a previous exam and supposedly having one correct answer):
To create a DATAFILE and Assign it to a DATABASE, the instance can't be
started in ...
- 131
0
votes
1
answer
177
views
Catch-22 Errors in Configure Replication Wizard on a Failover Cluster Named Instance
I'm attempting to setup replication on a new SQL 2019 install but I'm encountering a catch-22 in errors.
I have two (2) named instances setup side by side, each setup as a cluster role. The cluster ...
0
votes
1
answer
388
views
MariaDB: How to install a second instance using MSI-Installer
I would like to install a second instance of MariaDB with MSI-Installer (Windows 10). The first instance is on drive C. When I want to install the second instance on drive D using MSI-Installer the ...
- 257
0
votes
1
answer
311
views
db2 - What is purpose of db2ln and its file system symbolic links?
On Linux/x86-64 I have Db2 v11.1 installed. When I tried to install Db2 v11.5 alongside existing Db2 installation I got error "DBI1004W /usr/lib/libdb2.so detected".
I checked and I see ...
- 357
0
votes
0
answers
333
views
Multiple SQL instances on the same server and how to manage TempDB
Probably a bizarre approach but I don't really have much say in the setup.
We have a large server deployed in Azure and the plan is to get 16 separate instances on this machine. We plan on using the ...
- 111
0
votes
1
answer
223
views
How to start second MySQL instance on boot on Ubuntu 20.04?
I have a second MySQL 8 instance running on Ubunut 20.04, started by this command:
mysqld_safe --defaults-file=/home/user/mysqld_replica.cnf &
The config file contains all needed settings like ...
- 313
2
votes
2
answers
796
views
Multiple instance properties
I'd like to understand how tuning works on instances that are living inside the same machine/VM.
I couldn't find a straight answer to the question if properties of each separate instance have some ...
- 29
0
votes
1
answer
249
views
Migrate from Standalone Instance to Failover Node Instance
I am fairly new to the MS SQL and i am currently working on a project at my company. We have a ERP System built on a SQL Server and we want to create a SQL failover node.
The original configuration is ...
7
votes
4
answers
2k
views
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 ...
- 81
1
vote
2
answers
847
views
How can MySQL return an empty row matching a given table's schema, given the table name as an input string?
How can a query or procedure return an empty copy of a new record?
Ideally suited for objects which are in a transactional allocation process:
It is highly preferable to have authoritative defaults ...
-1
votes
1
answer
78
views
Terminologies in Oracle-SQL and MySQL | Mutiple Database, Mutiple instances comparsion
In Oracle-SQL:
Database = set of physical files on disk
Instance = processes, daemons, and memory structures (i.e state of operation)
Schema = collection of database objects, including logical ...
- 103
3
votes
1
answer
3k
views
I can´t change innodb_buffer_pool_instances
I recently updated my mariadb database to 10.5.5 and I can't set innodb_buffer_pool_instances
innodb_log_file_size = 3G
innodb_buffer_pool_size = 12G
innodb_buffer_pool_instances = 12
But when
...
- 33
-1
votes
1
answer
33
views
Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?
If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it will initialize recovery process. What about SQL Server? Does it behave in the same way?...
- 1,303
0
votes
2
answers
2k
views
What are v$database, SID, ServiceName, istance in Oracle 18c?
I have set up Oracle 18c (18.4) on Windows 10 on a company laptop (localhost should be the same as my company's domain name).
Once I've created user SYSTEM with password at the installation I tried to ...
- 103
0
votes
0
answers
33
views
How to migrate the SQL Server instance and system databases to a different drive (mapped to a different letter) on the same server? [duplicate]
I'm tasked with moving our SQL Server instance and system databases from the existing drive it's on to a new drive on the same server. I know I can stop the SQL Server service, literally move the ...
- 38.6k
0
votes
1
answer
225
views
What steps do I need to take to move my SQL instance to a different drive on the same server but with the same drive letter?
I need to move my SQL instance to a different drive on the same server but plan to rename the drive to the same drive letter as the original drive the instance was on (after renaming the old drive).
...
- 38.6k
3
votes
2
answers
3k
views
SSMS How do I open a new Query Window using Same Connection Instance of current Window
Coming from Oracle I have discovered that SSMS connects slightly different than Oracle's SQL Developer. Oracle you click ONE connection and then all tabs you open then use that Connection. SSMS ...
- 265
8
votes
1
answer
1k
views
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 ...
- 93
2
votes
1
answer
9k
views
Querying a SQL Server's CNAME alias instead of the actual instance name
We don't have a DBA here and our infrastructure analyst is trying his best to give us a test instance on a server using a CNAME alias which neither he nor I have done before.
The actual database ...
- 21
2
votes
2
answers
2k
views
Availability groups multiple instance, multiple listeners [closed]
In my work environment, I have two database machines:
DB01
DB02
Each database machine has three SQL Server instances:
MSSQLSERVER
FBG
Central
I've managed to set up availability groups with SQL ...
- 45
4
votes
1
answer
844
views
SQL Server Ignoring Instance name when using port number of different instance
I saw a strange case recently and still clueless on what should be the reasoning behind it. On one of my development server, two SQL server instances are running - one is default and other one is UAT ...
- 3,904
3
votes
3
answers
4k
views
Multiple instance in one server
Could you please help to explain why one might need multiple instances of SQL Server on the same server? What is a good point to use separate instances? Why wouldn't one use two databases in one ...
- 31
0
votes
2
answers
864
views
How to find out the service accounts for each of my instances in the current server?
I have the following query that gives me one line for each sql server instance installed in the current server:
--list the instances in the current server
--marcello miorelli
--16-sep-2016
...
- 16.4k
1
vote
1
answer
397
views
How do I configure my SQL Server instance to use a different Edition with minimal side effects?
I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
- 111
0
votes
1
answer
3k
views
What is meant by "Stand-Alone Instance of SQL Server"
I am cloning a server to perform an in-place upgrade and I will have to change the name of that server - which has a SQL Server with just one instance (default instance) installed on it.
I am ...
- 711
1
vote
1
answer
2k
views
How to know which instance is default in Configuration Manager if default port number is changed?
In MS SQL Server Configuration Manager I can see all the instances. I recognize the default one (by saying a default instance I mean the one that listens for 1433) by looking at TCP/IP's IP Addresses ...
- 2,142
2
votes
2
answers
5k
views
How to determine which one is my default instance in MS SQL Server?
I have two instances in my server and I want to know which one of them is the default. Can you, please, point out ways I can recognize it.
By saying a default instance I mean the one that listens for ...
- 2,142
1
vote
2
answers
7k
views
ORA-01503 CREATE CONTROLFILE FAILED... while trying to create a database
i am trying to create a new database along with another database. The server already has a database running. I used DBCA command to create the new db instance. First i set the new SID and home and ...
- 11
3
votes
3
answers
501
views
How to remotely connect SQL Server 2016. Since we have 2012 and 2016 in same server
Issue
I am not able to connect to a SQL Server 2016 instance on a remote system/server.
My Existing Environment
Windows Server 2012
SQL Server 2012 and 2016 installed on same server
I tried to ...
Sharad
1
vote
0
answers
934
views
Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1
Overview: In Informix is it possible to enforce ASCII for a database or instance.
Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
0
votes
1
answer
62
views
When do I need more than one Oracle Instance on the same server?
I have one application server separate from an Oracle server (one physical server). I have three instances on one Oracle Database Server (another physical server).
I want to have three environments ...
- 612
1
vote
1
answer
94
views
Attempting to setup a new named instance but can't get past the Feature Selection Screen
I have been going through and looking at all of the options listed via google for the better part of the day. No matter how I try to run this, whether initially from the straight GUI interface, using ...
- 11
2
votes
2
answers
8k
views
SQL Server 2016 Multiple Availability Groups and instances
So we are getting ready to make a major architecture shift and I get to be on the hook for it, yay!
Currently we have 22 separate availability groups each with their own windows cluster across 44 ...
- 165
2
votes
1
answer
15k
views
Mysql 5.7 Could not create Unix socket lock file
I am trying to create multiple instances of MySQL 5.7 in the same Ubuntu 16.10 32-bit box. I have copied the original data dir to the new one. Created separate log folder for the new instance(the logs ...
- 121
2
votes
2
answers
1k
views
Instance Recovery in SQL Server?
When the instance crashes due to unexpected disaster in SQL Server, how does the SQL Server recover the databases?
SQL Server goes through which phases to recover the data and which are the steps ...
user118167
0
votes
1
answer
3k
views
Which views can be queried while instance is up but database not mounted in Oracle 11G?
If I understood it correctly, when the instance is started, some views are loaded into memory and we can query against it like v$instance. And it doesn't need db to be mounted.
If so, are there any ...
- 155
2
votes
1
answer
6k
views
How does SSMS connect to a server's database without the instance name?
I have a question that I am confused about. I am also new to database stuff as well so this question may be basic.
For example, at my work, we use SSMS to connect to our server's databases.
When ...
- 23
2
votes
1
answer
1k
views
Why does ORACLE cache recovery create uncommited blocks during instance recovery?
The following is an excerpt from an ORACLE book
During cache recovery, Oracle replays the transactions from the online redo log files since
the last checkpoint. During this roll forward operation,...
- 335
1
vote
1
answer
2k
views
Multiple instance on single SQL Server
We have a server running single instance of SQL SERVER in production environment.
We are planning to create another Instance of SQL SERVER in same server.
My question do we have to buy a new ...
- 1,399
0
votes
1
answer
1k
views
Can an SQL Server Failover Cluster support a named instance?
If I currently have someName\instanceName on a standalone SQL Server and I want to migrate to a failover cluster, http://itknowledgeexchange.techtarget.com/sql-server/moving-a-standalone-instance-to-a-...
- 241
1
vote
3
answers
387
views
Which one is created first? Database or Instance?
The Oracle database includes all the physical files belonging to the server while the Oracle instance will provide the interface between the user and the data he wants to manipulate. But I want to ...
- 143
5
votes
4
answers
4k
views
A few huge instances or many small ones
I recently inherited an environment with around 4000+ databases distributed between 21 instances on 3 huge physical servers. Databases are distributed between different instances based on the name, so ...
- 508
1
vote
1
answer
987
views
TSQL Solution to backup ALL databases on ALL instances of a server?
I'm pretty sure what I'm wanting with my current implementation is impossible, the sys.databases catalog view which is scoped at the service level to be aware of other SQL Server instances (lol). But ...
- 311
0
votes
2
answers
787
views
SQL Server database stuck in Recovery after Restoring .BAK to same instance
We've had an issue crop up a few times -- maybe we're not using 'best practices' to restore, but appreciate any advice. We run an IIS app with a SQL Server database, and sometimes we run two+ ...
user3224972