1

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.
Problem:
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.

2

Re: MS SQLSERVER occupies almost 100 % of resources

umrbek79 wrote:

Soon at us will more than 500 active users,  servers (or the selected server) you could recommend what configuration?

Formulas such are not present, the general what are necessary resources for 100 (500) users. It is possible to load also one user a superserver on 100 %
Determination of minimum/optimum configurations of iron (resources) - business of suppliers of a software. Well or commands DBA, after careful learning of system operation.
Still it is possible to tell that 2 kernels and 4  the RAM are a little for typical OLTP systems with 100 actively operating users. But, I will repeat, all depends on system.

3

Re: MS SQLSERVER occupies almost 100 % of resources

Thanks for answers.
I will try to explain server operation.
On the server there is a database of pupils. Client the software sends the data of attendance of pupils for a day.
The table of attendance the small it is finite, there only the code of the pupil and time of visiting of occupations. The attendance table goes on the server by means of function SQLBULKCOPY.
Such educational institutions, i.e. clients of the server nearby 500 (will be even more).
On a site by means of SQL requests there are reports and percent of attendance on each educational institution are calculated. Any user can come on a site and look at the report.
Thus, to the server it is necessary to guess an amount of simultaneous connections only...
I still the beginner on operation with MS SQL the server. I had a question: all forums speak about an indexing. At me all tables are not indexed. I am afraid, it can influences productivity of the server?
[quote = "Usaga; 9907942"] Can all triggers it is covered, and all requests look like "SELECT * FROM" + millions "JOIN".

Triggers are not present, I do not know that such the trigger wink
And about requests, "select *" I avoid, and JOIN  there a little, i.e. "++++" here somehow so...
[quote = "Hikari; 9909562"] If to disconnect all clients - the server will eat so much?
Client the software cannot plunge its abyss of "diligence"?

If to disconnect all clients - the server generally eats nothing.
One client connection with  SQLBULKCOPY forces to work the server on 15-20 % of resources, but it only when the request is active.
[quote = "m0nax; 9909519"] if any w3wp.exe too wants storage there fight begins and as a result all participants roll down in a swap, load a disk, requests

hang
And happens, . the client sends the data on the server (function SQLBULKCOPY if did not forget), the program writes that successfully sent on the server. I on the server send request with . Result: records are not added!
What can advise?