Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
55 views

What is the best type of account to use for SQL services? [duplicate]

We run stand alone instances all virtual. SQL 2012 - SQL 2017 Backups are performed by a third party tool so the server has no need to access anything on the network. Agent jobs are all run via ...
0
votes
1answer
42 views

What is the SQL Server cost, in terms of performance, of sharing physical disks?

I am an application user in Health Care. The application relies on communication with a large database, including image data and other large numeric arrays. We add approximately 15GB per day to the ...
1
vote
1answer
126 views

Splitting large database into smaller ones

Our system currently stores all customer (merchant) accounts in one "flat" MySQL (5.6) DB namespace. We would like to scale out better - we are considering breaking our data up based on the merchant ...
1
vote
2answers
481 views

SSMS does not open popup wizard to create a new schema

When I right click on 'schemas' and then on 'create new schema' my SSMS only opens the query editor but on every tutorial I saw a pop up wizard opens instead. How can I access this popup wizard? I can'...
0
votes
0answers
45 views

MySQL 8 using the wrong tmp directory

I have a query like so... INSERT INTO table3 SELECT DISTINCT * FROM table1 LEFT JOIN table2 on ... And it uses a temp table. The query runs for about 60 seconds, then starts filling /tmp even ...
2
votes
1answer
1k views

How can I disable parallel queries in PostgreSQL?

I want to benchmark some things in PostgreSQL. When I do this I normally turn off some of the features the database is currently using, just for my session, to see what the second-best plan is. ...
0
votes
1answer
48 views

How to restrict mySQL queries to not affect server and take it down?

There are times that some heavy queries increase server load and after sometime both CPU and Memory reaches 100%. This is my.cnf configuration file: [mysqld] expire_logs_days= 2 pid-file = /...
0
votes
2answers
41 views

Is there any Cross-platform SQL editors that allow joins from different databases?

Initially tried dbeaver but after configuring it, I realized that you can't perform joins from different data bases. Also tried TeamSQL which apparently does what I need but looks to be designed ...
0
votes
1answer
50 views

AlwaysOn Availability Groups on Secondary Replica

We have a Primary Server A with a Database. It has AlwaysOn ReadOnly Asynchronous which moves data to Server B. Out of curiosity, is it possible to place Server B on AlwaysOn and move it to another ...
2
votes
1answer
234 views

Proper Guidelines for new Database setup in SQL Server [closed]

I need proper guidelines to setup Database in SQL Server for sales Application (Its a huge Data Transaction System). Specifically i'm looking below information: How to define initial size to create ...
0
votes
0answers
49 views

Reporting server configured in a separate Web server

I am new into configuring Reporting server and I did install and configured reporting server in a separate app server (lets say on app-01). I have my database server running on a separate server, sql-...
0
votes
1answer
119 views

Best mysql config for my server

I have dedicated server, CPU is too high (80%-100%) and memory only use 9gb RAM 32 gb and CPU Dual Xeon E5-2670(8core and 16 thread) I have 25000 users that use my android application My database ...
1
vote
2answers
78 views

MySQLTuner request - high CPU problems

I've been running a pretty high pop website for a few months new and as its growing we've been having some problems lately. Its a 2 core Xeon, 8GB, SSD server. We're pulling +- 150k people a day. ...
1
vote
1answer
36 views

SSMS 2017 Export SCOPED CONFIGURATION

I reinstalled Windows 10 from scratch. I'm trying to get SSMS options setup the way I like them. When I r-click a DB, then Tasks->GenerateScripts, the result doesn't contain SCOPED CONFIGURATION ...
2
votes
1answer
160 views

System configuration to address poor PostgreSQL INSERT performance

