title: Optimize Performance of SQL Server (a lot of waiting tasks)
body: <p>I have a problem with my database (Microsoft SQL Server), we have a lot of users using our API and this API makes a lot of queries to our database (it is normal because we are saving tracking data), we are using a load balancer for our API so we can handle a lot of requests but this gave us the problem that is that in the morning everything works ok but when the day is passing everything goes very slow, I reviewed the activity monitor (i am not a DBA but the team does not have one) and I noticed that when it goes slow is when waiting tasks are increasing, it is always bigger than 500 (the waiting tasks are always around 500-800), as a result of this I talked with my manager that also is not technical and we rented a server that only will run the database, these are the specs:</p>
  <p>Specs of server:</p>
  <ul>
  <li>128 ram,16 vcpus</li>
  </ul>
  <p><a href="https://i.stack.imgur.com/WrUyN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WrUyN.png" alt="Server specs" /></a></p>
  <p>But the problem is the same:</p>
  <p><a href="https://i.stack.imgur.com/oMTm2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oMTm2.png" alt="Actvity monitor of database" /></a></p>
  <p><strong>I looked at the task manager and I noticed that is not even using 100% of ram or cpu:</strong>
  <a href="https://i.stack.imgur.com/2Hna2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2Hna2.png" alt="task manager" /></a></p>
  <p>so I want that an expert can recommend me what to do because I have the hardware and it is not improving :(, thanks in advance.</p>
  <p>Some relevant info:</p>
  <ul>
  <li><p>Our API is using entity framework, I heard that using ADO.NET can improve this, is it true?</p>
  </li>
  <li><p>Buying an azure SQL database tier Business-critical can solve our problem?</p>
  </li>
  <li><p>We have de SQL Standard edition</p>
  </li>
  <li><p>Properties of SQL INSTANCE:</p>
  </li>
  </ul>
  <p><a href="https://i.stack.imgur.com/sIFtD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sIFtD.png" alt="properties" /></a>
  <a href="https://i.stack.imgur.com/bX44y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bX44y.png" alt="Memory" /></a>
  <a href="https://i.stack.imgur.com/ve792.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ve792.png" alt="Processors" /></a>
  <a href="https://i.stack.imgur.com/u52DD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/u52DD.png" alt="Connections" /></a>
  <a href="https://i.stack.imgur.com/37C4p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/37C4p.png" alt="Advance" /></a></p>