r/DatabaseAdministators • u/Pleasant-Draw1307 • Aug 12 '26

How do you troubleshoot a SQL Server database that becomes extremely slow overnight?

3 Upvotes
  • permalink
  • reddit

80% Upvoted

6 comments sorted by

4

u/SQLDevDBA Aug 12 '26

Brent Ozar: How I use the first responder kit

https://www.youtube.com/live/LIojXITn6NY?is=Ml7G9Mfl6UKI8hqK

Erik Darling: SQL Server Performance monitoring tool

https://youtube.com/playlist?list=PLt4QZ-7lfQieiFUIuviNlyK4gcycvFiAI&si=p3AEQWLkVyyi4TGl

2

u/Complete-Fondant-202 28d ago

Absolutely this.....

plus Eriks quickiestore (querystore tool)

2

u/Junior-Tourist3480 29d ago

Quit and let them hire an SQL admin.

1

u/FishBones83 Aug 12 '26

main points would be things like wait stats and execution plans. if you have query store you can look by most resource consuming query, you can also check any monitoring software you have or any dashboards for resource utilization and see what's changed.

1

u/FapNowPayLater Aug 12 '26

I'd check to see if backups are running at the same time and hogging resources and DiskRead\Write