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 [database-size]

The tag has no usage guidance.

1
vote
0answers
85 views

AWS RDS postrgres massive disk use, small tables

I can't figure out why our AWS postgres server has consumed all of it's space. We just had to up the storage space allocated to it, but can't find any hint from postgres that it's using that much ...
1
vote
0answers
27 views

Dump limit in PostgreSQL

I am trying to dump a database which has a size of just over 100 GiB. I am using the following command (with pv to give a progress bar to observe where this problem occurs): pg_dump -h <host> -...
3
votes
1answer
81 views

How large is SQLites minimum data storage overhead and what generates them?

Motivation: In my company there exists the (probably strange) idea to store pure time series data in a normal SQL table (instead of using BLOBs or just binary files which would probably be a better ...
2
votes
0answers
131 views

Why the disparity between Filestream size and Container folder size?

I have an issue with one of my SQL Server 2014 databases. It appears to me that the Filestream size is significantly larger than the actual Filestream container folder size? ~360Mb larger. The ...
1
vote
2answers
135 views

Database Space Used Decreased after Index Rebuild (Ola Script)

I have rebuilt some indexes which were highly fragmented. After the index rebuild I am seeing my database space used reduced by almost 50% (from 77gb to 33 gb) Is that normal behavior? I dont have ...
0
votes
0answers
57 views

iOS SMS.db - limits of vacuuming

Considering this is an sql question, I thought I'd have more luck here rather than in the Apple section. A bit of background: iOS SMS.db is a sqlite db that, as the name suggests, holds messages (SMS ...
2
votes
1answer
102 views

When is autoclose OK to be not OK

By chance, I happened to see that the autoclose feature on SQL dbs (I'm using SQL 2008) shouldn't be on and I found that all of my SQL dbs were set to have autoclose on. I've set autoclose to off on ...
1
vote
2answers
100 views

Postgres 10.3 : table grows in size after delete-insert

I'm a rather new to Postgres and the issue I see seems a bit strange. Maybe you as experts know something about it. I have a table (around 3 million rows and 200 columns). In order to populate fresh ...
2
votes
2answers
78 views

The table is full when insert records by php program (around 15m)

Error: INSERT INTO tbl_xxxxxx ( .........); The table 'tbl_invoice_detail_lesson' is full I have checked lots of article, most of them are noticed that it has to change the ...
0
votes
1answer
46 views

Shrinking a massive database file

I have a client with a 2 TB database for a pension company. The database contains a lot of big documents. They want to archive everything that's not from this year. So far no problem - I'll just do a ...
0
votes
3answers
647 views

How do we determine data_length + index_length as database size in mysql

I am calculating my innodb databases size with the following syntax. SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema....
1
vote
1answer
55 views

How to know exactly when my Database / Log files grew?

Is there a way to see when (history / log records) of .mdf / .ldf files grew? Ultimately, is it possible to setup alerting and know immediately when my database / log files grow?
0
votes
0answers
27 views

Storing a lot of text / string data strategies - analysis and solution

I have a LOB application backed by SQL Server 2016. Over the past few weeks, theres been issues whereby the SQL Server start throwing timeout errors - which has led to a bit more digging into the ...
-1
votes
1answer
45 views

SQL Server : refactor schema to avoid repetition

I have an enormous prod SQL Server database : total size = 1.5 TB full backup duration = 4 hrs ( online ) that needs to be slimmed-down because it's causing a variety of issues for database ...
0
votes
1answer
29 views

Check database size in previous day

I want to ask how do I get database size in previous day (example: Today is January 31st, and I want to get database size in January 22nd). Note: I do not have regular backups. I have tried this ...
2
votes
0answers
299 views

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)

sp_spaceused, when executed without any parameters, produces 2 result sets database_name, database_size, unallocated_size reserved, data, index_space, unused Usually when you execute some SP, you ...
3
votes
1answer
257 views

Why is my database 12 times bigger than inserted data?

I have a short question concerning my database size. I need to insert data in a database. Before the insert, some calculations need to be done. The point is: from 50 mb plain data (~700,000 lines), ...
0
votes
1answer
39 views

Table and Primary Key sizes in Oracle

I am analyzing the size of some tables in Oracle, and I noticed that the primary key occupies almost the same size of its related table. To be clear, my statistics are the following (approx.): NAME ...
1
vote
0answers
29 views

How to handle large sized oracle databases in a windows server

My Production database is having 188 GB size. The server handling the db is having C Drive with a space of 250 GB. My database is growing rapidly.I don't think this database is having much size ...
0
votes
1answer
117 views

Can I Compress a huge table on SQL? [closed]

On my production SQL Server Enterprise Edition database 2014, I am trying to find why data files (.mdf) growing day by day. I get the following report From Management Studio: right click on the ...
6
votes
2answers
2k views

How to free the unused space for a table

This question is asked like tens of times, and to my surprise such a simple requirement comes so difficult. Yet I can't solve this problem. I use SQL Server 2014 Express edition with 10GB limit of ...
1
vote
1answer
25 views

Dumping data from website's Database

I'm looking for ways to browse and dump the database of a particular content from the website. To be more specific i am collecting the database of the Skills designed for the device amazon alexa. Is ...
2
votes
2answers
160 views

suddedenly increased in size of Log files form 32GB to 70 GB [duplicate]

I am not DBA ,but I need to check on the size of database files . my database log files earlier was around 32 GB but from last few days it starts increasing and finally reached to 70 GB . first I ...
4
votes
1answer
2k views

what are the possible reasons for 'Arithmetic overflow error converting expression to data type int' in SQL server

When this command is run, there is SQL server error 'Arithmetic overflow error converting expression to data type int'. SELECT sum(size) FROM [dbname]..sysfiles sf, [dbname]..sysfilegroups sfg ...
2
votes
2answers
22 views

Manually Grow DBs in an Availability Group

When you manually grow a data file on the primary replica in an Availability Group, which of the following happens? The operation gets synced to the other secondary replicas. I have to manually grow ...
4
votes
2answers
7k views

Table has 14 GB in unused space - How to shrink table size

I use the following script to gather data from my database wich is SQL Server on Azure. -- Script to run against database to gather metrics CREATE TABLE #SpaceUsed (name sysname,rows bigint,reserved ...
5
votes
1answer
779 views

What would be the maximum number of records that can be indexed with a three levels B-tree ? B+ tree?

I am learning dynamic tree-structure organizations and how to design databases. Consider a DBMS with the following characteristics : file pages with size 2048 bytes pointers of 12 bytes page header ...
-2
votes
1answer
78 views

Is it possible to know which Columns are taking more disk space in a table?

I have a huge table with 3 million records and the table size is 900 MB approximately. I want to know which column I can delete to save more space. I want to know the disk space each column is ...
4
votes
3answers
2k views

Releasing free space in mdf file to OS [duplicate]

We have a 120GB database. There was table with 60GB of data which is useless and we have truncated it. Now database size is 120GB with free space 60GB. The database will not grow up to 60GB in at ...
-3
votes
1answer
386 views

Reduce size of SQL Server database [closed]

How can I reduce my SQL Server 2008 database size? My application is slow as as a result of increasing db volume.
0
votes
1answer
373 views

Postgresql size of Slave is bigger than Master size

I have a Postgresql in master slave streaming replication. Master is located in four partitions (tablespaces). df -h on Master shows me Filesystem Size Used Avail Use% Mounted on *** /dev/...
0
votes
1answer
26 views

Database size and cycle

I am developing a desktop application and it will include clients, bills, banks, incomes&outgoings etc, I am using mysql and delphi, My question is do i have to cycle (create new tables and ...
3
votes
1answer
3k views

Pages to MB, multiple and divide or just divide?

When you are using things like sys.database_files it gives size of the file, in 8-KB pages, while many other things you are comparing to it to are in MB. There are a number of ways to convert the 8-...
1
vote
1answer
82 views

Production database substantially bigger than Dev

I have a Production database and a Development database on two different servers. Both databases are being fed from the same data warehouse on a staging server. There are a series of automated SQL ...
4
votes
1answer
405 views

SQL Server DB table data size query result not increasing if data count increasing

I have a query which will show the Table Name, Number of Rows and Size of the record of a Database tables in SQL Server. when I executed the query I got a result showing TableName ...
1
vote
1answer
520 views

How to keep database size low in MongoDB?

Newbie here. TL;DR : What is the best way to compact data in MongoDB? Will it use much more space than other database systems? I wanted to create a database for something more or less like a forum. ...
0
votes
0answers
328 views

Is a 200gb table with 1.2 billion rows too large for AWS?

I'm currently designing a backend for a game I'm making, and one of the tables (the largest one, by far) will end up being about 200gb of disk space and around 1.2 billion rows. I plan on hosting my ...
3
votes
2answers
102 views

SQL Server Database size unchanged after dropping File column

I have a database with a table that has about 10 000 records. One of the columns in this table is a VARBINERY(MAX) that is used to store images. A backup of this database is about 1.2GB. It's size as ...
0
votes
1answer
64 views

Difference in size of table between InnoDB and MEMORY engines

Question The same table stored on hard drive (InnoDB engine) takes 930.72 MB when in Ram (MEMORY engine) it takes 1538.54 MB. For what reason? How to calculate space needed to save data in memory? ...
0
votes
1answer
52 views

Size of an “empty” PRIMARY filegroup

I have a question for you concerning the PRIMARY filegroup. Out goal is to have a small PRIMARY, so that we can do partial restores to other systems (test, dev) So, we moved all tables and indexed ...
0
votes
1answer
114 views

What should I do with this large database filling up the disk?

I have a SQL Server 2008 R2 Standard Edition warehouse database of around 400GB and face daily hard disk full issues. I've checked table sizes and row counts. Below is an image of what I've got: What ...
1
vote
1answer
120 views

Microsoft Links for SQL Capacity planning

I went through this website because we have migrations coming up pretty soon for Landesk Management Suite. We are planning to move to SQL 2014 but the site's contents are mostly relavent to SQL 2005. ...
0
votes
1answer
37 views

What happens as a database grows to the HDD's lmit?

I'm running a PostgreSQL database and from what I read, the database is unlimited in size. Is there any material I can read to understand what occurs when the HDD fills to capacity? What sort of ...
3
votes
1answer
4k views

Querying True Physical Database File Sizes

On querying database file sizes... 1) Most if not all of these answers do not always match the physical file size shown in file explorer: https://stackoverflow.com/questions/5945360 The accepted ...
1
vote
0answers
754 views

SQL Server 2014 Express database size limitation exceeded, suddenly cannot be exceeded anymore?

I have a database in SQL Server 2012 Express. I inserted 14 million rows to test index performance and everything was working fine. The database's PRIMARY file group was at over 21 GB. I had ...
5
votes
3answers
10k views

what is causing arithmetic overflow in the query below?

when I run the following query on MY_Database select * from sys.sysfiles I get the following results: But when I run a dynamic query that gets the percent of free space I get: Msg 8115, Level ...
2
votes
2answers
1k views

Shrinking sql databases - bad idea? [duplicate]

I have a database, that due to some silly code issues has grown hugely. It is now sitting at 24GB, most of it is very unnecessary logging information (system generated debug information). My server ...
0
votes
1answer
2k views

mongodb compact does nothing - no entry in mongodb.log and nothing in db.currentOp()

We have space problems. The actual data size is only 5 GB, but disk size is 15 GB because of deleted documents. MongoDB (3.0.6) runs in docker container where we can't extend volume. # tail -f mongod....
1
vote
1answer
231 views

How big is my oracle database?

I need to determine the total size of an oracle database. Ideas on improving the following query? SELECT 'DataFiles: ' AS TYPE, SUM (bytes / 1024 / 1024) AS MB FROM dba_data_files UNION SELECT '...
0
votes
1answer
160 views

PostgreSQL values to unique dictionary

I have table with one billion rows and more than 50 columns. I need to reduce size and speed up queries, backup, exports, etc. Some columns contain f.e. only hundreds of distinct values which are long ...