Questions tagged [disk-space]

For questions about the storage space used by databases or database objects.

Filter by
Sorted by
Tagged with
2
votes
2answers
67 views

MS SQL running out of Disk Space - can FileGroups be used to free up some space?

Problem We have a Sql Server 2014 with a 1TB attached disk (on Azure) that's running out of disk space. We have about 20GB's left (maybe a few weeks of space). As such, we need to move some data off ...
1
vote
2answers
21 views

Add data directory on PostgreSQL 10

I have a postgresql database on / root partition (61GB used out of 63GB), so I asked the VPS provider to add more disk (50GB to /mnt/vdb1) How to add another data directory to that new partition (...
0
votes
1answer
13 views

MongoDB deleted logs

So I recently realized my /var directory was growing but couldn't find anything using du, then find out about lsof and found the following: lsof -nP | grep '(deleted)' mongod 23184 23205 ...
0
votes
1answer
39 views

Auto-Shrinking All Databases Files To Their Minimum Size In Sql Server

I restore my all databases in production to my development environment monthly. Development server has 4 TB disk space and there are 4 different instances over it which containt databases on the ...
0
votes
3answers
110 views

SQL Server Space Reclaim

We have a sizeable SQL Server 2016 database (running on Windows 2016 Datacenter). A table was growing exponentially due to a bad SQL process. The bad SQL process has been resolved, but the specific ...
-1
votes
2answers
33 views

Move database files from one drive to another

I am running out of space in the C drive. I have plenty in the D or E drive. How to I move database data from drive C to D or E?
0
votes
1answer
12 views

How to delete all rows in a Greenplum row oriented table

In Greenplum, what is the best practice to delete all rows from a table? DELETE FROM TABLE or TRUNCATE TABLE? I dont have any child tables or foreign key constraints.
1
vote
1answer
37 views

How to manage disk space allocation for materialized views?

Summary: I have materialized views in oracle 11g that seem to hog disk space, unlike normal tables that mark rows as deleted and stats eventually show them as free space (allocated to the table, ...
0
votes
1answer
26 views

Is there a way to determine what caused the last growth operation of my database (MDF file)? [duplicate]

If I don't already have any logging in place, is there any way to use the DMVs or anything else on SQL Server to determine which query / event caused my database's last grow operation?
0
votes
1answer
51 views

autogrowth set higher than available disk

First all our autogrow settings are either turned off or the file size is set to the max autogrow size. I guess same difference as I came in after the setup. Although I've never had this problem, I'...
0
votes
5answers
111 views

Restore DB Backup with limited amount of disk space

I want to restore a SQL Server database using a backup (.bak) of about 60GB. Is it possible to do this on a machine with only 100GB of free disk space? Or do I need at least the 60GB for the .bak ...
2
votes
2answers
40 views

SQL Server Table Reports Disk Usage 0 Rows but reserved 46 GBs

I've executed report on database "Disk Usage by Table" And I have couple of weird tables, where there are no rows, but disk used couple dozens of gigabytes. What caused such behavior? What to do with ...
0
votes
0answers
22 views

MongoDB Move data to another shard

I have a MongoDB with 3 shards: A, B, C. B's disk is full so everytime I start mongod it eventually stops. However, A and C still have GB of space. Hiring a new server with more space than B and ...
0
votes
0answers
11 views

Storage technique used in meet in the middle attacks

When a block cypher is used twice in a row, it can be broken in 2^{k+1} key searches (k denotes the number of bits used in key). This computational advantage comes at a price of storing 2^k pairs of ...
2
votes
1answer
63 views

Postgres: Why does pg_stat_get_dead_tuples return 0 when there is still wasted space?

Using Postgres 11.1, I have been trying to determine/estimate the amount of 'wasted' space in a table that would be recovered by a VACUUM FULL. My plan was to use pg_stat_get_live_tuples (L), ...
0
votes
1answer
101 views

How to find total used and remaining space in Azure SQL mi

I queried sp_databases and the sum of space occupied by all db's was 380Gb. The total allocated space for the managed instance is 800Gb. But, enquiring with the infra team found that we have only ...
0
votes
2answers
13 views

Mysql - tablename.ibd file is huge in size

I'm using MySQL 5.6 and innodb file per table has been enabled. I noticed that one file named as tablename.ibd is 211GB, then query the information schema there it's showing 21GB. I have done a huge ...
0
votes
3answers
104 views

AlwaysOn High Availability MDF and LDF file locations

We have 4 replicas with 03 replica in read only mode with manual failover. We have some drive issues and we need to rearrange the MDF and LDF files. On the primary we have 2 drives I and J. The I ...
6
votes
1answer
623 views

Disk usage of integer column vs boolean column in Postgres

I saw this question Bit vs. Boolean columns. I'm asking myself the same for Postgres: does a single digit integer column occupy the same disk space of a boolean one? In big tables (~50 columns x ~50 ...
1
vote
1answer
72 views

Is it safe to stop the shrinking of MSDB?

In a production server (Microsoft SQL Server 2014), the file MSDBData.mdf ballooned up to more than 450 GB, eating almost all the space in the server (only 38 GB remaining). First thing, I created ...
0
votes
1answer
31 views

Free space of toasted content

I have just deleted a big part of the data stored in one jsonb inside my users table (Its not needed anymore) and just keep an id inside that column. I expected to free a lot of disk space with this ...
0
votes
1answer
46 views

how to find tables with either sparse or a column set column?

from the error message below: A compressed index is not supported on table that contains sparse columns or a column set column as I was rebuilding an index and changing the data_compression to ...
1
vote
1answer
32 views

Run out of disc space on Debian server due to postgresql database

I recently run out of disc space no my server due to implementing some audit tools on Postgresql database. Two tables holding data about changes made by users quickly reached 16GB each, and totally ...
0
votes
0answers
67 views

How to switch MBR to GPT without losing any existed data originally in MBR, AWS Ubuntu EC2

I'm trying to extend my diskspace for my AWS EC2 Ubuntu instance, the partition I've started with is MBR and the maximum it can go is 2TB. Currently the diskspace is full with important data, I need ...
1
vote
1answer
134 views

Understanding BinLogDiskUsage Metric behavior

We are using AWS-RDS. The following is the screenshot of how the binary log disk usage has varied over the last 6 weeks. The log retention period is 3 days. Tables are optimized and archived once a ...
4
votes
1answer
94 views

Huge Heap Table and table compression on SQL Server 2016

My database size is huge, and recently I noticed that a new table added few months ago is the culprit. Here is the table script. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]....
1
vote
0answers
19 views

Transactional Replication and distribution database size

I have a transactional replication set up with initialize from backup. In the secondary database server,i have a drive(d:) for data files alone. I have noticed that this drive is getting filled and i ...
-1
votes
1answer
190 views

Reducing .mdf file size

I have a drive, :d, in my server where I have my .mdf file stored and now all of a sudden I notice that the drive :d has no space left. When I checked the .mdf file of the database demo1, it is 1.6TB ...
1
vote
1answer
71 views

SQL Server shrink log after full and log backup

I have an SQL Server database in Full recovery model. The data file is just 1 GB in size, but the log file is 20 GB. I have a space problem, so I took a full backup and then a log backup with ...
0
votes
1answer
166 views

Which PgBackRest policy for differential backups in PostgreSQL

I set up pgBackRest and PostgreSQL configuration in two different servers. I set up with crontab one full backup a week and one differential backup a day. 0 1 * * 0 pgbackrest --type=...
0
votes
2answers
71 views

Does adding a postgres index concurrently take up disk space gradually or all at once?

I'm adding a unique index (concurrently, over the course of hours or maybe even days, on a column of 5 billion bigints, all of them NULL) on a Postgres 9.6 server that's pretty low on disk space. I ...
0
votes
1answer
290 views

Checking space availability before a VACUUM FULL (postgres)

Is it possible to check how much re-usable space is available in a tablespace before running a VACUUM FULL on a large table? I have a large postgres table (about 20G) that gets an occasional VACUUM ...
0
votes
1answer
18 views

During table migration of tables from one tablespace to another, does it needs free space to do the alter table move?

During migration of tables from one tablespace to another (all datafiles in the same disk/partition/mount), does it needs free space to do the alter table move? exemple:. I have 30gb of free space on ...
0
votes
2answers
47 views

Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)

