Questions tagged [configuration]

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

Filter by
Sorted by
Tagged with
4
votes
4answers
335 views

SQL Server Optimization/Configuration for Inflexible Application

I'm responsible for overseeing an application which uses SQL Server as its backend storage solution. Unfortunately, the application has no concept of how a RDBMS should be utilized and seems to use it ...
7
votes
2answers
4k views

Connecting from SSMS to an EC2 SQL Instance

I have an EC2 server running SQL2008 R2. I opened the port 1433 and successfully tested with yougetsignal.com/tools/open-ports. I have set the SQL Server to Accept Remote Connections. I have set the ...
2
votes
2answers
4k views

Can't connect to/from SQL Server 2008 from my Windows 2008 server

I have a server with: Windows 2008 Server SQL Server 2008 enterprise From my server using SQL Server Management Studio, I can't logon to any SQL Server and vice verse, I can't connect to my SQL ...
0
votes
1answer
321 views

sql server express lan

I want to know if sql server (express) need to have always admin right on a computer. I ask my company to have a version on my pc, but I need a tech to install it because I dont have admin right. I'...
2
votes
1answer
3k views

How do I create a database+tablespace+user in Oracle 11gR2?

Good evening, I'm trying to figure out how to create a database+tablespace+user in Oracle 11g. I've tried some tutorials, but nothing seems to work. I cannot find Database Configuration Assistant ...
4
votes
2answers
5k views

Consequences of changing NLS_TIMESTAMP_FORMAT

I administer a 9.2.0.8 database where the NLS_TIMESTAMP_FORMAT is set to 'DD-MON-RR HH.MI.SSXFF AM';. This leads to odd results when using the CAST TO TIMESTAMP function: select CAST('14-SEP-2011' ...
2
votes
2answers
849 views

Differences between development and live database setups

I was wondering if there are any best practice recommendations on setting up databases in a dev environment versus a live environment with regards to configuration. Should they be as similar as ...
1
vote
2answers
829 views

Postgresql Cost-Based Vacuum Delay parameters

How to set the these parameters on postgresql.conf ? What I should consider while setting them? What should I monitor? #vacuum_cost_delay = 0ms #vacuum_cost_page_hit = 1 ...
14
votes
3answers
27k views

MySQL table_cache and Opened_tables

I have seen people use the comparison of Open_tables and Opened_tables to assess whether the table_cache is too small in MySQL. However, I believe that Opened_tables is cumulative across uptime, so ...
7
votes
1answer
2k views

Application Settings in Database

In the past I have stored all generic settings and configuration items such as: custom application title, home address, version, debug, etc.. all in a "settings.php" file that I would include into all ...
1
vote
1answer
529 views

SQL Server sp_configure options?

Does anybody know where I can find a list of all the parameter options for sp_configure? It isn't really jumping out at me when I search online for possible variations and the capabilities of ...
5
votes
1answer
3k views

my.cnf values not applying - Optimizing MySQL in CentOS LAMP

I have checked for other occurences of my.cnf and I have found only one occurrence of /etc/my.cnf. Then, I went ahead to fix in my values, e.g. query_cache_size etc. After saving and literally ...
47
votes
3answers
24k views

Is it possible to have passwords configured per database or per host in .my.cnf

I have the following in my ~/.my.cnf [client] password="somepass" but this is not the password I use for every user@host/database I connect to. Is there some way to specify in the config different ...
5
votes
3answers
11k views

How to open queries into a selected database in SQL Server Management Studio 2005

My situation: Using Microsoft SQL Server Management Studio 2005, I connect to a server -- I’ll call it Prod -- using Windows Authentication. Within this Prod server there are multiple databases: dbA,...
4
votes
2answers
8k views

Creating and editing my.cnf by MySQL Workbench?

I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the ...
6
votes
2answers
2k views

How to change SQL sever configuration manager settings using TSQL?

SQL server configuration manager is used to configure certain settings like connection protocols, service start up, etc... Is it possible to make these changes that is done in SQL server ...
3
votes
1answer
116 views

Is it possible to find the values of MySQL variables if I do not have SELECT privileges on mysql.user?

I am getting a 'msyql server has gone away' error sometimes when doing a large binary insert, so I wanted to check the settings on mysql, things like wait_timeout and max_allowed_packet. However show ...
15
votes
3answers
8k views

Why don't my .my.cnf settings work?

I have a .my.cnf file in my home directory on my desktop that includes: [dbid] user = myusername password = mypassword database = dbname host = server.location.com If I recall correctly, before ...
31
votes
6answers
22k views

Make SqlClient default to ARITHABORT ON

First things first: I'm using MS SQL Server 2008 with a database at compatibility level 80, and connecting to it with .Net's System.Data.SqlClient.SqlConnection. For performance reasons I've created ...
2
votes
1answer
727 views

SQL Server 2000 Enterprise Manager - “Navigation to the webpage was canceled” error when trying to design a table

While working in SQL Server 2000 Enterprise Manager on a remote server today, I wanted to look at a table's columns, so I found the table, right-clicked on it and selected "Design Table". Instead ...
9
votes
4answers
40k views

Why does MySQL say I'm out of memory?

I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception: Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes) ...
38
votes
3answers
43k views

How do you calculate mysql max_connections variable?

How do you calculate mysql max_connections ? What do you take into consideration ?
7
votes
1answer
2k views

Can PostgreSQL tell me what configuration files it's using?

I am having trouble with some changes I'm making to a configuration file. I think PostgreSQL is not using the ones I'm modifying. Is there any way to get postgres (maybe some environment variable) to ...
12
votes
5answers
8k views

Are there any MySQL Benchmarking tools? [closed]

I've heard a long time ago that there is this tool that helps you tweek mysql settings for better performance but i can't seam to find it. I am aware that I can use ab for apache to simulate high ...