Questions tagged [storage]

For questions about the persistent storage of database data.

Filter by
Sorted by
Tagged with
1
vote
2answers
875 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 ...
2
votes
2answers
104 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
0answers
61 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 data ...
0
votes
2answers
300 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
1answer
2k 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
545 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
578 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
270 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 ...
1
vote
2answers
92 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 ...
0
votes
1answer
81 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
374 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 ...
7
votes
2answers
13k 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
57 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
185 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? ...
2
votes
3answers
448 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
595 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
273 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 ...
0
votes
0answers
82 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
2answers
118 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 ...
1
vote
0answers
84 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?
5
votes
2answers
143 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 ...
1
vote
1answer
61 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
1answer
49 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 ...
5
votes
1answer
3k 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 ...
8
votes
2answers
14k 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 ...
1
vote
2answers
735 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
271 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
95 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 ...
4
votes
1answer
932 views

Storage size of a bigint table

I am working with a table that has this format : CREATE TABLE dbo.ID_STORE ( WORKING_ID bigint PRIMARY KEY CLUSTERED ) The table stores around 2 millions rows, but the stored ids are not consecutive,...
1
vote
2answers
253 views

SQL storage sizing - How to get statistics of what data is being accessed

How can I monitor which data is being accessed and which frequency? I'm in need to migrate several (very) small SQL Server instances, each which several small databases. Current configuration is ...
2
votes
1answer
9k views

What's the difference between Object.bsonsize and avgObjSize returned by db.collection.stats?

In my collection, my documents seem to be relatively similar. I need to know how much storage I'll need in my production server to store my documents, that's why I queried : db.collectionName.stats() ...
2
votes
1answer
194 views

How should a numeric value that is an external key be stored?

This is something I was pondering recently. trying to determine how to store certain values. The best wide spread example I can think of is Federal Employee Identification Number - more commonly knows ...
11
votes
1answer
3k 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
1answer
333 views

TempDB Best Practices For Shared Storage [closed]

Microsoft recommends separating the SQL Data Files from the Temp Files to limit device contention but what about cases involving shared storage. I have a shared environment where the data and temp ...
12
votes
1answer
5k 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 ...
1
vote
1answer
2k views

DB2 TRUNCATE command - DROP STORAGE option

I performed action TRUNCATE TABLE TABLENAME IMMEDIATE; but I did not used DROP STORAGE option. I read that it is default option if it is not put. It was not so big table regarding table space but I am ...
1
vote
0answers
328 views

How calculate per tenant disk usage in a multitenant database with tenant_id columns?

I would like to provide forum hosting as a service, for forum software I'm developing. The data is stored in a PostgreSQL database, in tables with a forum_id column. That is, all forums share the same ...
0
votes
1answer
1k views

what is the difference between data file and data block in oracle

I'd like to know if there is any difference between the data block which is the smallest logical unit of data storage in Oracle Database and the data file which is a physical file on disk that was ...
1
vote
2answers
87 views

How to best store limited specifications?

I want to create a database for a specific (ecommerce) product and I'm not quite sure what the best way is to store all my specifications. I know exactly which specifications I want and how to store ...
2
votes
1answer
277 views

Copying database to different hard disk

Total noob at database administration here, excuse my ignorance. I have a server running a Rails application that's using PostgreSQL. The database is saved on drive /z/, which seems to have filled up....
2
votes
1answer
66 views

Dividing data from one table to multiple storage

I have the following tables: [Table_A] [Table_A_Changes] The two tables are pretty large (more then 50GBs). The first one contains some data, and the second one records' changes.The database is in ...
0
votes
1answer
828 views

Automatic change of “initial size” of a database?

I just had a problem : days ago, on one of my client's databases, the LDF file suddenly grew up to 100% of the disk capacity. .TRN backups are correctly done every 15min (I don't think reducing this ...
0
votes
0answers
160 views

MySQL - Database has huge overhead but tables don't

I have some problems with two MySQL databases. The databases have huge overheads but none of the tables do. When I recreated the tables the overhead just reappeared aswell. I hope you can help me. ...
0
votes
1answer
2k views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
5
votes
1answer
3k 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 ...
0
votes
1answer
241 views

SQLIOSIM fails to run when using UNC path

I'm trying to run SQLIOSIM on NAS cluster's NTFS shared folder. Here's the command line: sqliosim.com -dir \\c16\vol1cifs -size 512 -d 600 But it repeatedly fails to create files during the setup ...
2
votes
1answer
1k views

Best open source DB technology to store and query large, sparse matrices [closed]

I have a large vector space model, in which each point is a multi-variate observation. In other words, I have a large number of pretty large records, mostly of ints and floats. I started with in-...
1
vote
1answer
123 views

Proposal: MySQL blob handling revision [closed]

Why does MySQL store blobs in the direct table rather than off to the side so that if it needs to read the corresponding stuff it will read the stuff off to the side? Essentially it would create its ...
1
vote
1answer
660 views

Store logging in separate or existing database?

In a .NET WebForms project we want to log certain actions in a database for a year. The estimate is that the log will have a maximum size of 1GB (20.000 records per day of 10 fields) that will ...
0
votes
1answer
556 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 ...