I've been trying to search for this info on oracle documents but they just don't talk about it. I need to move about 2TB of different tables from 3 different tablespaces to a new tablespace (...
0
votes
0answers
87 views

How to manage Oracle diagnostics logs not managed by adrci?

How can I identify Oracle log files that are not managed by adrci? I wish to manage disk space usage, in a similar scenario to this article: "How to free up disk space? which logs/directories to ...
0
votes
0answers
107 views

Always on availability group database not truncating log files and keeps growing

We have 4 node replica, 2 nodes in synchronous mode, and 2 nodes in asynchronous mode. Log backups are happening every 15 minutes. The application just went live yesterday and one thing does not look ...
-3
votes
1answer
131 views

PRODUCTION DATABASE RUNNING OUT OF SPACE [closed]

My database has 9556.97MB of space left. I do have about 2TB free disk space. The database is in full recovery mode and doing full backup everyday, also TLOG backup every 24 minutes. I used to just ...
5
votes
2answers
515 views

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

If I size my log files to evenly split the entire drive they reside on, leaving no extra space available, will log backups still be able to occur successfully? I have several databases, with one log ...
1
vote
0answers
70 views

Why is my InnoDB table size so much larger than the data?

I have a MySQL table (version 8.0.13). One table is unreasonably large and doesn't correspond to the current data. I rebuilt the table by running ALTER TABLE users FORCE and OPTIMIZE TABLE users, but ...
0
votes
0answers
174 views

Mongoexport and mongodump disk usage rationale

I just had an interesting experience with the mongoexport tool and came out with a doubt about the exporting process' disk usage. I was trying to dump a 50 MB collection to a disk that had 3 GB free ...
-1
votes
1answer
122 views

Database volume completely full

/dev/mapper/pgdatavg-base 138304552 131262788 16384 100% /var/lib/pgsql/data/base pg_xlog is on a separate volume, and it's got plenty of space. [postgres@fpslbxmbstgl05 ...
1
vote
0answers
53 views

One of the mongo shards consuming too much disk space.

We have mongo cluster with 10 shards of each having 3 replicas. Recently we are facing an issue, exceptionally in a couple of shards, the disk space among all the 3 replicas has reached above 90%. ...
2
votes
1answer
357 views

Mongodb replica set primary and secondary node conf fail when one slave is down

In my env, I had created MongoDB replica set conf for high availability so one server fails should be handled by other also in my conf I have 3 DB server and 1 arbiter too but, my slave's server ...
0
votes
1answer
52 views

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

Long story short. I have a table with more than 10millions rows with a datetime field. WE can change that to DATE ( because date uses 3bytes, and datetime 8). I thought if I: alter table table1 ...
2
votes
2answers
89 views

Upgrade in-place with low disk space on C: drive

I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade. It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
1
vote
1answer
68 views

Why does this tsvector update use so much space?

This is my table structure: Column | Type | Collation | Nullable | Default | Storage | Stats target | Description -------------+---------------...
1
vote
1answer
42 views

Use T-SQL to return free space on a network share

I'd like to be able to calculate the amount of free space I have for offsite backups so I can prevent any jobs from running should there not be the relevant space and also be able to send alerts when ...
-2
votes
2answers
2k views

How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]

Is there an ability to query below system specifications using t-sql ? 1. cpu (show number of processors / cores / frequency) 2. memory (show total amount of RAM on a machine; show allocated RAM; ...
2
votes
3answers
341 views

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?

I have a database whose initial size is set to 1000 GB. Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
0
votes
2answers
583 views

Impact on database while increasing database initial size

I have a database whose initial size is 900 GB for .mdf file and 13 GB for log file, I want to increase its initial size to + 100 GB , while doing that in the properties -> filegroup->initial size, do ...