I am running SQL Server on Windows 2008 R2 Standard 64x With 8GB Ram and 2 Xeon Quad Core processors Running at 2.8Ghz. I have SQL Server Version is 10.0.2531. I ahve two boxes of this spec and have databases configured for mirroring.
This runs the backend database for our website. Recently we ahve seen a massive increase in the amount of pages that are timing our on IIS whenever a call to the database is made.
I have no experience of performance monitoring SQL Server and need to understand and address what is causing these time outs.
It may be that I just need to buy more RAM for the server but I want to know if that is going to fix the problem before I just buy it.
The sqlserver.exe process is running at 6.2Gb and the configured and running values are Min 0Mb and Max Server Memory 6656MB.
I have attached a screenshot of the Activity monitor. Not sure if that helps.
Thanks in advance.