SQL Server Performance Forum – Threads Archive

MsSQL perfcounters

Hey guys, I would like to do a baselining on our MSSQL 2000 server. We will about 100-150 users on April 1. So now, I would like to do a baselining. What are the specific MSSQL performance counter should I capture? Thanks. Neil

---

Check out these urls: http://www.sql-server-performance.com/performance_monitor_tips.asp
http://www.sql-server-performance.com/performance_monitor_counters.asp
http://www.sql-server-performance.com/performance_monitor_counters_io.asp
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
http://www.sql-server-performance.com/performance_monitor_counters_network.asp
http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

Thanks for the links. I will go over it. <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />

---

I also suggest you to keep in touch with this website, where most part of performance and security is covered. 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.

---

]]>