| View Question |
|
|
 | ||
|
| Subject:
MS SQL server performance
Category: Computers > Internet Asked by: inon-ga List Price: $5.00 |
Posted:
23 Apr 2002 17:22 PDT
Expires: 30 Apr 2002 17:22 PDT Question ID: 3242 |
how many page views per hour can a site take with one MSSQL server7.0 installed on a dual pentium 500 (each page contains 1-2 SQL transactions on average) |
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: MS SQL server performance
From: sadpanda-ga on 23 Apr 2002 18:37 PDT |
What did you configure the server to handle as the maximum allowed connections at one time? |
| Subject:
Re: MS SQL server performance
From: maxhodges-ga on 24 Apr 2002 21:16 PDT |
That question cannot be answered at all, and anyone who submits an answers is a liar because it TOTALLY depends on what those transactions are doing! Multiple table joins? Cartesian joins? How are tables indexed? How fast are the disks? Are they any non-sargable arguments in the query? How much RAM is available? Are you doing inserts or selects? Are they another processes running of the server database? www.sql-performance.com is a great resource on sql server performance optimization techniques. I suggest you simply create a loop and benchmark the performance yourself. Each configuration is somewhat unique. Best regards, Max |
| Subject:
Re: MS SQL server performance
From: asasasasas-ga on 06 Jun 2002 00:57 PDT |
www.sql-performance.com is down |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |