The disk-structures tag has no wiki summary.
2
votes
1answer
41 views
Does Windows Server File Compression slow Oracle DB performance?
I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure.
I can ...
0
votes
0answers
75 views
SQL Server backup/restore between systems with different storage sector sizes
We have a system where we create template databases and back them up and distribute them to customers. We recently upgraded our 'build' server to use SSD with a 512 sector size and received an error ...
0
votes
1answer
28 views
Disk page size for MySQL and MySQL cluster [closed]
As I know database reads data from disk in some constant page size (even if one byte is needed, whole page will be copied from disk to memory).
What are disk page sizes for MySQL and MySQL Cluster?
Is ...
0
votes
0answers
19 views
MySQL: system variables and status variables related with Disk I/O
How disk I/O is related with MySQL performance improvement. I have a MySQL-5.1.58 based Intranet application equipped with Windows 2008 server and 8 GB RAM. Even, When my application face performance ...
1
vote
1answer
1k views
SQL Server 2012 Express fails at repair install, produces error 5178
My SQL Server Express Service will not start up.
To produce this problem, I basically cloned my old hard drive (Which had SQL Server Express 2012 installed) to a new hard drive (Seagate Momentus XT ...
2
votes
2answers
447 views
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 ...
1
vote
1answer
86 views
How un-clustered is a CLUSTER USING table
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 ...
3
votes
2answers
1k views
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 ...
6
votes
2answers
331 views
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 ...
3
votes
1answer
2k views
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 ...
2
votes
3answers
3k views
Can I specify a different disk for a specific MySQL table?
I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
8
votes
4answers
2k views
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 ...
3
votes
1answer
142 views
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 ...
5
votes
2answers
702 views
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 ...
7
votes
2answers
2k views
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 ...
1
vote
1answer
840 views
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 ...
2
votes
2answers
955 views
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 ...
8
votes
3answers
707 views
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 ...
