SQL Server Enhance Scalability
Explain in brief how SQL Server enhance scalability of the Database System ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted Apr 10, 2012, 12:15 AM
http://msdn.microsoft.com/en-us/library/cc645580(v=sql.100).aspx
Please refer this microsoft guide.
http://www.microsoft.com/sqlserver/en/us/solutions-technologies/mission-critical-operations/performance-and-scalability.aspx
http://msdn.microsoft.com/en-us/library/cc645580(v=sql.100).aspx
Jignesh TrivediPosted Apr 10, 2012, 12:00 AM
SQL Server provides the highest levels of security, reliability, and scalability to our for your business-critical applications.
As above post discrib SQL Server has inbuild so many Processes like creating Execution plan,parallel excution, ect. increate scalability.
Scalability and performance enhancements in the Database Engine is also include filtered indexes and statistics, new table and query hints, and new query performance and processing features.
hope this help.
Satyapriya NayakPosted Apr 9, 2012, 1:29 PM
SQL Server has efficient ways to enhance scalability of the database system. SQL Server 2000 automatically adjusts the granularity of locking for each table used by a query. Parallel Execution Plans is in placed automatically. This split the processing of a SQL statement into pieces that can be run on a different CPU, thus allowing the complete result set to build faster.
Thanks