title: Missing indexes for ALL stored procs
body: <p>Is there a way to check for missing indexes for ALL of the stored procs, or am I stuck going one by one?</p>
  <p>Background,
  there has been no real DBA in the office, ever, and the database has been growing for more than 20 years.  I have been the closest thing to a DBA, and I have some skill, but it is not my first focus.</p>
  <p>Now I have been tasked with looking at the stored procs and checking indexes.  I am not even looking at optimizing or updating the stored procs, other than to bring them to a 2016 standard if needed (we did that a couple of years ago, updated the &quot;Compute&quot; and *= queries as needed).</p>
  <p>So the question is, Is there a way to check for missing indexes for ALL of the stored procs, or am I stuck going one by one?</p>