I have a website where the number of visitors is increasing and it is facing a poor response time. I am not a server specialist and for this reason I want to expose my issue here to receive some feedback. The website has the following characteristics:   Developed with ASP.NET Web Forms (I will be implementing a new version with ASP.NET MVC soon). It uses a PostgreSQL 9.1 database. It is 100% dynamic which means that every page is formed at run-time getting information from the DB. Hosted in a cloud server with 2 Cores and 4 GB of RAM. Windows Server 2012 in drive C: PostgreSQL DB in another "hard disk" as drive D: The average number of daily visitors is 2,500   Watching the Task Manager I can notice that there are many PostgreSQL processes which consume CPU 100%. Another process that is shown in the "IIS Worker Process" but I have not seen it as critical as the PostgreSQL process. So it seems that the main issue here has to do with the database access. When CPU usage is high the website response is extremely low and also it is very difficult to establish a remote desktop connection.  I have thought about upgrading the cloud server to, for example, 4 cores and 8 GB of RAM, but firstly I want to get feedback from experts here so I can take the best approach. I am not a server expert and, for this reason, I do not want to take steps blindly.
This is a  about  Related:      I have a question regarding capacity planning. Can the Server Fault community please help with the following:   What kind of server do I need to handle some number of users? How many users can a server with some specifications handle? Will some server configuration be fast enough for my use case? I'm building a social networking site: what kind of hardware do I need? How much bandwidth do I need for some project? How much bandwidth will some number of users use in some application?
Proving that a Binary Tree of $n$ nodes has a height of at least $\log(n)$. On  we try really hard to fix spelling, grammar, and capitalization mistakes in question titles in order to avoid the . But occasionally someone enters a question with an all-lowercase title ().  It would be useful if the system could nudge the user toward capitalizing titles property by showing a hint when the user appears to be capitalizing incorrectly. For instance:    As  and  note in comments, the feature should also try to detect and advise against Title Case and ALL CAPS. How do I disable network manager permanently? I'm using Ubuntu 18.04.1 LTS. I want to disable network manager on an Ubuntu machine, because (1) I don't need it, (2) I prefer having hardcoded configuration, and (3) network manager regularly causes issues by changing the DHCP configuration. I tried to follow :  Stop network manager sudo systemctl stop NetworkManager.service  Disable network manager (permanently) to avoid it restarting after a reboot sudo systemctl disable NetworkManager.service   Despite this, the network manager is back again every time I reboot the machine. How can I make it go away? In 2018, Kyle Reese (a normal civilian who wasn't part of Resistance) was on the top in the hit list of Skynet. It means that Skynet of that time had information from future about Kyle Reese being father of future leader of human resistance. Right?  Why didn't Skynet kill Kyle Reese instantly after his detection kicking John Connor out of existence? Overstayed my US visa for over 9 years, never got deported, can I return as a tourist? How do I install Java? How to open a folder in Finder by a single mouse click? (using Icon view) Is there a setting, key combination or similar to open a folder/subfolder in Finder with a single mouse click ?  I need a general solution which works on any folder in effort to minimize needless clicking ... that tiny triangle aside the folder icon will work yet its just too small and only appears using list view ... inspired by same behavior on osx inside a browser to hold down command key and single click a web link ... forcing users to double click is so 20th Century  Is there a way to enable this on macOS (High Sierra or higher)?  On ubuntu this single click preference is a simple setting ;-) I have a TikZ picture with a node containing a minipage with an itemize environment; each item is a hyperref to other sections of the document.   When scaling the image (for example with \begin{tikzpicture}[scale=.7, transform shape] I've a strange behavior: links in itemize are not in the right place: they present a somewhat vertical offset, as if they don't scale as the rest of image.   Here the MWE:  \documentclass[a4paper]{article} \usepackage{tikz} \usepackage[pdftex]{hyperref} \begin{document}  Here something interesting\label{text:interesting-one} \newpage  Here something interesting, too\label{text:interesting-two} \newpage  and here there are very very interesting stuff\label{text:interesting-three} \newpage  \newpage Now the problem: links rectangles have some offset, making links unusable in case of long itemize  \begin{figure}[htb] \begin{tikzpicture}[scale=.7, transform shape] \node at (0,0) (mynode) { \begin{minipage}{4cm} \begin{itemize} \item \hyperref[text:interesting-one]{First link} \item \hyperref[text:interesting-two]{Second link} \item \hyperref[text:interesting-three]{Third link} \item \hyperref[text:interesting-one]{First link again} \item \hyperref[text:interesting-two]{Second link again} \item \hyperref[text:interesting-three]{Third link again} \end{itemize} \end{minipage} }; \end{tikzpicture} \end{figure} \end{document}   And here a snapshot of the problem    Note: This is evident using the default settings of hyperref package, which draws the red rectangle around links, but it took me some time to found it when only the text is coloured, i.e. when using \usepackage[linkcolor=blue,colorlinks=true]{hyperref} Find a combinatorial argument for the following binomial identity:   $$n(n+1)2^{n-2} = \sum_{k=1}^{n}k^2\binom{n}{k} .$$   Algebraic proofs can be found at  , and a related identity at  . Is uncertainty principle a technical difficulty in measurement? Is the uncertainty principle a technical difficulty in measurement or is it an intrinsic concept in quantum mechanics irrelevant of any measurement?  Everyone knows the thought experiment of measuring the position of an electron. One can detect electron's position by hitting it with a photon, due to Compton scattering the collision of the photon with electron will change electron's momentum. This experiment is used to explain uncertainty principle to layman, but it is over simplified, isn't it? It also gives an impression that if there was a better suited experimental method the uncertainty principle becomes irrelevant.   I personally think it is intrinsic as it arises from the non-zero commutator of position and momentum operators irrespective of the measurement process. Am I right?  EDIT: My question is similar to certain extent to  and . The answers there are nice but they focus on explaining basics of quantum mechanics more than they comment on the technical difficulty part. In the answers of question 2 there are statements like "So, it's not a knowledge limit" and "you're sort of correct when you say it's an observational limit" without further comments  To summarize, assume hypothetically we managed to find a way in the future where we can have a look at an electron without disturbing it by measurement or causing its wave function to collapse, would the uncertainty principle still hold in such a case?? Why/Why not? Which novel involves vampires, burning satellites, space travel, and body modification? About a decade ago, I encountered a novel or a novella that I cannot locate.   The setting was Earth, about one century into the future.  I remember vampires and a mesh of satellites around the Earth that were burning up in the atmosphere.  This motivated a mission to deep space to find the intelligence responsible for the satellites.  Most of the novel focused on the crew of the mission &mdash; I recall that they were not "standard" humans.  They had modifications to their minds and bodies, possibly for the mission.  At the time, I had gone on a binge, reading many short stories, novellas, and novels in quick succession.  I fear that I might be combining several stories into one, especially the vampires and the deep-space first-contact mission, and so I am fully prepared for an answer of the form, "No such story exists."  Any assistance would be greatly appreciated. I have a file as below:  mime PI Name: ISHO SUCCESS RATE RT, Value: 95.663826 scr  PI Name: RRC Access Failures due to UU, Value: 0.13394141 prog PI Name: RRC Access Failures due to UU, Value: 0.16077702 sch PI Name: RRC Access Failures due to UU, Value: 0.11781933   I want to remove text PI till Value:. I tried   sed '/&lt;PI&gt;/,/&lt;\/Value:&gt;/d'    Any help? Do different "Picture styles" affect RAW output? I was  the manual of my camera (Canon 50D, but I am sure that each DSLR offer the same kind of functionality, albeit I don't know the exact names adopted) and noticed the issue of Picture styles which I had overlooked in my first reading.   In short I think that they are a collection of various calibration settings (more or less enhanced colours, things like that...). Those that are available on my camera are:   Standard Portrait Landscape Neutral Faithful  Monochrome 3 user definable modes.   These styles are so important to deserve a direct button just under the LCD screen of the camera (I guess this is useful for simplifying the use of the camera in the basic modes as opposed to manual / less automated ones).  And now for the question:   These settings obviously affect the appearance of the picture "as it comes out of the camera". But given the raw file I assume that they are all equivalent, a style is not applying a destructive transformation to the raw data, isn't it?  Shooting raw, is there a reason to favor one of these styles (Neutral?) over the other? Up to now I have been using Standard.   As a bonus (don't know if it deserves a separate question, in which case I will ask it again), what is the difference between Neutral and Faithful? Include the option to flag posts as spam in the Low Quality queue I guess this is an additional to previous requests like  and .  But I just came across  review item, and was unable to flag it as spam.  edit: Since I posted this, the item has been removed (deleted) here is a screenshot: Find the area where dog can roam A dog is tied to circular pillar by a rope. Radius of this pillar is $1m$ and length of rope is $\pi m$. What is an area where dog can roam?   I tried to find the area of all semicircles and then to find its sum. It is easy to find an area at front side of the pillar. It is $\displaystyle\frac12\pi^2\pi=\frac{\pi^3}{2}$. Problem is how to find remaining area. I tried to write this area using compass and straightedge, but I couldn't. Then I wrote this in AutoCAD and it looks like this: Is it possible to find the exact value of this area? So I have these two wheels parented to the leg of a robot. I wanna make them spin a few times but they're spinning around the wrong axis. With other objects I could just press R, Y, Y to make them spin right when they're already at an angle, but for some reason it doesn't work with these. Would be amazing if someone helped me fixing this! Why did the command ":(){ :|: & };:" make my system lag so badly I had to reboot? Do not run this command to 'test' it unless you are prepared for a crash and/or force-rebooting your system.  I was in my Virtualbox running 12.04 trying to compile an app, and while waiting I happened to chance upon a forum where a comment said:   Try :(){ :|: &amp; };:  Fun, too, and doesn't need root.  Without thinking, I ran it in my gnome-terminal. It made my 12.04(in Virtualbox) lag so badly, I had to shut it down. My question is what does this command do?   :(){ :|: &amp; };: Why did Itachi poke Sasuke's forehead? From the beginning of the series, even during his last moments, Itachi poked Sasuke's forehead as a way of showing affection and apologizing.  But is that the only reason? Did he perhaps try to transfer some knowledge or memories to Sasuke? Or is it simply unknown? Show that the square of any prime number is the Factof of some integer How to check the maximum number of allowed connections to an Oracle database?