The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
73 views

intel p3600 SSD no increase in read speed - postgres rdbms vs hdd

We run a custom application that produces analyzable data-sets for medical research. the amount of data we have is about 600GB in form 3Billion rows distributed in 600+ tables it is hosted in ...
0
votes
0answers
34 views

SQL Server hardware - question on filling up memory slots

We are upgrading our SQL Server hardware. ours is a muti-TB data warehouse. For example HP DL380 G9 server config with 2 CPU (8cores per CPU) has 24 DIMM slots. I'm trying to convince my TI ...
0
votes
0answers
72 views

SQL Server Error Number 825 how to proceed

I have a Windows Server 2003 running on VMWare with an SQL Server 2005 installed. This morning I received 2 warning mails 4 hours apart about error 825. Both times the error was about an incorrect ...
0
votes
0answers
185 views

Overcoming the HDD IOPS limits on a billion row table? Is getting SSD the only solution?

I have a table with this structure: CREATE TABLE `requests` ( `userid` int(11) NOT NULL, `messageid` int(11) NOT NULL, `queueid` int(11) NOT NULL AUTO_INCREMENT, `problem_id` int(3) NOT NULL, `...
0
votes
0answers
74 views

Creating a dedicated HD parition at beginning of disk for data files, benefits and draw backs?

I am thinking of creating a dedicated partition on the harddisk for the mysql database data files in /var/lib/mysql , while considering those 2 points: a dedicated partition will avoid any file ...