Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [disk-structures]

45 questions
12
votes
1 answer

Understanding block sizes

My question targets Postgres, but answers might just be good enough coming from any database background. Are my assumptions correct: Disks have a fixed block size? RAID controller can have a differnt block size? Does one RAID block get split onto…
Franz Kafka
  • 577
  • 2
  • 6
  • 16
12
votes
3 answers

SQL Server: filegroup for system tables only?

One of our corporate standards to is have a separate filegroup/file for user tables/indexes. This is set as the default so no need to qualify CREATE TABLE statements. So it looks like this fileid 1 = system tables, MDF fileid 2 = t-log =…
gbn
  • 70,237
  • 8
  • 167
  • 244
11
votes
4 answers

Help me choose a RAID level combination for a SQL Server 2008 instance

I am going to rebuild one IBM 3400 server from scratch. This server is dedicated to a SQL Server 2008 instance running on Windows 2008 R2. I am going to make new RAID configuration. I have 6 SCSI 73 GB drives inside the machine and an IBM…
adopilot
  • 2,443
  • 8
  • 31
  • 46
8
votes
2 answers

SQL Disk Setup Advice - TempDB, Log DB, Data file placement question

We have a very active database server with a ecclectic collection of applications running on it. Two of the busiest are a Laserfiche database that does document scanning and workflow processing all day long (average of around 2800 batch requests /…
RThomas
  • 3,446
  • 6
  • 30
  • 48
8
votes
2 answers

Splitting TempDB into multiples files equal to number of CPUs

The article SQL Server tempdb Best Practices Increase Performance suggests that I should split tempdb into a number of files equal to the number of cores. So for 4 cores you get 4 files. By having the larger number of files, you can increase the…
Preet Sangha
  • 907
  • 4
  • 11
  • 22
8
votes
2 answers

How should I configure these disks on a SQL Server for a BI configuration?

Assuming constant memory (32gb) and CPU (4), 2 x disk arrays, I have the following disks 2 x 150 (10k) 6 x 150 (15k) They are all local disks. My requirements My DB is 350gb and set to default 10% growth My OS & SQL Server are Server 2k8R2 (C:…
Preet Sangha
  • 907
  • 4
  • 11
  • 22
8
votes
3 answers

How to create a flexible table schema for storing messages from different chats?

Help please solve the following situation: There are two kinds of API where message history is stored, it's Zopim and Chat2Desc (import into Postman). While these two but can then others appear. And my database with the users table: Table users id ,…
Vanya Avchyan
  • 141
  • 1
  • 1
  • 9
7
votes
2 answers

Single Drive vs Multiple Drives

Generally bottleneck of RDBMS (I am a MySQL user) performance is disk access. SSD provides great performance compared with conventional spindle drives. Question : Is it possible to improve performance by attaching multiple drives of reduced space,…
Rick James
  • 1,271
  • 3
  • 15
  • 19
6
votes
2 answers

Unknown Db file format - best way to find out?

A client has given me the data he wants visualised in my project - but I don't know what DB format it's in. He's pretty unclear, also.. I have access to the table structures, but don't know how to read it in. It's definitely not a flat file. There…
DefenestrationDay
  • 165
  • 1
  • 6
5
votes
2 answers

RAID10 vs. RAID5 for data files

We are trying to evaluate the potential performance improvements that could be gained by switching an existing applications .mdf files to a RAID10 LUN vs. the existing RAID5 LUN they are living on right now. The transaction log already lives on a…
Zero Subnet
  • 183
  • 2
  • 5
4
votes
2 answers

Change drive letter (which contains system dbs)

Is it possible to safely change the drive letter for a volume which holds only system databases? What precautions should be taken and how should it be done? I know I can just go to computer management > storage and change drive letter but can have…
WhoIsNinja
  • 157
  • 1
  • 2
  • 6
3
votes
2 answers

RAID Storage Technology Outdated?

I am working on designing requirements for new SQL Server installation. I have been researching disk storage and everything seemed to point to using RAID. However, I found this article, which suggests RAID is no longer relevant today. Can anyone…
K09
  • 1,454
  • 13
  • 39
  • 61
3
votes
1 answer

Extreme storage beasts

Intro I have derived this question from my previous question Single Drive vs Multiple Drives After getting a very detailed answer from a very helpful member RolandoMySQLDBA and learning the fact that multi drives can help a lot in some cases. I…
Rick James
  • 1,271
  • 3
  • 15
  • 19
3
votes
1 answer

MySQL InnoDB data file directly on a disk slice (fixed-size)?

It seems that ibdata1 is like a disk slice. In Solaris (UNIX) UFS filesystems (the common one before ZFS), one would separate their disk c0t0d0 into slices, say a 10GB drive would be cut into three sections, 4GB, 1GB and 5GB. These would be…
700 Software
  • 685
  • 1
  • 5
  • 20
3
votes
1 answer

How un-clustered is a CLUSTER USING table in PostgreSQL

I have some tables which benefit greatly from CLUSTER ON/CLUSTER USING in Postgres SQL: # CLUSTER table USING index_name; # ANALYZE VERBOSE table; # CLUSTER VERBOSE; A maintenance task periodically runs CLUSTER VERBOSE to keep things fresh. But is…
Bryce
  • 135
  • 6
1
2 3