I'm in Urgent [<img src='/community/emoticons/emotion-11.gif' alt='8)' />] need of Metrics which are considered for the Performance Tuning and Capacity Planing for the SQL Server 2000. Can Anyone take time to help me. Thanks in Advance for taking time to reply.
I can understand that you are in urgent need of information. However, there is *no* need to start 4 threads on the same question! Search this site for Performance Tuning and see if this helps: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)
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx http://www.netapp.com/tech_library/ftp/3363.pdf too. (with no doubt deleted those unreplied locked duplicate posts) Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I've locked them. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)