The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
5answers
473 views

Is it impossible to store 2^266 records on a database of some kind? [closed]

Each records weighs 52 bytes, is it possible in today's technology if someone had the storage needed? What kind of db would hold the data and will make it possible to retrieve it. An example record: ...
0
votes
0answers
25 views

How to Upgrade from Oracle 10G to Oracle 11G without bringing down the database

I have an Oracle 10G database running on two machines in a resilient environment with shared storage. So when one of our system fails we simply switch the GSS to second database instance. Now I need ...
0
votes
0answers
27 views

Need an advice on how store some statistics details of a master entry in a MySQL DB

I need an advice on how to store this statistics data: I have a master table which stores some institutional infos of some cities in several years and a detail table which should contain a detailed ...
3
votes
1answer
42 views

Use of integer instead of interval (of one type)

Our DB design presently has a interval column which will only be storing days (no other interval type) so it is making sense to use INT2 (smallint) instead of interval. Reference to documentation. ...
1
vote
0answers
53 views

SQL Server 2012 Database Engine Configuration Storage type Raid

I just inherited a Server that I have to rebuild for SQL Server 2012, I was wondering what would be the best disk configuration for the database engine. This is what I have: 6 x 300GB 10k: 2 x 1TB ...
0
votes
1answer
54 views

SQL Server storage limits on Azure

Looking at SQL Server maximum capacity limits on here: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx Database size can be as big as 524,272 terabytes. Here, you could see VM size ...
0
votes
1answer
56 views

I have delete database from mysql but storage is not freed

I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage? I have a mysql database that the total ...
0
votes
1answer
65 views

ERP (Oracle) real time backup [closed]

I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so ...
1
vote
0answers
27 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
2
votes
0answers
57 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on ...
1
vote
2answers
87 views

Independent pairs of RAID 1 is superior to RAID 10 [closed]

I am rather new to databases. I was reading up on RAID Storage and it seems that the consensus is that RAID 10 is RAID 10 is best is terms of performance and redundancy However at the end ...
0
votes
1answer
95 views

What are the low-level storage requirements? [closed]

Typically, DB engine fulfils some request and any modifications must stay persistent (you call it durability). How is the persistence is ensured/assumed? Which requirements are imposed on the HW/OS? ...
2
votes
1answer
102 views

SQL Server data files and RAID

I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 volume has 6 physical disks. Should I split the SQL Server database into 6 datafiles (one for each physical ...
0
votes
1answer
40 views

Allocating Filegroups and Storage

I have upto 10 databases running on a single SQL Server instance on a single server. I have read about best practice for storage and concluded the following... 1) Transaction Log on own RAID array ...
0
votes
3answers
72 views

SQL Server RAID Storage [closed]

I have been reading about recommended SQL Server storage and RAID 5 or RAID 10 controllers have been recommended. On my existing Database server I can see 4 Storage controllers under Device Manager. ...
0
votes
2answers
105 views

What is the default size of text field in Postgres?

