Horizontal data partitioning is a method of moving data from one table or database to other data repositories. Data can be partitioned across multiple filegroups on the same server or moved to databases on remote servers.
Targeting multiple database servers is an effective way to scale out an application and allow it to accommodate more users. You can use several techniques to scale out your application. You might have to use one or more of the following to achieve the desired result: scalable shared database, peer-to-peer replication, linked servers, distributed partition views, data-dependent routing, and service-oriented data architecture.
You can use SQLCLR to execute managed code for the .NET Framework on your SQL Server. In some cases, this can provide a performance advantage. You can write code using Visual Basic .NET, C#, or J#.
To analyze and resolve database application performance problems, you should use tools such as Windows System Monitor, SQL Server Profiler, and the newly included distributed management views.