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 [...]
Tag Archives: sql server capacity planning
Physical SQL Server Hardware Configuration Planning Questionnaire
Posted by Mahesh Gupta on March 17, 2011
2 comments
Database size Growth chart report (graphically)
Posted by Mahesh Gupta on July 13, 2010
15 comments
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 [...]
