Tag Archives: sql server capacity planning

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 [...]

Database size Growth chart report (graphically)

At time DBA need to develop a custom report to get database sizes on each individual SQL instances that are running. At times, we might wanted to use this report and create custom charts on database growth for each server on a weekly/monthly basis. Here we are taking a example, we wanted to represent database [...]