Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Load balancing
0 views
Skip to first unread message
Shabam
Sep 21, 2004, 11:34:14 PM9/21/04
to
Ok, suppose I have a dotnet application that uses MS SQL server. The SQL
server is maxed out. Suppose the code is already optimized and suppose I've
already maxed out the ram and processing power. What ways are there to load
balance it so that I can scale the application further up?
server is maxed out. Suppose the code is already optimized and suppose I've
already maxed out the ram and processing power. What ways are there to load
balance it so that I can scale the application further up?
Paul Ibison
Sep 22, 2004, 4:06:54 AM9/22/04
to
You could scale up on the SQL Server box - more
processors, more ram, faster disks (raid 10 for data),
filegroups etc. Assuming all this is done, have a look at
(a) federated database servers (aka Distributed
Partitioned Views).
(b) using log shipping/transactional replication to
maintain a reporting server to offload reporting
requirements.
HTH,
Paul Ibison
processors, more ram, faster disks (raid 10 for data),
filegroups etc. Assuming all this is done, have a look at
(a) federated database servers (aka Distributed
Partitioned Views).
(b) using log shipping/transactional replication to
maintain a reporting server to offload reporting
requirements.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
0 new messages