For questions about the persistent storage of database data.

learn more… | top users | synonyms

0
votes
2answers
42 views

SQL Server Storage for multiple data files

Recently, our company wants to add 4TB on the drive size for SQL Server. We have two drives now which have different size and data files. In order to make sure our SQL Server has the best performance, ...
1
vote
0answers
37 views

SQL query fills up RDS free storage space after upgrade to MySQL 5.7

After the upgrade to MySQL 5.7 the execution of a SQL query fills up the free storage space. The upgrade was performed through the AWS console, selecting the automatic procedure to upgrade the RDS ...
9
votes
1answer
415 views

Storage snapshots for consistent backup of postgresql - different data and log volumes

We are running many Linux VM's in a vmware/shared storage environment, each running its own instance of postgreSQL (a mix of 9.0 and 9.3). Currently, the entire VM sits on a single root partition/...
1
vote
2answers
159 views

Choosing the right storage block size for sql server

There are many articles on what storage blocks size should be used for sql server e.g. Disk Partition Alignment Best Practices for SQL Server. The right blocks size should improve the performance of a ...
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 ...
0
votes
1answer
56 views

MySQL read-write Master with many read-only Slaves over shared storage?

I've asked the same question on the MySQL forum but have also seen lots of great responses here as well so thought I would try my luck here too. We have a relatively large MySQL environment where we ...
20
votes
2answers
13k views

Best way to populate a new column in a large table?

We have a 2.2 GB table in Postgres with 7,801,611 rows in it. We are adding a uuid/guid column to it and I am wondering what the best way to populate that column is (as we want to add a NOT NULL ...
4
votes
1answer
420 views

Storing phone number in E.164

TLDR; If I store a phone number in MySQL(or any DB with equivalent constraints), would the correct format be E.164 values into a VARCHAR(32) field? Have been reading up on format/storage of ...
1
vote
2answers
74 views

Which TLogs are causing large block change in SAN snap?

The environment is SQL Server 2014 Enterprise Edition, NetApp storage managed by CommVault Simpana. We have 100 dbs setup on an instance, all TLogs are on the same Volume. The SAN Admin has setup ...
6
votes
2answers
886 views

Should I use ReFS for a new SQL Server?

We are in the process of building a new production Windows Server 2012 R2 server to run SQL Server 2014 Enterprise Edition. There is a bit of advice on the internet that suggests for Windows Server ...
5
votes
1answer
238 views

SQL Server on SAN, same LUN: one logical drive vs multiple

First, let me start by saying that I did notice there are multiple similar questions to this, but neither of them is exactly what I want to ask, and not one of them has a definite answer. Second, let ...
1
vote
2answers
134 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 ...
0
votes
1answer
235 views

Is there any relation between BSON storage for mongoDB and MySQL storage?

I am working on an application where I need to make analysis that what will be the storage size of BSON structure if same data is stored which is stored in MySQL. Basically I am comparing MongoDB and ...
0
votes
0answers
29 views

MySQL Storage Engine and Memory

I recently found out that, the databases does not have standard architecture(data model), some of them are, No relationship between tables(entities). No indexes defined. Only integer and varchar ...
0
votes
2answers
65 views

MySQL Backup Strategy

We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy: Backup Type: Full ...
0
votes
0answers
14 views

Default Space in WAMP

What is the Default Space for MySQL in WAMP SERVER? We are using MySQL as the back-end for our application development, and it is running out of space. How can we increase the disk space? Or are ...
1
vote
0answers
20 views

Is there a way to store more than 65KB in NDB engine?

I have to store some json files that are larger than 64KB so they cannot be stored in TEXT fields in NDB engine. Is there a practical way to solve this problem? 2 points: I have no option but to use ...
0
votes
1answer
48 views

Error 823 and no connection

One of our servers tells us it has Error 823 issues: TITLE: Connect to Server Cannot connect to ServerName. ADDITIONAL INFORMATION: Warning: Fatal error 823 occurred at Mar 1 2016 > 10:...
2
votes
2answers
71 views

SAN for SQL Server: One large spindle set for all loads, or discrete by load?

SQL Server 2014, Standard Edition (running under vmware, fwiw). Adding a Dell MD3420 DAS box. In the old school, you would set up discrete spindle sets for MDF, LDF, TEMPDB, BACKUP. E.g. MDF: Qty ...
1
vote
0answers
84 views

Storing and searching user location using latest MySQL 5.7 spatial features

I want to use MySQL spatial features to store user location. I have read about MySQL spatial geometry data type. According to this article this works very well in MySQL 5.7 http://mysqlserverteam.com/...
1
vote
1answer
59 views

Set a Max allocated size for a sellected storage path in db2

I have a DB2 storage group with storage paths set like C:\ D:\ E:\ Size of my C: drive is 100 GB and the other programs keep crashing because it fill data drive by one, even I can allocate more ...
0
votes
3answers
63 views

Encrypt and keep sensitive data in MySQL

I have a process that parses a JSON API and loads the data into MySQL database. I have some sensitive data that should be encrypted, such as firstname, lastname, email, zip, address, credit card ...
0
votes
1answer
33 views

Perfmon Counters that relate to SQLIO

I am trying to benchmark a new virtual SQL server. this will be the first time I have virtualized a production SQL server. I don't think this is a supper busy server. 100-200 users, of varying ...
0
votes
1answer
89 views

SMB 3.0 file share storage limitation

What is/are the limitation/s to move from SAN storage to SMB 3.0 on windows Server 2012 - SQL server 2012 enterprise production environment? I want to know the benefit of using SAN over SMB 3.0 as ...
2
votes
2answers
544 views

PostgreSQL data files have size more than data itself

We have a system that does some data archiving to a PostgreSQL DB. We found out that the PC storage was full due to the DB archiving. The problem is that I checked the data files residing in /var/lib/...
1
vote
1answer
34 views

How to determine how much storage to store backups?

I was thinking about this question ( Here where I work, we have a lot of space so backups are dayli ok ), and i'm thinking about if I was hired in another company, and see that they don't have backups,...
1
vote
1answer
271 views

Are Blob Sizes Fixed?

I'm using sqlalchemy to store objects in a database. The kind of object I'm creating is unknown until run time. I could be storing something as simple as a string. I could be storing a jpg. I ...
1
vote
1answer
53 views

Is there a way to specify the initial size of MySQL File-Per-Table Tablespaces?

Preparing for massive data import into a MySQL 5.7 community instance, I'd like to know if there is a way to allocate upfront the total amount of space that will be used by the volume of information? ...
0
votes
0answers
32 views

What is database storage structure?

I'm curious that there is a term "storage structure" in the context of databases, but there is no clear definition to be found in the textbooks. Wikipedia https://en.wikipedia.org/wiki/...
2
votes
3answers
96 views

Discover available HD storage from inside SQL Server

I have a SQL Server 2012 instance hosted in a VPS. I can't login on VPS's Windows directly. I know that there are multiple instances installed on that VPS. I have a query that shows me each DB's file ...
1
vote
0answers
71 views

SQL Server index rebuild cause database growth

I have a 80GB database with about 20GB of indices size. Whenever I build the indices online the database file will grow to gain 20GB of unallocated space, and if the unallocated space is less than ...
4
votes
1answer
78 views

Would SQL in a cluster failover when transaction log for database is full?

I have a Microsoft SQL Cluster with one instance. If one of the databases is full, would SQL in a cluster failover when transaction log for database is full? If it depends on the reason the ...
1
vote
2answers
32 views

MySQL Drive Storage Allocation

In our production servers for SQL Server, we usually split our drives by Software, Logs, Data, and Backups. I've been assigned to help with a MySQL installation (On Windows Server) and I'm not as ...
0
votes
0answers
23 views

Is it possible to use secondary indexes with Mariadb and Spider?

I'm working upon a Mariadb cluster with 3 data nodes + 1 master node running Spider storage engine. Running queries from spider node, I cannot force data nodes to use secondary indexes, as happens ...
0
votes
0answers
36 views

MongoDB: poor compression rates

I'm importing a small set of data from Oracle in MongoDB. Basically, I have a table which is about 1Gb in Oracle (avg_row_len x nb. rows, i'm not counting the index sizes. Though data is compressed). ...
0
votes
0answers
37 views