In the official documentation (http://www.postgresql.org/docs/9.1/static/datatype-character.html), it states text field is variable unlimited length. I wonder what is the default size of this field ...
1
vote
4answers
152 views

What is a Scalable Storage Mechanism for large TTL data collections

We currently have a legacy webservice that stores each xml request/response in Sql Server. The data only needs to persist for 3 days before it is considered expired. Sql Server is not good at deleting ...
1
vote
2answers
107 views

Single disk for Data, System, User, Temp and Backup when installing Fail Over Cluster?

I have a Windows cluster with two nodes. I am trying to make Fail Over Cluster using SQL Server 2012. On both nodes there is 2 TB storage available which I can access as: ...
3
votes
1answer
88 views

Help with Cybernetics SAN Configuration

There are tons of articles out there recommending RAID/ LUN/ drive configurations for SQL Servers, but most leave me still questioning as they usually state "it depends" and for this reason I'd like ...
1
vote
1answer
138 views

Need a solution to store cheaply a big MongoDB collection

We have the typical problem of Twitter's timeline tweets, or Facebook profile's news: we need to show the users only the new information (storing them in a fast db), and put all the old ones somewhere ...
0
votes
1answer
154 views

Help with Postgres 9.1 data import (is 4x expected data size, 4x slower than MySQL, and index still needed)

I have 25 billion <int, int, float> rows that I'm trying to import into Postgres, and after 77% of the data being imported, the Postgres data folder is taking up 840GB, about 4x the storage ...
2
votes
1answer
70 views

Meaning of SQLIO output “counts per second”

I realise that my question isn't strictly 'database' but I know that a lot of DBA's will use the SQLIO tool to check I/O performance on their systems so I'm hoping that somebody here will be able to ...
2
votes
0answers
128 views

always on availability group with different speed disks

I'm looking to set up SQL Server 2012 installation with an Always On Availability Group, where the 'passive' replica will be hosted at another site on the WAN and using synchronous data commit - the ...
0
votes
1answer
99 views

How would you track DB storage use and then extrapolate it?

I need to track the size of various DBs we have, then see it's growth rate so that we can guess where it will be at certain times. I'm using Oracle 11g first, but will eventually be applying this to ...
3
votes
1answer
199 views

How to determine Oracle LOB storage footprint?

With SECUREFILE storage I can specify whether I want compression (and the level of it) and deduplication, and it's all a trade-off between time and space. Timing is fairly easy to profile but what's ...
1
vote
1answer
92 views

Any way to estimate the required space for a SQL dump file?

I want to import a Wikipedia XML dump file into MySQL. The uncompressed XML dump file is 65GB. Does this mean I should free up almost 64GB in the MySQL data path? Is there any way to estimate the ...
1
vote
1answer
90 views

How un-clustered is a CLUSTER USING table

I have some tables which benefit greatly from CLUSTER ON/CLUSTER USING in Postgres SQL: # CLUSTER table USING index_name; # ANALYZE VERBOSE table; # CLUSTER VERBOSE; A maintenance task periodically ...
4
votes
1answer
73 views

Are database query optimizers aware of storage performance differences?

As I understand it, the query optimizer in SQL Server (or any other RDBMS, really) isn't aware of the performance of the storage underneath the database, and will make decisions as if all storage has ...
1
vote
3answers
396 views

do MYSQL views occupy physical space?

do MYSQL views occupy physical space? Or in other words, is a MYSQL database limited to a certain number of views?
-1
votes
1answer
60 views

best database for a real estate system [closed]

Which is the best database suits for a real estate system. Considering the storage space, security, crash recoveries, speed etc. There will be around 1000 fields and trillions of rows!!!
3
votes
2answers
762 views

Multiple SQL Server data files on same SAN disk

I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
6
votes
3answers
2k views

Stop SQL Server service(s) before defragmenting drive?

Our production SQL Server 2005 database's data files live on a separate physical drive, which Microsoft Windows 2003's Disk Defragmenter tool reports as 99% fragmented. We scheduled a task to ...
4
votes
2answers
756 views

How to Correctly Estimate the Average Number of I/O Operations my RAID 10 disk can offer?

The average Input/Output Operations per Second a disk can sustain is a very important factor in the tuning of MySQL / InnoDB databases, as it drives the speed with which Dirty InnoDB Buffer Pool pages ...
4
votes
4answers
2k views

SQL Server - Separating data, log, and TempDB files on a SAN

I have a SQL Server connected to a SAN. Our new storage vendor recommends that all LUNs span the entire disk array, which is RAID5. I would normally request 3 separate LUNs (data, log, and TempDB) ...
4
votes
1answer
139 views

Performance for fast filling table

I am currently creating a web application using the twitter streaming API and would need some advice concerning my database scheme. I basically have a list of hashtags that I track in real-time. All ...
3
votes
2answers
1k views

Splitting TempDB into multiples files equal to number of CPUs

The article SQL Server tempdb Best Practices Increase Performance suggests that I should split tempdb into a number of files equal to the number of cores. So for 4 cores you get 4 files. By ...
3
votes
0answers
171 views

How does Postgres Plus Cloud Database on AWS compare with the alternatives [closed]

I'm familiar with the difficulties of scaling regular postgres on AWS and the limitation of services like RDS. Postgres plus cloud database (bit of a mouthful) seems to run out of the box on AWS, ...
1
vote
4answers
2k views

How to prevent SQL Server database server from running out of disk space?

What are the best preventive approaches that we can do to prevent the SQL Server database server from running out of disk space ? Is there a way to set the maximum database file size (both the ...
2
votes
1answer
722 views

How to determine the read / write ratio of your server?

When looking at the read / write ratio of your server would you look at the NUMBER of reads and writes or the number of BYTES read and written? For example, consider the following numbers from ...
2
votes
2answers
90 views

Can I see the RAID group name for my SQL Server Database files?

Is it possible to see the RAID group name that my database (and log) files are sitting on, in one of the DMVs (or some other system table) ?
0
votes
1answer
369 views

Too many records on database and how to handle it? MySQL is it good to clone?

I am doing a social network and came up with the following concern regarding database storage. Let's put facebook as an example, imagine 2,000 photos per user, just 1,000 users, it would equal to ...
4
votes
1answer
340 views

Query to check where database growth was?

I have a database that grew very significantly overnight and I'd like to find out why. I've restored yesterdays backup to another location. Is there a query I can run to query the size of tables or ...
1
vote
1answer
264 views

Setting up DRBD on an active MySQL server

When it comes to setting up DRBD and MySQL, is the following possible? Set up DRBD on an active MySQL server Set up DRBD with no downtime allowed
4
votes
2answers
353 views

Enumerate drives available to SQL Server

I'm trying to work out a way of listing the drives that a particular instance of SQL Server is "aware" of, and understand the process. I can run EXEC master..xp_fixeddrives which gives me a list of ...
6
votes
1answer
2k views

Optimal placement of tempdb, mdf and ldf files in SQL Server 2012 on SSD's?

I realize this is probably a very open ended question and the answers could vary, but what is the optimal placement for the tempdb, mdf and ldf files in SQL Server 2012 when talking SSD's? ...
2
votes
1answer
327 views

Creating the database on different file groups

What is the pros and cons of creating the database for a operational system on different file groups? I know it is useful if you want to keep the static part of a database online when the other part ...
2
votes
2answers
196 views

Removing physical fragmentation

If I have inherited db that has grown to 400GB 1 MB chunk at at time. Is an offline defrag the only way to remove all the physical fragmentation. Another issue I have is that the data and log files ...
3
votes
2answers
225 views

SQL database backups methods-tools-procedures

Currently, I am investigating some way to more efficiently backup 4 Production SQL Databases (3 different servers/instances) and would like to know if anyone else has had the problems we are having ...
3
votes
2answers
342 views

Oracle extents - How can I have so few with this large size?

Note on duplication: This is not a duplicate of "Oracle extents - How can I have so many with this small size?" This is a separate question I entered which happens to be in the same domain. This is ...
4
votes
2answers
875 views

Oracle extents - How can I have so many with this small size?

This is a different question than the one with the almost-identical title. Again, this is more curiosity about how Oracle Database works than anything I need to change (yes I know multiple extents ...