Monitoring SQL 2016 on-premise for performance and stability
Enterprise Database Administration & Deployment
You have an on-premise instance of SQL 2016 but what-if performance sucks every now and again
Have you looked in the plan cache?
What to look for in saved plans
Keep you plan cache trim
Are your indexes being used as you expect?
Do you have table/index hot-spots?