OK, specs to start:

[list]

http://forum.scenariopaintballteam.com 

YAF 1.9.6 RC1

Windows 2008 Server R2 Standard Ed (64-bit)

AMD 2 GHz proc

2 GB or RAM

MS SQL Server 2008 Express[/list]

The typical number of users logged in plus guests isn't that impressive; 10 would be a busy session for us. However, I've had spikes of 70-100 guests/bots hit me within a 15-30 min period.

My typical RAM consumption by the IIS worker proc for this site is ~300 MB. MS SQL Server is typically holding another 180MB of RAM. In the coming weeks I'm planning on optimizing some of the settings for both IIS 7 and the SQL Server and wondering what others are experiencing. Will I get much of an improvement out of my tuning efforts?

I should notice that 1.9.6.1 fixes some perfomance problems - it someone visits a rare page it could overload server for a long time. It would be interesting to get data on the version to impove the perfomance. Developers already introduced some functionality which doubles data to improve perfomance. All benchmarks are much appreciated.

I think that you should be limited memory for MS SQL express:
from SQL Server Management Studio Express, if I right-click on the root node in the tree (the server node) and select Properties, there's a "Memory" page with maximum amounts of memory available to be set. and you can set maximum Ram for MS SQL (180M)
hope this help.

My forum typically uses 1-4 GB of RAM for the IIS wp, and 1.5-3GB for SQL Server

- HP DL180 with 2.6 GHz Intel quad-core "i5" processor
- 12GB RAM
- Win 2008 R2 Standard Edition 64-bit
- SQL Server 2008 R2 Standard Edition

---

I think that you should be limited memory for MS SQL express:
from SQL Server Management Studio Express, if I right-click on the root node in the tree (the server node) and select Properties, there's a "Memory" page with maximum amounts of memory available to be set. and you can set maximum Ram for MS SQL (180M)
hope this help.

Yeah, def need to limit what SQL Server can take and how long it holds onto past queries, etc. Just haven't gotten around to it after moving onto our new VPS.

My forum typically uses 1-4 GB of RAM for the IIS wp, and 1.5-3GB for SQL Server

- HP DL180 with 2.6 GHz Intel quad-core "i5" processor
- 12GB RAM
- Win 2008 R2 Standard Edition 64-bit
- SQL Server 2008 R2 Standard Edition

How many users active on average?

---