Do you know where bottlenecks can happen?
  v2.0 Posted at 28/08/2019 4:13 AM by Tiago Araujo

For modern applications, there are many layers and moving parts that need to seamlessly work together to deliver our application to the end user. 

Figure: Bottlenecks can happen anywhere! Call out diagrammatically where you think the bottlenecks are happenning

The issues can be in:

SQL Server

  • Slow queries 
  • Timeouts
  • Bad configuration 
  • Bad query plans 
  • Lack of resources 
  • Locking

Business Logic

  • Inefficient code 
  • Chatty code 
  • Long running processes 
  • Not making use of multicore processors

Front end

  • Too many requests to server a page 
  • Page size
  • Large images
  • No Caching

Connection between SQL and Web

  • Lack of bandwidth
  • Too much chatter

Connection between Web and Internet

  • Poor uplink (e.g. 1mbps uploads)
  • Too many hops

Connection between Web and End users

  • Geographic​ally too far (e.g. US servers, AU users)


  • Misconfiguration
  • ​Resource contention

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: