Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Capacity Planing

Author  Topic 

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-02-08 : 01:57:26
Hi All,

We need to do capacity planning for our SQL server database server. Capacity planning is interms of CPU usage, Memory usage and disk usage.

Can anybody help me with how should I start and what are the guidlines to do it? I have started executing perfmon utility with some counters but still not sure what to do next. Please help me. Thanks in advance.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-08 : 12:03:53
you can start with google http://www.google.com/search?q=sql+server+capacity+planning



-ec
Go to Top of Page

hvdtol
Yak Posting Veteran

50 Posts

Posted - 2007-02-08 : 12:07:41
It all depends on the applictions you are running on against the database.
Can you expect more data, do you expect more transactions?
Go and ask the persons who are responsible for those applications, and ask them what they will expect. Then you can make a long-term capacity planning.
Go to Top of Page
   

- Advertisement -