I need guidelines for preparing capacity planning chart for the server which is already in production.Actually i just gone through Maximum Capacity Specifications for SQL Server but it is for maximum capacity.Im briefly giving my server and databases details below
1) SQL Server with 8 databases,all databases are in production. 2) daily growth rate on an average 300MB 3) Server is at client location,connecting to 150 machines. 4) On an average 3,50,000 records inserting into the databases.
here also few questions,
1)as a DBA how should i analyze the capacity planning for the given details?
2)What are intial set of things should i look into first before planning?
3)Hardware resources allocation?? will this comes under DBA tasks or this sould be taken care by the network admin?
4)what will be the best practices of effective memory management(CPU and Memory)?
5) How should i plan for disk space allocation and which RAID levels should i plan for?
6)should we consider the best data accessing methods to access the data from the databases? or this will not comes under tasks of DBA.
7)Last but not least as a middle level DBA what are the minimum things should i keep in mind while doing analysis on CP?
Can anybody provide me guidelines in preparing CP chart.For any details like no of database objects in each databse etc.,i can give details if you are interested for further analysys.thanks in advance..