SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server scaling techniques

19 January,2011 by Jack Vamvas

Database system scaling is an important topic. Planning and design of a database system should include methods for scaling  - upwards and outwards. Requirement to scale examples are; (a) change of focus on data gathering , which leads to different size of datasets b) business acquisition  which requires integration with other systems.

Some features I've found useful in SQL Server for scaling are:

-Partitioned Views

-Service Broker

-Services Oriented Database Architecture(SODA)

-Compression

-Data Dependant Routing (DDR)

-Table Partitioning

A Partioned View splits data from a larger table into smaller tables (member tables).The partitioning occurs via a range(s) of values in a defined column horizontally.

Service Broker allows loosely held tasks to work together  as an asynchronous application.

SODA  Large centralised databases are still key  but think of  multiple large databases that are repositories for different classes of data

Compression  used with Read Only file groups  , useful in databases with multiple filegroups

DDR  application intelligence#development is focused on middle tier , to decide on which databases to route to. Note: this is different from views across multiple databases.

Table partitioning (& Index Partioning)  Spread tables and indices across multiple file groups in partitions .This allows flexibility in spreading across multiple devices. Useful in assisting data archiving strategy

Read More

 Archiving SQL Server Data - SQL Server DBA

SQL Server DBA Tools

Data compression in SQL Server 2008

How to use SQL Backup Compression


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer