?
Solved

SQL Server Capacity Planning

Posted on 2011-05-04
2
Medium Priority
?
482 Views
Last Modified: 2012-06-27
I need steps on how to do capacity planning in SQL 2K5 and 2K8 database enviroment. I was never asked to do this early in my career, so have no idea of how it is really done. Somebody provide me with steps please.
0
Comment
Question by:Favorable
2 Comments
 
LVL 13

Accepted Solution

by:
Wizilling earned 2000 total points
ID: 35695197
do some data collection of how much your data grows by for each week or month . estimate how much data will grow by for the year base on those.
estimate how much more resouces would be need to maintain backups

http://www.scribd.com/doc/6340592/Oracle-Database-Capacity-Planning

http://msdn.microsoft.com/en-us/library/ms978394.aspx

http://technet.microsoft.com/en-us/library/cc298801.aspx
0
 

Author Closing Comment

by:Favorable
ID: 35734397
Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question