title: SQL Server LCK_M_S only happens in production
body: <p>I have a stored procedure that is called by a SQL Server 2012 report that is taking an age to run in production compared to development because of a blocking session <code>lck_m_s</code></p>
  
  <p>The stored procedure runs instantaneously when executed in SQL Server Management Studio and also works well when called as part of the report from a dev laptop via Visual Studio.</p>
  
  <p>When the report is uploaded to the production server this blocking issue appears.</p>
  
  <p>How can I find out what is causing the <code>lck_m_s</code> issue when in production?</p>