Topic: MS SQLSERVER occupies almost 100 % of resources
Greetings, the people!
At me a problem with MS SQLSERVER on the server.
Server options of 2 kernels, 4 the RAM. Server 2009 R2 SP1, SqlServer 2012
It is necessary SQlServer, even the antivirus is not present.
RECORD on SQLSERVER happens in the core through a desktop-appendix, and reports users receives through our site.
Apparently on screenshot SQLSERVER occupies almost 3 the RAM and almost 100 % of resources. At this time was active about 100 users of reading-record on SQLSERVER.
I wanted to learn, it is correct, what with 100 active users SQLSERVER so occupies resources?
Soon at us will more than 500 active users, servers (or the selected server) you could recommend what configuration?
In advance thanks.