Questions tagged [storage]

For questions about the persistent storage of database data.

Filter by
Sorted by
Tagged with
1
vote
0answers
629 views

Why is SQL Server unable to access partitions stored on UNC paths?

I have a database with its primary file and log file stored locally. One table is split into 101 partitions which are stored on a Windows share on another server accessed by a UNC path. Each partition ...
1
vote
1answer
231 views

Is SQL Server's fill strategy the same for multi-file tempdb as multi-file (non-tempdb) filegroups?

Will tempdb I/O from a single query be split across multiple tempdb files? (assuming that tempdb is configured to use multiple files, of course!) For non-tempdb databases, MDSN seems to say that yes, ...
1
vote
1answer
406 views

What does "volume" mean in MAX_IOPS_PER_VOLUME?

When setting MAX_IOPS_PER_VOLUME in a Resource Pool, what exactly does "volume" mean? Specifically, how many "volumes" would be the following cases: Locally attached disk that's split into two ...
2
votes
1answer
90 views

How does combining columns save disk space?

I am creating a table in SQL server and inserting records. Three columns from this table are AAA int, AAB int and AAC int. If I merge AAB and AAC into one column Comb1 char(2), it consumes 20% less ...
1
vote
2answers
1k views

SQL Server Disk throughput slower than diskspd

This is a bit of a broad question but I am trying to understand a storage performance behavior with two of our servers. I was following https://www.brentozar.com/archive/2015/09/getting-started-with-...
5
votes
2answers
2k views

How to reclaim the storage space used by a heap?

I have a table without a clustered index in SQL Server 2008R2 Standard with a lot of unused space, as shown in the following image: How do I reclaim unused space from MyTable? Said table is declared ...
8
votes
1answer
200 views

Can't SQL Server store NULLs in fixed-length columns?

I came across this statement in the official Oracle documentation: In Microsoft SQL Server, only columns with variable-length data types can store NULL values. When you create a column that ...
3
votes
3answers
543 views

Configuring physical storage for a Microsoft SQL Server installation

I'm configuring a Microsoft SQL Server installation which will use a SAN for storage. For SAN storage I have: A small number of SSD disks A larger number of 10K disks My SAN supports storage ...
3
votes
1answer
3k views

Storing PLC Data in SQL Server database

I'm developing a software solution that requires storing raw data points originating from many PLCs (programmable logic controller, used to control industrial machines such as conveyor belts and ...
0
votes
0answers
37 views

How to use container to do database high availability?

About traditional database high availability, the method is like: master-master replication master-slave replication automatic failover If use container to do that, we can use these ways: Use ...
0
votes
1answer
736 views

What is an efficient storage method to store Graph Data from GraphX (Spark)?

I generate graph data using Spark's GraphX library and I need an efficient way to store graph data. I have access to Apache Cassandra and ideally I want to store the graph data in there but the issue ...
1
vote
0answers
61 views

What parameters should I use to measure storage I/O capabilities

I want to measure the throughput of my disk subsystem using: https://gallery.technet.microsoft.com/DiskSpd-a-robust-storage-6cd2f223 what parameters should I use to closely emulate SQL I/O? Is there ...
1
vote
0answers
242 views

Why ndb data memory is 94% if i m using disk storage cluster

I have following structure 2 data node 1 management node 2 sql node i have create one log file of initial size 200M then created table space and added 3 data file data1.dat (initial size: 10GB) ...
2
votes
1answer
2k views

How do I increase the storage available for a SQL Server instance on AWS RDS?

The Amazon docs state that you cannot increase the storage allocated to a SQL Server RDS instance: Note that you cannot change the storage capacity nor the type of storage for a SQL Server DB ...
1
vote
1answer
275 views

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

I am using Django and postgres for a multi-tenant webapp. We have around 100 tables and each table has a tenant_id column, identifying the tenant of that particular row. I need a solution that would ...
0
votes
1answer
117 views

How PostgresSQL stores duplicated VARCHAR values in a column

I have a VARCHAR(255) column in a table with about 50 million rows. In that column there is only 10 unique values, which act as labels. I'm wondering whether Postgres does something smart and stores ...
1
vote
1answer
347 views

NVMe+bcache as huge storage cache for vertica database

We are in process of selecting hardware for 3 machines vertica cluster capable to serve 20-30TB of data (15TB compressed). This translates to 8TB of post-RAID storage. With 16 CPU cores, the storage ...
0
votes
1answer
40 views

Searching for scalable storage solution

In one project I save statuses of processing in MySQL table: `id` `name` `email` `has_apples` `has_bananas` 1 Bob a@b.c 1 0 2 Mike c@d.e 0 1 3 ...
0
votes
2answers
43 views

Storing meta about a cropped photo [closed]

Want to know how to save cropped images in the database? The info about the images or reference to the cropped images in itself? Working on a marketplace for artists where artists can upload their ...
2
votes
2answers
145 views

What is the most efficient way to store a bunch of empty fields, and ones with only a few choices?

When I say efficient, I mean total storage(kb), and not excessively burdening the CPU. I have 70 columns of data. The last 35 fields have always been NULL. The table has only 4 columns of ...
0
votes
2answers
96 views

How to install MongoDB database as a service in ESxi?

I want to know is it possible to install mongodb directly to the ESXi without guest OS? Please tell me how to setup Data storage as a service environment inside ESXi.
1
vote
1answer
620 views

Can we use VMDK for FCI on SQL Servers?

Can I share a VMDK among 2 nodes for an active passive setup for a SQL Server Failover Cluster setup? Most of the articles I see mention to use RDM's, however we use Veeam backup for the environment ...
1
vote
1answer
900 views

Allocation Size for Backup disk on SQL Server

What would be the optimal allocation size for a backup disk for SQL Server? We have a 2014 instance which was using Veeam backups till recently, but we decided to switch to local backups again for ...
0
votes
1answer
3k views

move AG database files between disks

Environment: SQL 2016 SP1, AG with 2 replicas, sync commit, no readable secondary. 1 file in the PRIMARY FG, 1 for the index FG. Problem: How to move the files for a database in this AG, from the ...
2
votes
0answers
102 views

RethinkDB storage calculations

I am trying to estimate storage requirements for the data our application will store. After doing some research I can pull out data from the stats table. However, I don't understand how those numbers ...
9
votes
2answers
2k views

How exactly does the one-byte "char" type work in PostgreSQL?

I often see people talking about "char". I've never used it. It's defined in the docs as, The type "char" (note the quotes) is different from char(1) in that it only uses one byte of storage. It is ...
1
vote
1answer
101 views

Shared logarch across multipe db2 HADR instances

Background We are looking into building a multiple standby hadr cluster. The Auxiliary standby is in a geographically separate location. from Developer works In a multiple standby system, the ...
13
votes
4answers
9k views

Drives vs. Mount Points?

