Lets Discuss service application of SharePoint 2010. We all are aware with the concept of SSP in MOSS2007 where all the services like Search, Profiles, Audiences, and My Sites are bundled together and a SharePoint web applications consume these services with the SSP. But the days are gone……………
Now in SharePoint 2010 , things are changed we don’t need the whole SSP to be used only one service is required. In SP 2010 all the individual services can be known as their own service applications. Main thing is that all service don’t require a database to store content like excel services as this is just the services to display just-in-time content.and some services like search are intensive and it can have more than one storage database. 
Below you can find the list of services which require database and which are cross-farm compatible and make your life easy.
SharePoint Foundation Service Applications

SharePoint Server 2010 Standard Service Applications

 SharePoint Server 2010 Standard Service Applications

SharePoint Server 2010 Enterprise Service Applications

 Feel free to Rate and provide feedback if you find post useful

Move site collections to a new database or split a content database

Hey Friends,

Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be used for the same.
Move site collections to a new database or (split a content database)

a) At a command prompt on the drive where SharePoint Products and Technologies is installed, change to the following directory:

Mostly it is C: drive do
c:\program files\common files\Microsoft shared\Web server extensions\12\Bin

b)Type the following command, and then press ENTER:

Stsadm -o enumsites –url <URL> <path/file name>.xml
where:
url: is the address of the Web application that contains the site collection that you want to move
path/file name: is the name of the XML file that you want to create with the site collection data.
The previous step creates an XML file that contains all of the site collection URLs in the current database.

c) Open the XML file that you created in step b. If there are also some other URLs for site collections which you do not want to move , delete them from the file.

URLs that you want to move should remain in the XML file.
Note: Nothing else in xml file need to be changed. Leave as it is..

d)Type the following command, and then press ENTER:

Stsadm -o mergecontentdbs –url <URL> -sourcedatabasename <database name> -destinationdatabasename <database name> -operation 3 –filename <file name>
Url: is the address of the Web application that have the site collection
sourcedatabasename: name of the database from which you want to move site collection
destinationdatabasename: name of the database in which you want to move the site collection
operation 3: “Read from file” operation
file name: name of the file that contains the site collection URLs.

e)Restart IIS by typing the following command, and then pressing ENTER:iisreset /noforce

Hope I was able to describe the content based on my knowledge and learning.