Category Archives: Server Consolidation

Physical SQL Server Hardware Configuration Planning Questionnaire

A DBA, need to consider the following point in mind, prior to fix Server Hardware Configuration. 1. Is this database designed for Online Transaction Processing (OLTP) or for a decision support system (DSS)? OLTP DSS OLTP and DSS both 2. Select a server platform for your database a. Dell Power edge b. Compaq c. Open [...]

What is Server Consolidation?

What is Server Consolidation? Server Consolidation is process for reducing the number of physical servers by consolidating onto fewer servers. This can be easily understand by following image.   What are the benefit for Server Consolidation ? There are aspects of server consolidation and several ways in which consolidation can result in tangible benefits, including [...]