Problem Symptom High CPU usage by postmaster child process associated with client connections attempting to INSERT low-volume rows (results in rows INSERTed 25x slower than using COPY ... FROM STDIN ...
1
vote
1answer
295 views

Error while trying to create a database for SSRS

I have installed SQL Server Reporting Services 2017, and my database engine is developer edition 2017. Now, while trying to configure SSRS from its Configuration Manager I get this error I have found ...
2
votes
1answer
84 views

pt-kill - how to securely allow access to mysql server when running as service

I know how to run pt-kill as systemd service: [Unit] Description = pt-kill myUser After=syslog.target mysql.service Requires=mysql.service [Service] Type = simple PIDFile = /var/run/ptkill.pid ...
0
votes
1answer
109 views

DB server VM's CPU configuration - 1x2Ghz or 2x1Ghz - which is better

We want to set up DB server in cloud hosting for MS SQL Server Express edition - OLTP workload for "just" 6 concurent users - mostly short and small transactions. Hosting company is charging each ...
1
vote
0answers
107 views

Percona 5.6.28-76.1: optimize config for database (Invision Power Board)

At the beginning I would like to explain that I'm not a DB expert. My hosting provider is struggling with DB optimization for my website. Unfortunately seems that they are out of ideas. I would like ...
2
votes
2answers
272 views

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

In Postgres 11, the CREATE DATABASE command that makes a new catalog has an option ALLOW_CONNECTIONS. The documentation says this option can be used to block all connections to the database: [ ...
0
votes
1answer
2k views

Query for all the Postgres configuration parameters‘ current values?

You can set various configuration parameters for Postgres by either editing the postgresql.conf file manually or by calling ALTER SYSTEM commands. These are two avenues for writing the settings, but ...
1
vote
1answer
131 views

Why is cross db ownership chaining on by default for system DB

I am reading about cross db ownership chaining Server Configuration Option It talks about how and why to use (or not) this option and says Setting cross db ownership chaining to 1 is not ...
5
votes
2answers
2k views

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

TL;DR I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (...
1
vote
1answer
4k views

How to edit `postgresql.conf` with pgAdmin 4?

Same Question as this: How to edit postgresql.conf with pgAdmin 3? but updated for the completely new (total re-write) pgAdmin 4. ➥ How does one edit the configuration files with the pgAdmin 4 app? ...
1
vote
1answer
172 views

how to script out all the permissions in a folder using powershell?

Using the script below I find out where are the data and log folders: declare @rc int, @dir nvarchar(4000) declare @data nvarchar(4000) declare @log nvarchar(4000) ...
-1
votes
1answer
38 views

MongoDB replica set configuration problem

I'm facing some issues when trying the following: I have a three-node MongoDB 4.0 cluster, no sharding, one mongodb instance as primary, the rest as secondaries. When I shut down the primary, one of ...
3
votes
1answer
2k views

Cannot remotely access PostgreSQL on EC2 instance

I was unable to access a remote AWS postgres database via things like psql -h *EC2ExternalIP* -U *me*. I would get: psql -h *EC2ExternalIP* -U *me* psql: could not connect to server: Operation timed ...
1
vote
0answers
760 views

Oracle Warning in Alert Log Regarding PGA_AGGREGATE_LIMIT

Introduction During the startup process of our Oracle instances, we are encountering the following error message in the alert log: WARNING: pga_aggregate_limit value is too high for the amount of ...
2
votes
1answer
948 views

Listing the Microsoft SQL Server configuration with the values set by mssql-conf?

The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys, $ sudo ./mssql-conf list control.alternatewritethrough Enable optimized write ...
2
votes
2answers
40 views

Availability Group Listener - Dedicated Server?

Should an AG Listener be set up on it's own server? If so, does it require it's own SQL Server license?
1
vote
2answers
2k views

Which file do I need to modify my.cnf MariaDB on Ubuntu 18.04

I want to modify these values: [mysqld] key_buffer_size = 256M max_allowed_packet = 128M thread_stack = 256K query_cache_limit = 64M query_cache_size = 384M innodb_buffer_pool_size = ...
3
votes
1answer
54 views

Steps involved in configuring SQL Server and its components after server is renamed

I have a cloned (duplicate) server with SQL Server on it and the server name had to obviously change once it was copied. This article describes two actions to perform: using below code to manually ...
1
vote
2answers
456 views

Setting isolation level at database level

We have a data warehouse that's being dropped and reproduced every night. We have lots of SSRS reports that use the warehouse. Sometimes an SSRS report goes wrong and will never execute, thus ...
0
votes
1answer
160 views

Set InnoDB as default engine and set a default collation

What should I do to set InnoDB as the default database engine? And is possible to set a default collation when I create a schema and tables (e.g. utf8mb4)? I don't want to have to choose these ...
1
vote
0answers
23 views

Setting up MySQL (Master-Slave) replication with all ready configured databases/tables

I am trying to configure MySQL databases using the Master-Slave Replication. Before I realized that I had to set up my environment using this replication, I already have 2 separate servers running ...
4
votes
1answer
547 views

Turn off telemetry in SQL Server install config file

I'm creating a SQL Server 2017 Image Completion config file, and the automatically generated one has a bunch of stuff about "telemetry". I clicked no to the prompts, but it still put several user ...
1
vote
0answers
226 views

MongoDB Warning impossible to clear

I'm using Ubuntu 16.04 and MongoDB 4.0.1. When I use mongo shell I got this : I STORAGE [initandlisten] I STORAGE [initandlisten] ** WARNING: Using the XFS filesystem is strongly recommended with ...
1
vote
1answer
362 views

Changing mariadb port

I'm trying to change the default port for mariadb to 52000. I've modifed the port in /etc/MySQL/mariadb.conf.d/50-server.cnf and restarted the service. However, each time it still starts up on the ...
1
vote
2answers
609 views

MySQL consuming memory, seeking advice on how to configure it

I have a small VPS that handles my 3 personal WordPress websites. At a certain time MySQL started consuming more and more memory and actually (for months) the server has been running at 99% RAM usage ...
0
votes
1answer
1k views

Where should I store a custom “.my.cnf” file?

I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...
0
votes
1answer
77 views

What are current values in PG admin configuration editor for postgresql.conf

I am tuning a postgresql.conf file and here is what is shown in PG admin configuration editor What does the current value corresponds to? For the shared buffers (red line), what is the value there?
0
votes
3answers
119 views

I got a 2 core Mysql Server with 25 GB of RAM, 1 TB of Hard drive running on windows server. What is the proper configuration?

I am relatively new in running enterprise db server and as a developer, I am used to running my DB in the default setting on more focused on the code. Now, I saw that the DB is not properly configured ...
0
votes
1answer
192 views

Tempdb Configuration best practices

I've been asked to provide my input on best practices to improve tempdb performance. I realise that this is a case by case basis and tempdb in one estate may have different requirements to another due ...
0
votes
1answer
375 views

Help with setting up MySQL on a dedicated server - detailed report given

I need help because I do not understand much MySQL settings on a dedicated server. I have one WordPress website installed with medium traffic with W3 Total Cache. The storage engine is InnoDB. ...
0
votes
1answer
52 views

Database organization for mirroring / partitioning / multistore [closed]

I know that is kind of generic question, but there is not other way to find a good answer. I have a requirement to create a network of a server and few simple PCs. My boss wants to have the database ...
1
vote
0answers
264 views

Designing a PostgreSQL database for high-volume updates

I am designing a database for a system that has to handle lots of writes operations (99%+ are updates, sometimes inserts) but at all times it has to provide fast reads. At the moment selects take a ...
4
votes
3answers
85 views

Can a MS SQL Server be named different than host computer?

I have a virtual machine that was built by our IT department to host various processes. They named the computer something incomprehensible like "XYSVC105" and I am not allowed to change it. I have ...
1
vote
2answers
1k views

Error when executing “create pfile from spfile”

I just installed Oracle database 12cR2 and am trying to startup a database. I am trying to create a pfile from spfile using following query. create pfile from spfile; Then I get the following ...
0
votes
1answer
34 views

Shrinking the database partition if autogrow is turned off?

I want to know: Are there chances of shrinking the database partition if autogrow is turned off? Also, are there chances of data fragmentation and increase in seek times if we fully extend size ...
0
votes
1answer
288 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...