YAFLogo

tperry
  • tperry
  • 72.2% (Friendly)
  • YAF Lover Topic Starter
12 years ago
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?

    View All Posts by User
    Sponsor
    bbobb
    • bbobb
    • 100% (Exalted)
    • YAF Developer
    12 years ago
    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.
    View All Posts by User
    abcd
    • abcd
    • 64.2% (Friendly)
    • YAF Lover
    12 years ago
    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.

    View All Posts by User
    JP
    • JP
    • 100% (Exalted)
    • YAF Leader
    12 years ago
    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

    He who asks a question is a fool for five minutes. He who does not ask a question remains a fool forever. [Old Chinese Proverb]
    View All Posts by User
    tperry
    • tperry
    • 72.2% (Friendly)
    • YAF Lover Topic Starter
    12 years ago

    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.

    Originally Posted by: abcd 

    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.

    View All Posts by User
    squirrel
    12 years ago

    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

    Originally Posted by: JP 

    How many users active on average?

    If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
    View All Posts by User
    Similar Topics
    Users browsing this topic