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-07-22 : 07:34:19
|
| Praveen writes "For a load test of web application, what make the cpu of DB(SQL Server) run upto 90%? i.e %processor time. What are the relative factors which affect the performance of SQL Server?What role does user connections play,with respect to sql server performance?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-22 : 12:31:49
|
| Have you read any SQL Server performance books? You are asking very general questions that would take a long time to answer the question. I suggest reading "Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" by Ken England.Tara |
 |
|
|
|
|
|
About SQL Server Performance