Look at the MS product offer, and I feel a bit cool!

Look at the MS product offer, and I feel a bit cool!

My company website --- a trading platform Win2000 + ASP + iis5 + sqlserver Standard Edition. The online user situation is as follows: the performance detector detects that the number of simultaneous IIS connections is at 1000 points

The Web server and data server are separated from each other. The configuration of these two machines is not low, and the database is about 8 GB. The table of the product has 10 million pieces of data.

However, the Website access speed is getting slower and slower, so we don't want to visit it.

At this time, the status of the Web server machine is: IIS process occupies cup for a long time, Cup often rushed to 100% without mercy, the memory (2g) only uses less than M.

The status of the data server is: the SQL Server Standard version (the maximum memory is 2 GB). Therefore, the maximum memory usage (4 GB) is limited by the software, and the CPU status is normal.

We think the bottleneck is here. I tried to buy an sqlserver Enterprise Edition from my boss. I didn't expect my boss to accept it. I bought it today! Now we have no bottom, in case of bottlenecks

The SQL Server Standard Edition does not support larger memory. Therefore, we have a high responsibility. Although we may be able to panic in front of the boss who does not know the computer in a technical way, our conscience cannot go through.

After all, it is 0.3 million, and the company's turnover is not that big.

It will be installed in the past few days, or "no bottom... If you have experience in this area, please refer to this situation (IIS has 1000 connections, and username + password has less than 200 login users, and database operations are not that large, it is very common to query the 10-million table. This table has clustered indexes, so it does not use too many resources, and there are fewer others. In addition, there is no bandwidth problem

), Where is the bottleneck? Disk io? Now I am worried about Webserver, because static html page response is also slow, how can I effectively use the memory of the Web server machine ??
This is the hardware configuration:
Web server machine Configuration:
HP dl580 Server
CPU: 700 m/1 M * 2
Memory: 512 KB * 4 SDRAM
Hard Disk:
O s: Windows 2000 Standard Edition (up to 4 GB memory supported)

Data Server machine Configuration:
Dell2650 Server
CPU: 2.4g/512 K * 2
Memory: 1 GB * 4 DDR
Hard Disk: 200 GB/10 KB
O s: Windows 2003 Standard Edition (up to 4 GB memory)

Here is the performance detection Screen picture:

Sqlserver Performance Detection