Simple Machines > Archives
New SQL Server
dschwab9:
The number of cores is the primary reason we upgraded. Our old database server was a quad core and our slow downs were due to all the cores being maxed out at peak times. We didn't have any issues with disk IO. The new server with additional cores fixed the problems.
Bas:
--- Quote from: rsw686 on September 04, 2009, 06:42:27 PM ---If http://forum-en.msi.com/ is running on the server in Bas's sig there is something not configured right as the page load time was 6.5 seconds.
--- End quote ---
That's not a normal load time, but it can happen when many people are searching at the same time.
We need the max possible search index and that almost doubles the database size, and when many people use it, it can slow it down a bit sometimes.
If you have a forum without a lot of searching that is a lot easier to configure and way less hardware is needed.
Yigal:
--- Quote from: Hell Raiser on September 04, 2009, 06:54:21 AM ---11GB RAM
Short it down to 8GB and let me borrow other 3GB's of RAM for my PC :P
--- End quote ---
I have 4 :P
The server has 12GB not 11 :P
dschwab9:
--- Quote from: Bas on September 06, 2009, 04:44:21 AM ---That's not a normal load time, but it can happen when many people are searching at the same time.
We need the max possible search index and that almost doubles the database size, and when many people use it, it can slow it down a bit sometimes.
If you have a forum without a lot of searching that is a lot easier to configure and way less hardware is needed.
--- End quote ---
You should seriously consider using sphinx if you're not already. We run a dedicated Sphinx server for this site and searches happen very fast with no measurable load on the web or database servers.
Hell Raiser:
--- Quote from: Yigal on September 08, 2009, 03:05:08 AM ---
--- Quote from: Hell Raiser on September 04, 2009, 06:54:21 AM ---11GB RAM
Short it down to 8GB and let me borrow other 3GB's of RAM for my PC :P
--- End quote ---
I have 4 :P
The server has 12GB not 11 :P
--- End quote ---
O...oO you have 4GB :P
Throw some GB's on me :P
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version