Questions tagged [configuration]

The choice of settings for hardware, firmware, software or other components of a database system.

Filter by
Sorted by
Tagged with
1
vote
0answers
35 views

Why my Oracle 12C is allowing me to a connection creation without passing network security and integrity parameters

My Integrity settings Oracle Net Manager are: -- Integrity for - Server Checksum level - REQUIRED Selected Method : SHA1 -- Integrity for- CLIENT Checksum level - REQUIRED Selected Method : SHA1 ...
0
votes
0answers
13 views

How to handle spoon err: Permission Denied in Redis

I'm new to Redis and I'm facing this error on Windows 10 Pro (64 bit) when trying to do the background save of Redis: [14932] 18 Jan 10:57:24 # Failed saving the DB: Permission denied [14932] 18 Jan ...
0
votes
2answers
88 views

Best Practice for Oracle SGA and PGA Memory Components Size

I have a Server that has 128GB RAM. I have read here and there that the size of SGA + PGA can bee 80% of the RAM. I wonder if there is any best practice for this configuration that could allow Oracle ...
0
votes
1answer
41 views

Patroni with etcd starting up

I have an existing PostgreSQL cluster v11.5 with streaming replication. I want to set up high availability managed by Patroni. I installed Patroni on both machines, I set up an etcd cluster on three ...
0
votes
2answers
41 views

How to speed up full text query on a table with 4 million rows? (MariaDB)

I have an InnoDB full text table that serves the ajax-powered searchbox at the top of my website. I generate it with a daily script that pulls data from a dozen entity tables on the site, and ...
0
votes
1answer
28 views

Can we replicate or restrict specific databases in MongoDB

In MySQL, we are having replicate-do-db/replicate-ignore-db during replication, where we can replicate or restrict specific databases from Master to Slave. In the similar way, is there any specific ...
0
votes
1answer
46 views

MariaDB pegging cpu at 100%, need some help please

I am having issues with a server and have had issues for awhile but finally getting around to trying to fix it. When I run top, I see that 1 of the cores is near 100% and it usually never drops below ...
0
votes
1answer
53 views

How to change results cell padding in Azure Data Studio

In Azure Data Studio, I am trying to change the padding on the cells in the results grid. According to the settings page, this is editable in the settings.json: However, when I navigate to that file ...
0
votes
1answer
48 views

Postgres pg_read_all_stats default role cannot read from my schema

I have a postgres user created with the pg_read_all_stats default role permissions which states the user should be able to read as if superuser. This works fine for any of the pg_stat_* tables. ...
1
vote
2answers
165 views

Best approach for moving tempdb .ndf files

During a SQL Server installation, I "thought" I specified location of tempdb on 'F:' and not 'C:', but I can see that although tempdb.mdf and templog.ldf are on 'F:', the 3 .ndf secondary data files ...
2
votes
1answer
60 views

what could be preventing my transaction log autogrowth to be set to UNLIMITED?

I have been trying to set the autogrowth of one of my databases to unlimited but despite whatever I do it remains the same. First thing I have checked if something is holding any locks to my database:...
1
vote
2answers
37 views

Different Maximum server memory across Availability Replicas

I have a scenario in SQL Server 2014 AlwaysOn High Availability where other services are running in one of the Secondary read-only replicas. These services obviously demand additional memory. Is ...
19
votes
2answers
2k views

Which collation should I use for biblical Hebrew?

Which SQL Server collation should I use for biblical Hebrew? The database under consideration needs to accommodate diacritics (i.e., vowels, accents, trope, etc.).
0
votes
2answers
20 views

Postgres lowering max_connection

I have a question regarding max_connections in postgresql.conf. In the Postgresql documentation, it says it determines the maximum number of concurrent connections to the database server. Does it ...
0
votes
1answer
52 views

Scaling Users in MongoDB

Our team has been tasked with a fairly open ended request for a MongoDB with multiple users that can access and submit documents to collections for a graduate class. The team is all new to MongoDB and ...
0
votes
0answers
15 views

How to increase idle time of “LaunchPad” for SQL Server external scripts?

sp_execute_external_script can take a while to initialize when not run for a short time. How do I set the idle time on the controller Launchpad process to keep it from shutting down too soon? Note I ...
1
vote
2answers
55 views

Mysql Config Suggestions - CPU too high

My server (64GB,16CPUs) has mariadb 5.5.60. The queries are around 500 selects /second and 300 inserts/seconds. The queries are simple select of auth token and user details. Both are properly ...
2
votes
1answer
95 views

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under ...
2
votes
1answer
68 views

How to set a correct value for wiredTiger concurrentTransactions

I have a single instance in server with 7 Processor and 15 Gb. In value default for wiredTigerConcurrentReadTransactions and wiredTigerConcurrentWriteTransactions is 128. But is value default, how to ...
3
votes
1answer
167 views

AWS aurora (postgres) proper value for the shared_buffers parameter

I think it's fairly well known that a normal PostgreSQL database has a starting value of 25% of system memory for its shared_buffers parameter, but I haven't been able to find anything regarding a ...
0
votes
1answer
32 views

How to change the reporting services report service mode from Native to integrated?

In SSRS-2016, I am trying to change the Reporting services report service mode from Native to integrated. I added 2 new shared features to existing installation (See in the Pic) I am trying to ...
0
votes
0answers
10 views

Cassandara ec2 Number of Nodes and autoscale for increasing 70Gb of Data

I am beginner in Cassandra, I currently have 72 GBs of Data that is growing and i will have approximately 1gbs inserted into database daily. How can i decide number of nodes in the cluster and how ...
1
vote
0answers
21 views

Impact of changing server machines names with SQL Server 2016 Standard in mirror state

It's an enterprise network domain. Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
1
vote
0answers
25 views

Not able to update innodb_ft_num_word_optimize

We are using a AWS-RDS(MySQL 5.7) instance with 16GB RAM. We have a table with millions of entries and a FULL-TEXT index which needs to be OPTIMIZED. Apparently, FULL-TEXT optimization is very ...
0
votes
0answers
82 views

How to set psql command line arguments in a sql script?

The broad question is can you set psql command line arguments within a sql script? Something simliar to SET In particular, Postgresql psql has a -S option, which turns on --single-line. According to ...
0
votes
0answers
50 views

Setting up TempDB for more than one instance of SQL Server

I've been given the task of transferring the contents of a SQL Server instance from one Windows server to another Windows Server. One of the many things I need to do on the new server is set up the ...
0
votes
1answer
32 views

MySQL server upgrade, how to adapt variables?

I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
1
vote
1answer
102 views

SQL Server Security - Encryption [closed]

I have requirement to store the some sensitive information in SQL Server 2016. Organization policy demands, it should be encrypted. Business Requirement: Data cannot be decrypted by DBA. Data cannot ...
0
votes
0answers
46 views

Configure MSLocalDB in a .NET config file

I have created a .NET Standard C# project and a SQL database in my LocalDB server (LocalDb)\MSSQLLocalDB. I have tried to configure the connection string in the project web configuration file but in ...
0
votes
2answers
172 views

Max Connections Maria DB

Every time I reboot Mariadb places me the max_connections in 151 and in the my.cnf I have it with 300. Why does this happen?
0
votes
1answer
64 views

Setting up SQL Server Developer Edition

I just installed SQL Server Developer Edition and SQL Server Management Studio, how can I configure the server? I want to configure it to have server name localhost-sql-server, with a login/password. ...
0
votes
0answers
24 views

Why is turning on Event Scheduler Maxing my CPU?

I have search the web for the last week trying to figure this out. I have exported my tables and events, re-installed the lastest MySQL and imported. I have tried checking individual procedures. My ...
0
votes
1answer
514 views

wal_level both hot_standby and logical

I have a PostgreSQL setup with one master and three slaves. It's configured as streaming replication. Now, I want to replicate only a few tables from the master server to an analytic server using ...
3
votes
1answer
229 views

When do Azure SQL Database index rebuilds occur?

Azure backups occur every few minutes as per the documentation for Automated backups: SQL Database supports self-service for point-in-time restore (PITR) by automatically creating full backup, ...
1
vote
2answers
286 views

In Oracle 12c trying to create table with columns greater than 4000 [closed]

New to Oracle and SQL. I have already followed normal procedure to allow for this size: startup upgrade alter system set MAX_STRING_SIZE ='EXTENDED' scope=spfile; @%ORACLE_HOME%\RDBMS\ADMIN\utl32k....
-1
votes
1answer
190 views

Reducing .mdf file size

I have a drive, :d, in my server where I have my .mdf file stored and now all of a sudden I notice that the drive :d has no space left. When I checked the .mdf file of the database demo1, it is 1.6TB ...
1
vote
2answers
579 views

SQL Server default collation vs database with different collation - potential problems?

I'm struggling with the design of new database that has to use a different collation (Y Collation) than the SQL Server Instance default collation (X Collation). I'm looking for potential problems. ...
1
vote
1answer
35 views

Configure Postgresql column capitalization with being able to query using different capitalization

I have an existing database that we need to replace from MySQL to PostgreSQL. The problem being that we currently have two applications that use the database (one to create and one to view the data) ...
1
vote
1answer
75 views

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers, SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below: select distinct rcs.database_name, ar....
7
votes
2answers
224 views

Increase Max Memory setting on a SQL Server Production

I have a production box with 5 instances on. Version: SQL Server 2014 SP3 Enterprise. I discovered that even though the machine has ~400GB memory assigned, the combined MAX MEMORY settings on all 5 ...
0
votes
1answer
319 views

SSIS data flow gets stuck reading table with no errors

When I'm doing ETL in SSIS, the data flow task "pauses" reading from the source transactional Live IO DB (the one on the left). It stops reading the data and "pauses" on random rows and then does ...
0
votes
0answers
19 views

Mysql Shell doesn't change the configuration of my database for group replication

I am attempting to use a preexisting database on multiple nodes in a group replication setting. I am using mysqlsh 8.0.16, mysql server 5.7.24 and ubuntu 16.04 as the host. When I attempt to ...
10
votes
1answer
487 views

What are the ramifications of setting ARITHABORT ON for all connections in SQL Server?

So I've determined that the erratic behavior of my SQL Server is because of .Net SqlClient Data Provider's default setting of SET ARITHABORT OFF. With that said, I've read various articles that debate ...
1
vote
2answers
318 views

Target/total memory is higher than max_server_memory

I have the max_server_memory setting configured to 141 GB on our production SQL Server and target/total server memory is 144 GB. I thought max_server_memory represents how much memory I am willing to ...
1
vote
2answers
52 views

Can a user with readonly access change SQL server settings

Database administration is not a strong point of mine, and I was wondering if a user with read only access can change the server settings. In their query I can see this at the beginning: SET ...
0
votes
1answer
58 views

Installing Anti-Virus on Availability Group databases

Is it worth the risk to use Anti-Virus on Availability Group databases? Even following the guidelines given by Microsoft in How to choose antivirus software to run on computers that are running SQL ...
1
vote
3answers
1k views

Configuring the max_connections setting in MySQL

I've gone through a number of docs and forums but can't quite find the right answer for how to determine the number of maximum connections I should set. I tried using MySQLTuner, that gave me: ...
3
votes
1answer
446 views

Are innodb_large_prefix and innodb_file_format settings backwards compatible?

I got the following message when I tried to install a piece of software trough the command line. I use a mySQL db. * innodb_large_prefix = ON is required. * innodb_file_format = Barracuda is ...
3
votes
1answer
134 views

how to prevent replication to stop if there is no activity for some time?

On one of my transaction replication publications, when there is no any activity, after some time, the replication stops. Where can I see these replication settings? what to put in place to prevent ...
0
votes
1answer
126 views

SQL Server Configuration on Multiple Instance Server

I have a 2016 Standard edition server with two instances. The server has 8 logical processors and 40GB memory (it's a testing server on hyper-v so the spec isn't high!) and it doesn't have any ...