Database server is very important to isolate the data tier from the application tier and this will give better performance when querying your database specially for tera size databases. It is also important in disaster recovery situations as separate database server is more easy to recover than having a server that hosts both the applications and databases.
