Home > SQL Server Learning Center
EMAIL THIS
 Learning Center: 
Last Updated: Oct 18, 2005 
SQL Server 2005 still doesn't support load balancing out of the box, but there are several ways to spread user activity across multiple servers. Learn about the benefits and how-tos of load balancing in this Learning Center.
Load balancing in SQL Server 2000 and 2005

(16 Oct 2005)

Load balancing is an essential component of database design and management. By load balancing you ensure that criticial applications will remain available when you experience a hardware or software failure. Contributor Baya Pavliashvili discusses load balancing options in SQL Server 2000 and load balancing enhancements in SQL Server 2005.

Read Full Story
ADVICE:
>> Load-balancing enhancements in SQL Server 2005
TIP :SQL Server 2005 still doesn't support load balancing out of the box, but it offers useful new features that help distribute ...
>> Compare load balancing options for SQL Server 2000
TIP :Get up to speed on load-balancing options for SQL Server 2000: backup and restore, log shipping, transactional replication, ...
>> Why cluster?
TIP :A brief look at clustering and its system requirements.
>> Clustering in SQL Server 2000 explained
ASK THE EXPERTS :I don't understand the active/active model in SQL Server 2000's cluster system. Could you give me a clear explanation and ...
>> Active/active or active/passive clustering?
ASK THE EXPERTS :I am looking at clustering. My only concern is whether to go active/active or active/passive. I understand active/passive ...
>> How does failover clustering work in SQL 2005?
ASK THE EXPERTS :How does failover clustering work in SQL 2005? And how does it compare with the failure support in Oracle and DB2?
>> Database partitioning methods in SQL Server
TIP :Partitioning allows you to improve performance by distributing a table over multiple databases. Expert Hilary Cotter ...
>> Log shipping a replicated database
TIP :Log shipping allows you to automatically copy and restore transaction logs to another database on a standby server. Why use ...
>> Understanding replication methods: Snapshot, transactional and merge
TIP :In this book excerpt, you will learn the process, the advantages and disadvantages, and tips on when to use three different ...
>> 15 SQL Server replication tips in 15 minutes
TIP :This list of tips and tricks will help you enhance your replication techniques. It is broken up into three groups: ...
>> Keeping five databases in sync
ASK THE EXPERTS :I'm running SQL Server 2000 and using log shipping to create a standby server with five databases as a DR failover. The five ...
>> Building a scalable SQL Server
TIP :How well your SQL Server functions over time depends on how you built your database, where you put your code and how you ...
>> Running one or two servers in active mode
ASK THE EXPERTS :As far as performance tuning, could you offer your opinion or suggest where I might find statistics for the following ...

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server clustering
SQL Server errors, failures and other problems fixed from the trenches
Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
SQL Server backups using SAN database snapshots
Setting up SQL Server clusters on a SAN
SQL Server Blog Watch
SQL Server cluster design: One big cluster vs. small clusters
FAQ: SQL Server comparison features
SQL Server consolidation: Why, when and how to consolidate SQL Servers
Active/Active clusters in SQL Server
Avoiding SQL Server Sprawl with the PolyServe Database Utility

SQL Server performance and tuning
Basic objects of T-SQL in SQL Server 2008
Using T-SQL data types in SQL Server 2008
SQL Server 2008 function types in T-SQL
Additional T-SQL operations in SQL Server 2008
SQL Server 2008 Integration Services delivers new features
Tips for tuning SQL Server 2005 to improve reporting performance
SQL Server errors, failures and other problems fixed from the trenches
SQL Server database design disasters: How it all starts
Can you shrink your SQL Server database to death?
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
contiguity  (SearchSQLServer.com)
contiguous  (SearchSQLServer.com)
drilldown  (SearchSQLServer.com)
hashing  (SearchSQLServer.com)
hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

> SQL Server restore how-tos
> Learning Center: Top 10 SQL Server security tips
> SQL Server 2005 data mining
> SQL Server 2005 security
> Database design decisions
View All Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts