SQL Server Performance Forum – Threads Archive
capacity planning of serversI 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
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 —
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)