Re: Transition from Stand-ALone SQL Server to Cluster

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 07:45:01 -0500

Perhaps you should first look at what the bottleneck is. Is it memory?
CPU? Disk? It is possible that by adding the components that you're
lacking, you don't need two servers. As Mike said, clusters are for high
availability, not performance. I'd certainly start with adding memory. SQL
Server loves memory like I like a rack of BBQ ribs. ;-) 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com
.
"dark_15" <dark15@discussions.microsoft.com> wrote in message 
news:3D744F3D-95BF-44C3-BCC0-9B85E2BAEC96@microsoft.com...
Here's what we have currently:
Dual Hyperthread Xeons @ 2.8 GHZ
2 GB or RAM
147 GB 15k SCSI U320 HDD
This single server can easily take care of the load and size requiments for
one of the databases.  However, when we run the second database and custom
app for it, the performance levels on both apps drop severely.  Plus, as we
quickly realized, our disk space would need to expand exponentially.  We 
will
need around 1.5 terabytes to store our data for the second database and its
app.
I was considering purchasing a dual-processor 3.4 GHZ Xeon with 4 GB of RAM.
I was also going to purchase a SAN storage solution:
http://www.qlogic.com/simplify/sckwinserv.asp - Fiber Channel Kit
http://www-1.ibm.com/servers/storage/disk/ds/ds400/index.html - IBM
TotalStorage DS400
as well as 13x 147GB 10k U320 SCSI drives to put into it; this should solve
my storage problems.
That is all the information I can give at this moment.  If you need anything
else, please let me know.  Thanks again!

Relevant Pages

  • Re: High memory usage (*HELP*)
    ... Low on virtual memory does not necessarily mean anything with regard to disk ... If your system uses all the available RAM, ... acceptable for a server to put all of its available RAM to use. ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance
    ... The server is set up with Raid 0 for the system and Raid 0+1 for the D ... rest in the D: (make sure D: is another different physical hard disk). ... The physical memory has available 5029150and stays pretty constant. ...
    (microsoft.public.windows.server.general)
  • Re: Single RAID 5 for everything....
    ... mainly due to the lack of utilization of the CPU and memory. ... total disk queue...ours is constantly around 4-6 and my physicaldisk/avg disk ... on the exchange server failed on the reboot already. ... Exchange server, you should be installing so much memory that Exchange ...
    (microsoft.public.exchange.setup)
  • Re: AS 2005 slowness...
    ... closer to 30 true dimensions), ... Am not sure where the tempdb is - most likely on the same disk as SQL ... Server and AS, although this disk is cheap-wrt-IO cost, so I'd hope ... Reported memory consumption is 1.8GB for AS, ...
    (microsoft.public.sqlserver.olap)
  • Re: AS 2005 slowness...
    ... closer to 30 true dimensions), ... Am not sure where the tempdb is - most likely on the same disk as SQL ... Server and AS, although this disk is cheap-wrt-IO cost, so I'd hope ... Reported memory consumption is 1.8GB for AS, ...
    (microsoft.public.sqlserver.olap)