Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-24 : 07:50:55
|
| Cesar writes "Hello: I have an issue with sql 2000 performance, the application that we run is database intensive. Even running SQL 2000 on a four processor server we are still experiencing a severe bottle neck. The only solution that I can think off would be to install a couple of more servers and load balnce SQL 2000. However, from I have read SQL 2000 does not load balance, are their any other alternatives..Cesar" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-11-24 : 11:26:22
|
| I think the closest thing SQL Serer has to load balanced clustering is something called "Federated servers." I believe there's an article on SQLTeam.com about it. I know there's a good bit of information in the BOL on it. What I would suggest before Federated Servers is to use SQL Profiler and identify problem queries and let us help you tune those queries. You might be able to use the hardware you have and make it work. I find it hard to belive that you are maxing out a quad processor box. How much RAM and what sort of disk subsystem does that machine have? Those are the two most important hardware statistics for a SQL server.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-11-24 : 13:19:39
|
| I would start monitoring your disk subsystem's performance along with processor and memory usage. There are several good articles in the knowledge base for identifying performance bottlenecks. Databases tend to be more I/O or disk bound than processor bound. Before buying hardware make sure you have identified what is causing the problem.Lance Harra |
|
|
|
|
|
|
SQL 2000 clustering