SQL Server Performance Forum – Threads Archive

sql performance

hi i have a sql server whit 1 gig database .my dual cpu are zeon 2.4 intel .and 2 gig memory . i need more speed (cpu).
what can i do ? can i use from another server’s cpu in network . please help me .

---

Hi ya, you may want to run SQLProfiler to identify what queries are causing the CPU consumption. a 1GB database should easily be able to be served by a dual xeon with 2GB RAM. I’d suspect that you need to look at indexing tables Cheers
Twan

---

Refer to this website under mainpagehttp://www.sql-server-performance.com/ for the tips & tricks to gain performance. (post moved from SQL Clustering) 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.

---

thanks , but our queries is very complex .

---

thanks , but our queries is very complex

---

can i use other server cpu in network.

---

If you can fine tune the query then no need to add more resource on the server, confirm about the status of database health checks and index strategy. 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.

---

thanks ;
our team check our database . i want to use another server cpu in network , similar clustering . sql server has 2 cpu and another server has 2 cpu . i want to have 4 cpu in sql proccess . .
how can i do that ? please help .

---

No, can’t do that.
Futhermore, if you have 4 cpu is no garanty you queries will run fuster.
May be you have disk problems, indexs problems, statistics problems, etc. In short performance problem, not necesary hardware problems. I suggest to use Performance Monitor and Profiler to start.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

Even though I am a beginner, I would agree with this sentiment, meme. A 1GB DB with 2 Gig memory and 2.4Ghz processor and performance problems does not seem like a processor or memory issue. You need to run PerfMon, I would suggest for the following:
memor pages/sec
memory available bytes
physical disk % disk time
physical disk avg disk queue length
processor % procesoor time
system processor queue length
sql server buffer cache hit ratio
sql server buffer mgr page life expectancy From these stats, take a look at them during your long running or trouble queries, and see what is going on. There is an article on this site that I printed out called "Using Performance Monitor to Identify SQL Server Hardware Bottlenecks" but I just can’t seem to find it anymore. When you collect the stats, post them.

---

]]>