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

learn more… | top users | synonyms (1)

1
vote
1answer
14 views

Update the current session's default parameter value to reflect a new default

Say I ALTER the database default search_path to include a new schema: ALTER DATABASE my_db SET search_path TO "$user",public,other_schema; Then I also update the current search_path to match: SET ...
1
vote
1answer
19 views

Reset search_path to the global, cluster default

Say I permanently alter my database's search_path like this: ALTER DATABASE my_db SET search_path TO "$user",public,other_schema; How can I reset it back to whatever the default that a pristine, ...
0
votes
1answer
20 views

how to force postgresql to filll work_mem?

i'm currently investigating a situation where my PostgreSQL 9.3 instance was killed by the Linux OOM Killer and went to recovery mode. The machine is EC2 Server with 16 GB of RAM and has rather few ...
0
votes
0answers
25 views

MAXDOP Recommendations - Is my understanding correct? [duplicate]

I have a VM SQL 2014 Server with the following CPU setup. If I follow MS recommendations for MAXDOP settings (https://support.microsoft.com/en-us/kb/2806535) I believe that MAXDOP should be 2 as the ...
1
vote
2answers
47 views

Determine ANSI_DEFAULTS setting ON or OFF?

How can I determine if ANSI_DEFAULTS is enabled or not on my server. My server is using IMPLICIT transactions and one way from which it can affect it based on setting of ANSI_DEFAULTS. How can I ...
0
votes
0answers
23 views

MySQL - What does ODBC's BIG_PACKETS option do?

I have seen the line OPTION=10 in some connection entries in ODBC.ini files, and found that it corresponds to the options 2 and 8. Those are defined in the documentation (PDF) as the following (...
0
votes
1answer
41 views

SQL Server 2014 login issue

I have a login issue here. I created a new user login in SQL Server 2014. I tried to connect to my database using this new login and the below error pops up Message Error: 18456, Severity: 14, ...
0
votes
0answers
20 views

What are the best settings of InnoDB for FULLTEXT queries?

This question has been asked before, but I was unable to find the right answer for my situation. We have a local server with Quad core and 32GB RAM dedicated for a single InnoDB database, which ...
0
votes
0answers
45 views

Export query execution settings from Management Studio

Actually, we're migrating from SQL Server 2000 to SQL Server 2014 (approximately 300 servers. With SQL Server Enterprise Manager 2000 and SQL Query Analyzer, we can export some settings (Connections ...
0
votes
1answer
21 views

Is there any database system that allows to have different schemas for different users but the same content for all users?

In my fantasies, it looks something like this: User 1: SHOW TABLES; +-----------------------+ | Tables_in_my_database | +-----------------------+ | table_1 | | table_2 | +...
1
vote
0answers
70 views

MySQL is using swap memory while I have plenty of free RAM

I have a 6 GB buffer pool size for my database; however, mysqld process is moving to swap while there is plenty of RAM available. I think pool size and pages along with pool of reads and pool of read ...
3
votes
1answer
29 views

Error When Trying to Run MDW Data Collector

I have SQL Server Management Data Warehouse (MDW) set up across multiple instances, all in the same way with the same accounts and permissions. On one server I get an error when trying to run the ...
-1
votes
2answers
30 views

Always On Stand Alones

Can I add a Stand Alone instance to a Windows Failover Cluster for Always On set up? I need to have one secondary synchronous replica with automatic failover.
1
vote
0answers
18 views

Download the replication snapshot file using FTPS

I have two databases for two companies. Company A's database contains domain data. The other company is pulling the data using snapshot replication. We have used FTP to communicate: Created FTP ...
0
votes
1answer
20 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
26 views

What is the significance of phpMyAdmin's configuration storage and what should I know about it?

After initializing phpMyAdmin on my server, I created a test database in the GUI platform. I realized that I had then received a notification in the phpMyAdmin browser that I needed to set up an ...
1
vote
1answer
52 views

Can mirror and witness have same port number? [closed]

When configuring database mirroring, the mirror and the witness have generated the same port number. When I hit next, it errors out with: End points for instances for the same server must use ...
3
votes
1answer
67 views

Can SSMS Object Explorer Details configurations be exported?

A number of employees make use of SQL Server Management Studio (SSMS). I have a configuration file for all new users for Environment (etc) configurations. I want to deliver a uniform view for each ...
5
votes
1answer
158 views

how to ignore the SSMS (sql server management studio) sql server ansi settings?

The options in Management Studio On Management studio Tools->Options->Query Execution->SQL Server there are options that are set and these prevail over the same options that are set on database level....
0
votes
1answer
43 views

Update my.cnf without restarting MySQL

I want to update my my.cnf without restarting mysql, is it possible? In fact I just want to set lower_case_table_names = 1, but I do not have the permission to restart MySQL.
0
votes
1answer
30 views

Enabling IPAII protocol disable remote conections. Why?

I have some servers with IPAII protocol enabled with a certain port: I'm using 1433 because a long story. but its working. We can use the default port 1433 AND IPAII ( for PHP developers ) with ...
1
vote
2answers
58 views

SQL Server engine in one place with database files on NAS

My office uses accountant programs which run on SQL Server 2008 R2. The SQL Server engine must be installed on one of the laptops (called "server") and the other laptops (called "clients") connect to ...
1
vote
1answer
31 views

no free memory but low total memory

I have SQL Server 2012 SP2 that has a max memory of 25.4GB but SQL Server is only using 15GB. When I check free memory with the PerfMon SQLServer:Memory Manger Free Memory (KB) counter only 40MB is ...
0
votes
0answers
30 views

Troubleshooting Case Sensitive linked server identification

Good afternoon, A few of our 2008 SQL servers were recently migrated to fresh 2014 installs, and I'm having trouble identifying where a breakdown is occurring in the linked server setup because of ...
1
vote
0answers
119 views

Basic PostgreSQL 9.x Performance Optimization Strategies for Reads/Analysis

Postgres comes, out of the box, configured as a general purpose database for both OLTP and OLAP types of loads. My need is to do use Postgres, in this case, purely as an OLAP running aggregate queries ...
0
votes
1answer
53 views

Possible hidden limit reached in MySQL instance

I'm developing a node.js/sails.js application and host my MySQL database on a Google compute engine instance. During load testing it hits some limit at 1300 RPS. The instances hosting the application ...
8
votes
3answers
145 views

Change the system wide default for maxrecursion

How do I change the system-wide default value of MAXRECURSION? By default it is 100, but I need to increase it to something like 1000. I am unable to use query hints since I'm using a program that ...
0
votes
1answer
51 views

Memory usage increases whenever I run stored procedures [duplicate]

I want to know why SQL Server memory use increases whenever I run stored procedures. After I stop and restart SQL Server, the memory used is just 1 GB. Each time I run stored procedures, the memory ...
0
votes
1answer
111 views

mysql: unknown variable 'table_definition_cache=400'

I added lines to ~/.my.cnf which worked fine for weeks. Now I receive complaints when I run myqsl CLI. System specs: MAC OS X - El Capitan 10.11.13 Mysql Version: mysql Ver 14.14 Distrib 5.6.29,...
1
vote
2answers
54 views

OOM in mysql-percona, memory leak?

Every second day, I run into an OOM problem. Mar 21 17:31:33 iZ23h7fvujwZ kernel: Out of memory: Kill process 60346 (mysqld) score 943 or sacrifice child Mar 21 17:31:33 iZ23h7fvujwZ kernel: ...
0
votes
0answers
31 views

Postgres 8.1 logging slow queries twice

For every slow query logged, there is another STATEMENT follows it in my log file. 2016-03-22 11:11:23 KST [9998]: [1-1] LOG: duration: 4796.936 ms statement: SELECT 1 FROM DUAL 2016-03-22 11:...
3
votes
0answers
72 views

Read replica setting giving error “No candidate servers found”

I am running my website with Laravel 5 + MongoDB. I am using mongo cluster to speed up data read and write, and to lower CPU usage of the mongo server. I have set up the replica like this: 10.0.1....
1
vote
2answers
135 views

Performance improvement by placing tables on a virtual RAM disk

I am trying to improve performance of queries by placing the tables in a virtual RAM DISK. I am using in Oracle 11.2 Standard edition with 4G of SGA and 2G of PGA. I created a Virtual RAM DISK of ...
1
vote
1answer
42 views

IBM FlashSystem V9000 storage - should the os, mdf and ldf and tempdb be separated onto different volumes?

Is there any benefit that justifies separating the os, mdf, ldf and tempdb onto separate volumes? RAID and redundancy is already included. Connection options to the host are: 16 x 16/8/4 Gb Fibre ...
2
votes
2answers
99 views

SQL Server Cluster Installation Failed

I need help trying to solve this as I've spent tons of time trying to figure this out but have had no luck. I created a VMWare Workstation test environment and I have been trying to install SQL ...
3
votes
1answer
115 views

Multi-instance SQL Server Standard Editon MaxDop settings

You read the title and are still confused? Well I am too. I've just started a new job as DBA for a new employer and have come across some creative ways of installing SQL Server. My previous ...
0
votes
1answer
43 views

Need to deny DML access through SSMS using web app credentials

A user can login to some web application and can submit any application which will affect the data(insert/update) in database, but that specific user should not be able to manipulate the data through ...
1
vote
1answer
221 views

MongoDB allocates chunks only to Primary when sharding is enabled

I'm setting up an instance of MongoDB with 3 shards. I've setup everything seemingly correctly by following the docs and comparing my config with that of a friend who has a similar setup but with a ...
0
votes
1answer
43 views

Linux Slackware MySQL can't move datadir

By default datadir was located in /usr/lib/mysql. I decided to move it to a different disk partition: /mnt/C/mysql: drwxr-x--- 25 mysql mysql 36864 Feb 25 12:52 mysql I opened /etc/my.cnf, but ...
0
votes
0answers
30 views

Configuring my.cnf file and parameters calculations

Hi i am new in database administration and learning to configure my.cnf. Can anyone help me about parameters in my.cnf and what values should be set for each parameter, and what are the calculations ...
3
votes
1answer
166 views

How to disable the logging of parameter values in PostgreSQL

Is there a way to disable the logging of the parameter values used in a query, while still logging the actual query itself? I'd like to set log_min_duration_statement = 0 to use with pgBadger. I'm ...
0
votes
0answers
30 views

How to query MongoDB sharding and replica set configuration from remote machine

I have to query to get MongoDB cluster configuration from remote machine through programming code. I can get these details from Mongo shell using sh.status() and rs.status() command. I am looking ...
0
votes
0answers
45 views

Better configuration for a In-Memory MySQL database?

I have a local MySQL database for the only purpose of execute some PHP tests. To improve the speed of the execution, I created the database in memory using the ENGINE=MEMORY statement in every table ...
2
votes
1answer
105 views

MySQL best performance settings [closed]

I am going to do some performance tests on MySQL server as I want to evaluate how MySQL behaves in some situations. MySQL is the only (additional) software installed on my server (Windows Server 2012),...
0
votes
1answer
22 views

MongoDB Configuration File Locations

Some databases search/check multiple locations for configuarion files, if it finds many, it merges and does a priority if same options defined. Does mongodb search multiple locations for ...
3
votes
1answer
186 views

Connect to PostgreSQL from different host

I am facing error while connecting to the PostgreSQL server from different host, I configured both postgresql.conf and pg_hba.conf but unfortunately with no result. So I have installed PostgreSQL on ...
5
votes
1answer
52 views

How to change default port for T-SQL Debugger

The default port for T-SQL Debugger is 135, it is possible to change this port ? In my company this port is on special list of banned ports, therefore we need to open that service on another port ...
3
votes
1answer
49 views

Redefine Transaction log size restricion fails

I am trying to set the transaction log's max size restriction to UNRESTRICTED using SSMS using the following dialogue: The actual setting is set to 2.097.152 MB - a nonsense value that exceeds the ...
6
votes
3answers
1k views

SQL Server Agent won't start

When I'm trying to start SQL Server Agent, I got this error: TITLE: Microsoft SQL Server Management Studio Unable to start service SQLAGENT$SQL_NAGA on server NAGA. (mscorlib) ADDITIONAL ...
5
votes
1answer
148 views

How to run SQL services on NT SERVICE\MSSQLSERVER account if it is running earlier on LocalSystem

Recently just for experimental puprose, I have relocated the default (C:...) data\log file paths in server settings to new location (G:\DBA). Then I've moved the previously existing db's data\log ...