Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
10
votes
3 answers

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want to use the slow disk for anything where it doesn't…
Niels Brinch
  • 413
  • 5
  • 16
10
votes
13 answers

Linux knowledge a Junior cannot miss

Possible Duplicate: What a beginner should know/learn for sysadmin job? I am soon going to be graduating from college, and am looking for job offers right now. There is one that I have a lot of interest in, involving Linux system administration…
HannesFostie
  • 845
  • 14
  • 29
9
votes
2 answers

How well does PostgreSQL perform with a large number of databases?

We have an web application whose architecture requires that any registered user (a company, actually) should be isolated from the other, i.e., I'll run the same webapp with the same data models, but with different data sets for every customer. So,…
Carlos Melo
  • 230
  • 1
  • 2
  • 8
7
votes
1 answer

Understanding IXSCAN and COLLSCAN in MongoDB logs

I'm attempting to grep through some Mongo logs in an attempt to find slow operations that I need to optimize. Slow query logging is at the default and is logging operations over 100ms. I think that it's safe to say that generally speaking a…
Antonius Bloch
  • 4,680
  • 6
  • 29
  • 41
7
votes
11 answers

When is it worth getting a DBA?

I've now worked at a few tech companies ranging from 10 people to ~150 and I've never encountered a real DBA. How big does a company need to get before it merits getting a DBA? What are the criteria that need to be met? (I also posted this on Stack…
Dinah
  • 407
  • 5
  • 9
7
votes
2 answers

Changing database owner in SQL Server 2008; CLR issues depending on method used?

I attached a database and tried changing the owner to a valid login. I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa". The database properties showed that the new owner was 'sa', however I was still getting permission errors…
Triynko
  • 3,418
  • 6
  • 31
  • 30
7
votes
5 answers

How much effort is SQL Server 2008 Administration?

I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so…
Adrian Grigore
  • 1,072
  • 3
  • 21
  • 34
6
votes
1 answer

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data transfer tools of SQL Server but I'm unsure of what…
Black Dynamite
  • 523
  • 2
  • 5
  • 16
6
votes
3 answers

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a table: 1286 - Unknown storage engine…
Tiffany Walker
  • 6,681
  • 14
  • 56
  • 82
6
votes
4 answers

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that would alert an admin when there is an error…
pjama
  • 163
  • 1
  • 4
6
votes
7 answers

How to optimize performance for MSSQL databases?

I'm a dba with a database with ~280 tables, and total datasize of ~1,5GB. I'd like to tune the database to make it perform better. What do you do to keep your SQL databases performant? How much fiddling with indexes, statistics, and defragmentation…
Frode Lillerud
  • 1,656
  • 3
  • 18
  • 20
6
votes
7 answers

Things every Oracle DBA should know

This could include: Books worth reading; Tools worth having; etc.
cletus
  • 9,999
  • 9
  • 37
  • 40
6
votes
4 answers

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and populated: How do I move all files related to a…
Matias Nino
  • 1,392
  • 7
  • 25
  • 40
6
votes
2 answers

Any way to copy the schema from one MySQL database to another?

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to have the same schema/table structures as the…
Continuation
  • 3,080
  • 5
  • 30
  • 38
6
votes
3 answers

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know starting off. Im graduating this December with my B.S. in…
user57862
1
2
3
…
19 20