The size tag has no wiki summary.
0
votes
1answer
31 views
Database size not reduced after compressing tables
Using Data Compression, my table size was reduced from 1770 MB to 250 MB, but the database size was not reduced. Why?
2
votes
2answers
74 views
Why doesn't DELETE + REORG free diskspace (DB2)?
In DB2 I have a table containing large binary data. Now i purged the whole table and ran runstats, reorg, runstats, but the amount of disk space taken does not change. What could be wrong here?
The ...
0
votes
2answers
70 views
How to influence Oracle backup output size?
I have two environment one Prod one Dev. Dev is created by Prod data and both have a similar database size. However, the backup output size varies greatly. Prod is about 300 M while Dev always above ...
1
vote
1answer
88 views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
0
votes
1answer
107 views
SQL Server Table keeps big after schema change
I have a table in SQL Server 2012 with 460.000 rows.
This Table has the following Schema:
We had an issue with our application so all 500.000 rows were created with Comments filled up with spaces.
...
6
votes
3answers
2k views
Measure the size of a PostgreSQL table row
I have a PostgreSQL table. select * is very slow whereas select id is nice and quick. I think it may be that the size of the row is very large and it's taking a while to transport, or it may be some ...
3
votes
2answers
131 views
Heap size too large for data present
A SQL Server 2008 R2 Standard Edition database has a staging table with no indexes, eight varchar(50) and one varchar(255) columns, and 162,676 rows. I'd expect that this table shouldn't be much over ...
2
votes
2answers
135 views
Access 2000 database rapid growth
We have an Access 2000 format database running in Office Access 2003.
We have a problem with the size when I merge the database; the size is about 250 MB. Two days later, the size has ballooned to ...
2
votes
2answers
828 views
SQL Server 2008 R2 Express size
I have what I believe is SQL Server 2008 R2 Express installed on a production server. When I connect to it with SQL Server Management Studio it shows up as SQL Server 10.50.1600.
If it is in fact SQL ...
1
vote
3answers
222 views
Big size of database logs SQL Server 2008
I have a database which is running under Microsoft SQL Server 2008. Now, I have seen that the log of the database (the .ldf file) is growing to big size. The database file (.mdf) has a size of 630MB ...
4
votes
3answers
559 views
Recalculate row size in SQL Server 2008?
It is possible to recalculate row size in SQL Server 2008? Take this example:
declare @counter int
declare @statement nvarchar(max)
set @counter=0
drop table kua2
create table kua2(id int)
while ...
2
votes
1answer
157 views
'packet too large' error with packet smaller than max_allowed_packet
Some time ago we started storing serialized data in our MySQL database and immediately ran into the well known 'packet too large' error. We increased max_allowed_packet to 64M and all was well.
This ...
0
votes
1answer
333 views
How to manage a large SQL Server database: transaction log, reduce size, alter table
Hello I have some confusion on how to manage a large SQL Server database.
Let's say size is 15GB, with 3GB available, in simple recovery mode.
Server is not managed by me, I cannot change the size, ...
4
votes
3answers
229 views
SQL Server Table Size Discrepancy
Hopefully this has a simple answer and I've missed something obvious. I have a table where the number of rows * the row size is much smaller then the actual data space used by the table.
If I run the ...
3
votes
3answers
589 views
SQL Database size doesn't match with the total table sizes in the database
I have a database that is size about 104GB.
When I calculate the total table sizes in the database it's only about 24GB. This includes Data+index+unused spaces.
Why the DB size is too large?
2
votes
2answers
1k views
Different MySQL Datafile Sizes After Restoration
I'm quite new in database administration. The database architecture of my current company is master-slave replication. We are using MySQL version 5.0.86.
Some weeks ago, we upgraded the company's ...
1
vote
2answers
1k views
Print database_size from sp_spaceused
Using SQL Server 2008, I have found that the database size can be obtained using
exec sp_spaceused
This procedure returns two tables:
database_name | database_size | unallocated space
reserved | ...
3
votes
1answer
674 views
Estimating impact of indexes SQLite database size
I'm trying to estimate the database size (on disk) for a SQLite DB that includes a number of indexed columns. These columns are of (SQLite) type Integer and String. It's straightforward enough to ...
1
vote
2answers
442 views
Sizing MySQL Database Servers for Drupal
What are some guidelines to follow when it comes to sizing MySQL Servers? CPUs, RAM, Disk Space, Clock Speeds, etc?
We're going to go with either the community edition or the enterprise edition, and ...
4
votes
1answer
286 views
PostgreSQL relation size does not sum up
I have a very large table, with blob fields, called data. I've tried to figure out why it isn't cached well and repeated SELECTs are quite slow:
=> SELECT ...
