Posted by: tperry - Tuesday, 17 April 2012 16:56:43 |
---|
OK, specs to start: [list][*][url=http://forum.scenariopaintballteam.com]http://forum.scenariopaintballteam.com[/url] [*]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? |
Posted by: bbobb - Tuesday, 17 April 2012 17:59:02 |
---|
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. |
Posted by: abcd - Tuesday, 17 April 2012 18:12:03 |
---|
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. |
Posted by: JP - Tuesday, 17 April 2012 18:41:19 |
---|
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 |
Posted by: tperry - Tuesday, 17 April 2012 18:54:18 |
---|
[quote=abcd;54254]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. [/quote] 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. |
Posted by: squirrel - Tuesday, 17 April 2012 22:38:55 |
---|
[quote=JP;54257]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[/quote] How many users active on average? |