Rule of Thumb on OS Free Space

This may be a difficult question to answer, but I have a PostgreSQL database running on a Linux server with 1.3 TB of storage. I'm currently at 73% utilization of storage space with a slow but steady ...
1
vote
0answers
26 views

Split Mirror Backup in db2

In my database apart from storing the daily backup, the disks are getting used for other purposes also. So how can I do the disk mirroring for Split Mirror Backup if I don't use external storage?
3
votes
0answers
65 views

Different Disk Drive Same Backend Storage

I have a database running on a VM which is getting hammered during a large load, in particular I can see waits of WRITELOG happening. My initial thought is to split the files out on to their own ...
3
votes
1answer
406 views

How do completely empty columns in a large table affect performance?

I have 400 million rows in a Postgres db, and the table has 18 columns: id serial NOT NULL, a integer, b integer, c integer, d smallint, e timestamp without time zone, f smallint, g timestamp without ...
4
votes
2answers
738 views

Storing Passport Numbers in a database

We're developing a travel/tourist application for a tours company who want to be able to input traveler information into an online database. Is there any security best practice for storing passport ...
1
vote
1answer
30 views

Normalize End Date - Nulls or separate table

I was hoping for some advice on best practice in schema design - as far as End Date values are concerned. In this case it is for a Suppliers table - we are required to store information on the Start ...
1
vote
2answers
683 views

SQL Server storage limits on Azure

Looking at SQL Server maximum capacity limits on here: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx Database size can be as big as 524,272 terabytes. Here, you could see VM size ...
2
votes
0answers
431 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on VM'...
1
vote
1answer
34 views

ASM and IPv6 Compatibility

In the whitepaper mentioned below, Under 'Limitations' it says ASM and fan based notifications are not supported by IPv6 in Oracle. I'm just curious what ASM has to do with ipv4 or ipv6 or ipv4? ASM ...
4
votes
4answers
1k views

Is database partitioning for performance reasons meaningful in a virtualized environment?

When running SQL server on physical hardware, placing database data and log files on separate disks or RAID arrays can benefit performance, resilience, and maintenance. Partitioning the database over ...
1
vote
2answers
261 views

Error creating database on new storage in SQL Server 2008 R2 Failover Cluster

Via the Failover Cluster Manager, I recently added a new disk to an existing SQL Server 2008 R2 Cluster, running on Windows Server 2012 R2. When attempting to create a database on this new storage, I ...
4
votes
1answer
208 views

Slow storage writes: how many milliseconds exactly? SQL Server 2008 R2

We're running SQL Server 2008 R2. I'm using SPBlitz and it's saying that I have slow storage writes on Drive H. Blitz defines these as "averaging over 20ms." But of course, someone asked "How much ...
0
votes
0answers
29 views

Storage strategy for polynomials

What is the most space efficient way to store arbitrary length univariate polynomials? I have a large amount of polynomials that look like 3*x^7 + 12*x - 13 9*x^32 - x^14 + 2*x^3 - 9 ... Each ...
0
votes
3answers
119 views

SQL Server RAID Storage [closed]

I have been reading about recommended SQL Server storage and RAID 5 or RAID 10 controllers have been recommended. On my existing Database server I can see 4 Storage controllers under Device Manager. ...