SQL Server Performance Forum – Threads Archive

SLOW RUNNING SQL SERVER

gUYS,
i have a server with 4 GB RAM and 2 dual core proc.
the database files are on a RAID 10 and the log file on a Raid 1.
Can someone please give me the necessary counters so that i can monitor to know where is the problem.
thanks AKTHAR

---

http://sqlserver-qa.net/blogs/perftune/archive/2007/07/06/what-to-do-if-your-sql-server-system-is-slow.aspx http://sqlserver-qa.net/blogs/perft…mance-impact-of-simple-use-of-procedures.aspx http://sqlserver-qa.net/blogs/perft…ailable-in-sql-server-performance-tuning.aspx http://sqlserver-qa.net/blogs/perft…-dashboard-reports-making-most-out-of-it.aspx Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

thanks exactly what i was looking for [<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]<br /><br />AKTHAR

---

Thanks Satya AKTHAR

---

]]>