capacity planning of servers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

capacity planning of servers

I would like to do the capacity planning of prodction servers. Our website is currently hosted on database server which gives sluggish performance. So company has decided to procure servers. I would like to know for server capacity planning which tool should I used. a.Performance monitor
b.SQL server profiler.
c.Any other tool. Your help is appreciated!

How do you define sluggish performance? Disk access slow…memory issues? what is your botleneck now? What is your current hardware configuration
CPU?
DISK config?
Memory? How large is your database or datbases? Bert
See if this helps you getting started:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

]]>