title: IIS Server and Azure Server hang due to SQL CPU and memory high utilization and not able to process the request further
body: <p>I have a services hosted on IIS port for submit some information and when it is calling by thousand of users using mobile app on same time, Server is going to stuck and not able to response for the request.
  At this time I observe in task manager that SQL took high utilization and memory approx. 70-75 % CPU and memory .
  Due to this we need to restart the SQL server daily in morning and evening .(I know this is bad idea for performance and statistics but server hang up)</p>
  <p>I have made the API using .NET framework and SQL server 2012.</p>
  <p>Any idea what i can do to handle this issue?</p>
  <p><a href="https://i.stack.imgur.com/HjBZV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HjBZV.jpg" alt="IIS Worker processer image" /></a></p>
  <p><a href="https://i.stack.imgur.com/wurCP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wurCP.jpg" alt="Task manager image" /></a></p>