Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New VFP version after 5815?
Message
From
25/09/2015 11:31:03
 
 
To
25/09/2015 04:42:59
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624637
Message ID:
01625098
Views:
77
Do you mean by CPU a virtual CPU (i.e., one process)? If so, 10 users per process is very good. That seems to be what you are describing. If so, that's very good. I typically aim at 3 users per process (in a highly transactional system that does a lot of reports that need crunching).


>>>>On one server, by example, we have sometimes between 20 and 30 users (or more) running in a 2X environment. 2.8Ghz CPU, 16Gb RAM, SSD, 8 core CPU. Users are running various reports, drawing charts, looking at financial statements, PDF files, looking at real-time news feeds, displaying real-time stock market data in various types of reports and various real-time updating charts. An average user may have anywhere between 10 to 50 windows open at a time. Memory usage sits around 50Mb to 100Mb per user. The server is also retrieving the incoming real-time data at a rate of about 50 records per second. CPU sits around 1%. Total memory usage is well under 50%. This is not an order entry system so probably not a comparable user environment.
>>>
>>>in 4 hours today:
>>>
>>>
>>>PID    COM server    hits
>>>5744  ctb.ctbServer	  6996
>>>5564  ctb.ctbServer	  2284
>>>4648  ctb.ctbServer	    548
>>>4312  ctb.ctbServer	      85
>>>424	  ctb.ctbServer	      14
>>>4292  ctb.ctbServer	        3
>>>total                           9930
>>>
>>>
>>>around 1 hit per second
>>>
>>>10 users average
>>>250 hits per user per hour
>>
>>I don't really know what you want to say with these stats. Are you saying the server is under heavy load and thus justifies the 10 user / max CPU usage? I don't know what a "hit" entails, what resources a "hit" uses. But 10 users = max CPU seems very onerous imo.
>>
>>The server I described also acts as a web server serving remote requests for data directly feeding into end-user spreadsheets. It handles millions of data records in the charting databases, tens of thousands of records in multiple reporting databases, etc. It easily handles 20, 30 or more users. And I don't think it is a very high end server; just a single CPU, 16Gb ram. I could easily ramp that server up.
>>
>>What is consuming the CPU on your service? Is it FIC or the database engine or what?
>
>Frankly I'm not very keen at discussing whether it seems or not
>
>We have dozens of response time figures to share, for readers who like to analyze real facts and figures, are you one of these?
>
>Speaking of millions, the database has million records (order items)
>This application is an ERP that the whole company works with.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform