Sql Server usage is 100% when running MVC 4 application with DB Context with EF 6 ?

Question

1.00/5 (1 vote)

See more:

Sql Server usage is 100% when running MVC 4 application by DB Context with EF 6 ?

it slows down server performance heavily. and data submission is very fast something about 2000 per 2-5 minute.....?

Please tell me solution, its urgent ??????????????????

Posted 30-May-14 20:09pm

Gaurav Gupta A Tech Guy

Add a Solution

Comments

Kornfeld Eliyahu Peter 2-Jun-14 7:00am

Did you asked your DBA about the SQL installation?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Muli G. · Answer 1 · 2014-06-02T00:42:00

XML

SQL server overrides the CPU and memory distribution of the OS
therefore if you check the task manager it will look like it takes all the CPU and memory.
In case the the DB server is the same as the Application server, maybe you can try to reduce the cpu usage by SQL server using the resource governor, you can find more information about the governor here (<a href="http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Resource%20Governor%20in%20SQL%20Server%202012.docx">http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Resource%20Governor%20in%20SQL%20Server%202012.docx</a>[<a href="http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Resource%20Governor%20in%20SQL%20Server%202012.docx" target="_blank" title="New Window">^</a>])

However if the CPU is 100% due to cpu bottleneck reducing the cpu usage will slow down sql server.

Good luck :)