SQL Server Performance Forum – Threads Archive
Capacity Planning
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. RegardsSachin
This is really old, but some tips are still potentially useful: http://www.microsoft.com/technet/prodtechnol/sql/70/tips/storagen.mspx http://msdn.microsoft.com/library/d…en-us/dnsql2k/html/sql_nsperformance.asp?_r=1 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx
http://www.netapp.com/library/tr/3363.pdf
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx MohammedU.
Moderator
SQL-Server-Performance.com
http://blogs.msdn.com/weix/archive/2005/04/17/408942.aspx
http://www.bitpipe.com/rlist/term/Capacity-Planning.html http://msdn2.microsoft.com/en-us/ms978394.aspx – SQL 2005 related. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>