Questions tagged [disk-space]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
40 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
1answer
8 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
85 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 ...
4
votes
1answer
463 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
53 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
26 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
34 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
20 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
19 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
54 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
85 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
16 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
118 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
65 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 ...
1
vote
1answer
53 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
50 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
106 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
15 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
43 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
70 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
65 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 ...
-4
votes
1answer
92 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
508 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
46 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
146 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
86 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
51 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
289 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
82 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
50 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
39 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
1k 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
262 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
346 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 ...
0
votes
1answer
289 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
0
votes
2answers
48 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
1
vote
1answer
134 views

Is there any string compaction option for PostgreSQL?

I have a table like this: CREATE TABLE BLOG( CATEGORY CHAR(32) ); Category is a column, which stored enum values. For example, I have 1 millions of rows and 10 unique values of Category. Let'...
-1
votes
1answer
316 views

Allocation of disk space to new created databases in production [closed]

Our current production database has total disk space of 2 TB. (SQL Serve 2012 standard RTM version.) Currently we have database size allocation as attached. Apart from FUNDSDB and DBAdmin, remaining ...
0
votes
1answer
126 views

Autogrowth Analysis in PROD DB based on the trace file data

I have used the below query to check our Production Database Autogrowth events so that we can set to a value which is much more realistic than the current value of 200 mb , unrestricted for mdf file ...
1
vote
2answers
692 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
2
votes
1answer
362 views

Implementing disk quota for MariaDB

I want my Linux MariaDB database to have disk quota implemented. How can I achieve this these days? I have found some tools but they are for MySQL, don't know if they are supposed to work on ...
2
votes
1answer
64 views

Where in the database file is an index rebuild started? Alternative to SHRINKFILE?

When rebuilding an index in SQL server, where in the datafile does it put that data? Does it start at the beginning of free space and fill in the gaps from there? Context: I have some large .ndf ...
1
vote
1answer
37 views

Guideline for MySQL free space

What is the guideline for how much free space to keep available on a MySQL AWS RDS instance (SSD)? In the past for an on-premises SQL Server install we used to use something like 2x the largest table ...
2
votes
1answer
84 views

Disk Architecture on SQL Server [closed]

I am building a new environment using the SQL Server 2017 Always-On system. This will be active 24/7 and there will be lots of DML processes. I have a 100GB SAS for the OS, a 1TB SAS for Data and a ...
0
votes
0answers
81 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
0
votes
1answer
298 views

Reduced copy of zabbix database

I've a relatively big postgresql database that tooks a lot of space in a server. The database stores a zabbix system used to monitor data that I've to safely keep, so history tables are quite big. My ...
1
vote
1answer
72 views

Not find the table of the oid

I have a database running under PostgreSQL which normally has to have a size of 300 GB. Unfortunately it is now 3,5 TB in size. I noticed that the directory of this database , the pgdata path is /...
7
votes
2answers
5k views

what is the best practice for tempdb autogrowth?

I have a client's server with about 15 databases on this instance with a data total of about 100 GB. One of the databases is for a sysaid app. his temp db files are one mdf one ndf and of course an ...
11
votes
2answers
4k views

If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?

I have several versions of SQL Server, used for testing, installed on my laptop (2012, 2014, 2016, and 2017). I noticed the other day that there was a folder containing prior versions of files across ...