The previous Senior DBA set up mount points for all of our drives across every SQL Server throughout the company. The new Senior DBA is horrified by mount points wants to change our standard (mainly, ...
1
vote
1answer
111 views

Remove Local RAID Drive from MS SQL Windows Cluster

We recently stood up a production SQL Server 2014 Enterprise on a two-node Windows Failover cluster (Active/Passive). We had some SSD's laying around and decided to use them for the tempdb for one of ...
1
vote
1answer
67 views

Windows Clustering and SQL Availability Groups

I am new to Clustering and Availability groups. I am creating a 4 node Windows 2012 Cluster with SQL 2016 enterprise. SQL will not be clustered we are just using the availability group option. The ...
2
votes
2answers
388 views

Best Way To Migrate Existing Production Database To New Physical Storage Structure

I have recently taken a job as a Senior Database Administrator at a small but rapidly growing company. My first order of business was a clean up the logical design of the main database (adding primary ...
1
vote
1answer
659 views

Best practice for storing large files (+1GB each) [closed]

I am looking to build a big data platform for weather forecasting. I will be using a numerical model known as WRF which takes in GFS files and produces files which can be over 1GB each. I will be ...
0
votes
1answer
507 views

Identify Full Text Catalog Files

I'm trying to write a query for a report to show how much free space is in our data files so we can plan storage for the future. I'm pulling data out of sys.database_files, and I can narrow it down to ...
6
votes
2answers
1k views

Seperate volumes for tempdb, data, and backups on SQL Servers in VMs

When configuring new SQL Servers on VMs, it is a good idea to have the Database, TempDB, logs, and backups on separate logical drives, even if the underlying storage is the same? I know that this is a ...
0
votes
1answer
505 views

JSON storage requirements for MySQL

I could not find storage requirements for JSON type columns in MySQL documentation How much storage space allocated for JSON type column in InnoDB? Are JSON columns the same as BLOB?
0
votes
1answer
84 views

Storage does not failover in Windows cluster

I created a lab setup for a 2 node cluster using Windows 2012 R2. I first configured the quorum and performed a failover between both the nodes, the quorum would also map to the respective node. But ...
24
votes
2answers
12k views

How to store one-byte integer in PostgreSQL?

In PostgreSQL documentation, it is said that integer data types can be stored in either two-, four- or eight-byte space. One of the columns of a table in my database contains a one-byte integer value ...
0
votes
1answer
45 views

Alwayson + FCI with independent Storage

I have setup with FCI+AG solution but with independent disks. There is no listener, and the applications are connecting to the FCI. Is this setup even reasonable to use? The only option I see here is ...
2
votes
3answers
110 views

Why does imported txt table consume so much space

I have a .txt file with storage size 1253 MB. After importing it to SQL Server 2016, the table takes 1680 MB on disk. Why does the storage space grow so much? I didn't do any data transformation and ...
0
votes
1answer
4k views

Measuring IOPS in SQL 2014

We have a LANDEsk migration going on where several servers are being consolidated into one SQL 2014 Cluster. What would be the best way to calculate IOPS for such a scenario? The data is still being ...
0
votes
2answers
410 views

Postgres Database too large to start service

Due to some craziness on a server I am looking after, I have a huge database that needs to be truncated (44GB despite being a simple site). However, I can't start the postgres service as there is not ...
4
votes
2answers
564 views

Capacity planning for SQL Server consolidation

My company has a small SQL environment for LANDesk and they want to migrate all the servers to a single SQL cluster per region. What I want to know is, how do I determine the capacity for such a ...
1
vote
1answer
60 views

Precautions for moving a SQL cluster from an old to a new datastore

My storage team wants to move a SQL cluster (2 node VM) from an old data store to Storage vMotion . What are the precautions I can take before this exercise is performed? I am planning to take ...
2
votes
1answer
526 views

How to get space used by In-Memory table in SqlServer

I'm trying to understand how much storage In-Memory table consumes in SqlServer: SELECT is_memory_optimized,durability_desc FROM sys.tables WHERE name='TBL_HSD_AD_OR' select count(*) [#Rows] from ...
0
votes
1answer
2k views

DBPATH, LOGPATH and STORAGEPATH

Assuming that there are only two available paths, say /log and /data. Would it be better to set DBPATH to /log or /data. I.e. CREATE DATABASE WHATEVER AUTOMATIC STORAGE YES ON /data DBPATH ON /log; ...
2
votes
1answer
392 views

How to estimate the storage needed for a database?

I ran across this questions trying to dive into a computer measurements worksheet online and for the life of me could not figure it out. This is the question: Assume each record in a database ...
2
votes
1answer
82 views

Data from different tables into one table

I've requirement where I need to store information from different sources in my system and the process that data. When I say from different sources it will be completely different table structure from ...
4
votes
2answers
9k views

Azuredb The database 'tempdb' has reached its size quota

We are runnig a V12 Azure Database instance on the S3 tier. There is still about 100GB of a free space on the database. When loading 85MB XML file with SSIS running on a different non azure SQL server,...
-1
votes
2answers
1k views

How can I estimate the size of a new table?

We have tables with a lot of data (50M new rows each month, just in one table). Now I want to know what would be the impact of adding a new column to those tables, or creating a new table. Something ...
0
votes
1answer
846 views

DB2 9.7 - how to release unused space back to the OS?

I am looking for a clear set of instructions on how to release unused space back to the operating system from a DB2 9.7 instance running on a Windows box. IBM's docs might be great if you already ...