SQL Server 2000 Scalability
The client has a problem with Scalability. I've yet to see the design configuration, but started looking for some material to help.
A scan of CSC RFA camme up with a response with an attached paper from ORACLE Data Warehouse with SQL Server response giving ORACLE's views on the weaknesses of SQL Server.
That paper references a site called SQL-Server-Performance.com. There are some useful tips here.
A paper that describes the use of Distirbuted Partition Views to scale up can be found here.
There are several versions of SQL Server 2000. The MS SQL site explains
here.
Decent overview of options for scale-out and failover are
here.
Now I know I've got some stuff on scaling SQL Server from previous assignments - I just have to find it....
A scan of CSC RFA camme up with a response with an attached paper from ORACLE Data Warehouse with SQL Server response giving ORACLE's views on the weaknesses of SQL Server.
That paper references a site called SQL-Server-Performance.com. There are some useful tips here.
A paper that describes the use of Distirbuted Partition Views to scale up can be found here.
There are several versions of SQL Server 2000. The MS SQL site explains
here.
Decent overview of options for scale-out and failover are
here.
Now I know I've got some stuff on scaling SQL Server from previous assignments - I just have to find it....
1 Comments:
Depending on timescales and risk etc you may want to check out SQL Server 2005. Lots of interesting scalability and availability features added. Check out SQL Server 2005 on MSDN or Kimberly Tripp on Dot Net Rocks.
Cheers
Mike
Post a Comment
<< Home