The disk-space tag has no wiki summary.
1
vote
0answers
60 views
SQL Server 2005 Unexpected Disk Usage during Backups [closed]
On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and ...
2
votes
2answers
66 views
View Disc Usage
Is this statement correct?
Behind the scenes SQL Server actually stores the data in the view as a
physical table which must be updated if any of the data behind the
view changes
I did some ...
1
vote
1answer
105 views
Is there a tuning parameter for MySQL that allows you to set an on-disk gap between non-sequential primary keys?
I understand that one of the primary issues with using a non-sequential primary key is that every disk/memory write that does not come after the last known key causes a re-write of everything from the ...
2
votes
0answers
150 views
How much disk space needed for 100GB of DBs?
Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery ...
1
vote
2answers
165 views
Should a SQL Server TempDB space be allowed to be reclaimed?
If I don't have space concerns at the moment, should I size my TempDB as a large space initially and not let it's space be reclaimed?
What's the best way determine what the optimal initial size for ...
4
votes
1answer
229 views
Safe way to truncate SQL Server Error Log
We are running out of space. What is the safe way to clear the error log?
2
votes
2answers
328 views
Get disk space percentage free with SQL Server 2005?
I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring.
However, this only gives me an absolute ...
1
vote
3answers
1k views
T-SQL query to report disk space allocation and used space for auto-grow SAN databases
We are using 6 databases in total for an application, and we can only share 4TB of space for all 6 databases (via SAN storage). I'd like to write a query (report) for a single database indicating the ...
1
vote
1answer
154 views
Disk space recovery on Mongodb replicaset secondaries
Is it possible to recover disk space on replica set secondaries based on the results of a repairDatabase call performed on a primary? I can't seem to locate anything that would work short of bringing ...
1
vote
1answer
148 views
Diskspace usage of DB
I have a production database that's consuming a significant amount more disk space than it should be.
Using sp_spaceused (only the interesting tables), I get.
Table Name Reserved (KBs) Data ...
1
vote
1answer
132 views
Imports & exports under storage constraints and preallocations
I have a 5GB oracle database that I want to export and then import on my own local database. Easy right?
The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
3
votes
2answers
5k views
How do I shrink the innodb file ibdata1 without dumping all databases?
InnoDB stores all tables in one big file ibdata1.
After dropping a big table, the file is keeping its size no matter how big the table was.
How can I shrink that file without having to dump and ...
1
vote
1answer
161 views
Why is SQLite adding unused disk space to “free-list” after deleting a lot of data in a database?
The SQLite FAQ states the following:
(12) I deleted a lot of data but the database file did not get any
smaller. Is this a bug?
No. When you delete information from an SQLite database, the ...
6
votes
3answers
1k 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 ...
2
votes
1answer
895 views
How do we free up disk space from allocated namespace? / ORA-03297
We are running out of disk space.
The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g).
The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
