Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
2answers
44 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
39 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:...
0
votes
2answers
23 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 ...
18
votes
2answers
1k 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.).
-2
votes
0answers
12 views

PG database logical replication outof memory issue how to fix with good configuration?

PG database logical replication out of memory issue how to fix with good configuration? Which is better option for database replication - active /standby? We want to replcate data from source ...
0
votes
2answers
19 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
50 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
13 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
42 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
56 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
30 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 ...
2
votes
1answer
40 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
26 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
20 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
20 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
40 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
28 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
82 views

SQL Server Security - Encryption

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
28 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
38 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
61 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
21 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
202 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 ...
2
votes
1answer
83 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, ...
0
votes
2answers
143 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
131 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
223 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
29 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
61 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
166 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
206 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
16 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
391 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
262 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
48 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
56 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 ...
0
votes
3answers
632 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
308 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
129 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
68 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 ...
0
votes
2answers
190 views

How to change the expiration date of binlog files?

I have a server with Ubuntu 18.04 and MySQL 8.0.11 I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate. How to change the expiration date of binlog files ? ...
8
votes
4answers
2k views

MAXDOP Settings for SQL Server 2014

I know this question has been asked number of times and also has answers to it but, I still need a bit more guidance on this subject. Below is the details of my CPU from SSMS: Below is CPU tab from ...
1
vote
2answers
1k views

Error: “temporary file size exceeds temp_file_limit”

My database is suddenly hanging on some queries that join many tables and I see: temporary file size exceeds temp_file_limit (1025563kB) A sample query and query plan can be seen here: https://...
10
votes
2answers
942 views

Limit max CPU usage SQL SERVER with WSRM

I have a physical server running one instance of SQL Server. I notice that quite often this server is running at 100% CPU usage. My IT team is not happy about this, and suggested we reserve 2 of the ...
0
votes
1answer
174 views

MySQL 5.7 to MariaDB 10.3.13 configuration overwritten - correct way

I have earlier MySQL 5.7 over Ubuntu 16.04 with following configuration in /etc/mysql/my.cnf. [mysqld] innodb_buffer_pool_size = 1228M innodb_log_file_size = 512M innodb_log_buffer_size = 16M ...
2
votes
0answers
53 views

Questions and advice for complying with Federal tax information (FTI) Security Guidelines for Federal, State and Local Agencies per Publication 1075

I've been able to find writings on compliance topics (e.g. HIPAA, SARBANES-OXLEY, PCI DSS) but I haven't found much on FTI (Federal tax information) and Publication 1075 outside of the IRS website ...
0
votes
1answer
79 views

Use data from Mysql to ElasticSearch with Logstash

I'm using logstash for use my mysql database in ElasticSearch My conf is the next. input { jdbc { jdbc_connection_string => "jdbc:mysql://[ip]:3306/nextline_dev" jdbc_user =&...
1
vote
0answers
313 views

What is the best option for a large slowly changing dimension lookup table

This question is an extension of a previously asked question Index Strategy and Query optimization, which further extends this question: Search between IP string addresses I implemented the two new ...