Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [disk-space]

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

-1
votes
1answer
26 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
12 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
70 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
49 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
60 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
30 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
37 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
415 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
121 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
99 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
152 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
46 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
70 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
100 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
102 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 ...
0
votes
2answers
143 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
180 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
57 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
35 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
74 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
39 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
200 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
45 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 /...
6
votes
1answer
2k 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 ...
0
votes
0answers
94 views

MySql tables use 3GB, but disk usage is 40GB

I have a 48GB Linode machine. The ONLY thing this machine runs is docker with the standard mysql:8.0.3 docker image. Looking in information_schema.TABLES I can see I use in total 2.8GB. However, when ...
0
votes
1answer
67 views

Back Up - Free Drive Space

Is there a way to know the free disk space available on the drive that the back up file will be created? For example, SQL Server is installed in Server 1 and the back up file is scheduled to be ...
0
votes
2answers
911 views

SQL Server 2016 out of disk space

I'm running SQL Server 2016. I have a database that has run, apparently, out of space on the D: drive. The daily index rebuild started producing the error shown below. Msg 1101, Level 17, State 12, ...
1
vote
1answer
75 views

Decrease size of database (with an expression index)?

This is my current table definition in a Postgres 10.1-1 database: CREATE TYPE CUSTOMER_TYPE AS ENUM ('enum1', 'enum2', 'enum3', '...', 'enum15'); -- max length of enum names ~15 CREATE TABLE ...
0
votes
2answers
289 views

Purging Binary Logs from Master in a Replication Environment

Replication Set up 6 Masters and their respective Slave. All 6 slaves writing to a Master - which has its own Slave. Now, I want to purge binary logs on the 6 original masters and set expiry to 15 ...
10
votes
2answers
2k views

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

In our environment the network storage is low on space. At the same time I would like to make sure that we take transaction log backups every 15 minutes instead of current every 6 hours. My question ...
2
votes
3answers
139 views

Why does my DELETE command require huge amount of temporary run storage?

I am trying to perform a cleanup operation on a table using DELETE and I receive the following error: Could not allocate space for object 'dbo.SORT temporary run storage: 140767697436672' in ...
1
vote
1answer
220 views

How to reclaim unused space from clustered index table

I have a clustered index table with more than 11,000,000 records running on SQL Server 2008 R2 Standard Edition. I have noticed the table has about 90 GB of free space. This is the table definition: ...
0
votes
1answer
492 views

Freeing unallocated space

I have a server that the database drive is running out of space. i have deleted some of the old log data and historical data to try and free up the space.what is the best way to free allocated space ...
2
votes
1answer
69 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
1answer
432 views

How to Determine Optimal Disk Cluster Size for Firebird 2.5

I'm using Firebird 2.5.6 Classic Server on a Windows 7 64-bit machine. We're moving the database to a separate disk (32GB NTFS Volume) and are now provisioning that disk. My question is, what should ...
5
votes
0answers
848 views

VARCHAR(MAX) taking more space than NVARCHAR(MAX) [duplicate]

I have a table in SQL Server 2012 Enterprise Edition that has ~100GB of data. Most of this data is attributed to a single NVARCHAR(MAX) column which has an average length of 4500 characters. It stores ...
0
votes
0answers
42 views

Master binlog has stopped

Couple of days ago all of my slaves weren't able to sync data from the master. After searching deeply, Here is my findings: 1- Seconds_Behind_Master= NULL. All the slaves. 2- The error was 'binlog ...
3
votes
1answer
422 views

How does SQL Server reuse reserved pages after deleting a table

I just want to know: How SQL Server reuses reserved space after dropping a 1GB table? (call the table T1) How SQL Server reuses reserved space after truncating a table? (call this table T2) Both are ...
0
votes
1answer
117 views

Creating indexes vs Rebuilding indexes (larger db/log file)

I am a bit lost on what it the right way to do this. I am migrating data from one db to another (corrupt errors) so i did the following: Create a new blank db Generate a object script from my source ...
1
vote
1answer
906 views

How to reclaim database space on Azure SQL Server after setting nvarchar values to null [duplicate]

There is db space challenge at hand on Azure SQL Server database. 490 GB out of 500 GB is used. That's what I read from nice pie chart on Azure portal. Notice that some of the techniques used on-prem ...
-2
votes
1answer
61 views

Disk space problem regarding MongoDB [closed]

I have 12 servers in which there are 4 replicas. The architecture of the mongo servers and the disk spaces are present like: 1st replica s1-rep1 - 287GB s1-rep2 - 0GB s1-rep3 - 0GB 2nd replica ...
2
votes
1answer
2k views

Does InnoDB ever release unused disk space?

A large MySQL association table with 500M rows recently ballooned into 1B rows due to a bug (now fixed). Disk usage went from ~130GB to 240GB. Unfortunately there is not room on this server for any ...
5
votes
2answers
342 views

1000 MB vs. 1024 MB

Is there any authoritative documentation regarding whether 1 GB = 1000 MB or 1024 MB in reference to 1 ) disk space and / or 2) RAM? Based on my research the "official" breakdown of 1 GB used to be ...
0
votes
1answer
104 views

Optimal data type for storing numbers in SQL Server [closed]

Similar to varchar that stores strings of varying length, is there an alternative for numbers of varying length that allocates space depending on the size of the number? I have a large table with 50 ...
0
votes
0answers
35 views

Compute bytes count occupied by surviving cells of a table [closed]

Let there be a table that grows to 5MiB. After being VACUUMed let there be about 2MiB worth of DELETEd rows that is available for data in that table before starting storage claims to the operating ...
1
vote
0answers
138 views

Disk space for non-persisted In-Memory tables

I have a database on a SQL Server 2014 SP2, CU5 Enterprise edition. The database has a memory optimized filegroup. There are two tables in it, both are set to DURABILITY = SCHEMA_ONLY and have a low ...
4
votes
3answers
972 views

How to free up disk space to the OS, ideally without using SHRINKFILE?

Our server admin is asking me to free up disk space on our SQL server, since the drive where the SQL datafiles reside is at 97% usage. I have found a table that has grown out of control. It now ...
8
votes
1answer
430 views

Best way to shrink a DB after nulling data from varbinary(max)?

We have a database with a large amount of data stored in a field of type varbinary(max). At some point we can purge that data for most rows, but not all. Our plan is to make that field nullable, and ...
2
votes
2answers
447 views

Reclaim disk space from large database's primary filegroup after truncating tables (other than shrink)

We have an 8 TB SQL Server 2014 SP1 database, with one primary filegroup, spread across multiple files on different drives. This is part of an AlwaysOn AG with multiple secondaries (some async). One ...
5
votes
1answer
134 views

Extracted data WAY bigger than deficit left from deleted rows

I recently undertook an exercise to free some space up in a production DB (SQL Server 2008 R2) due to disk constraints. Just one table in particular takes up 98% of the DB. Records that were not ...