SQL-Server-First-Responder-Kit VS sql-server-maintenance-solution

I would also check that the server is configured according to best practices - DBA Dash can also help with that. I would also recommend running sp_Blitz. In terms of memory configuration, you should set the max server memory to an appropriate value.

Either sp_WhoIsActive, or you can look into First Responder Kit - https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/tree/main - specifically sp_BlitzCache stored procedure, which, by default, will list out the most CPU expensive query in SQL Server plan cache. This should help you identify the "problematic" query.

Someone mentioned Blitz scripts - these are a series of free, open source stored procedures that are simple to instal and run on your SQL instances. You can find them here (https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit) and at his website (https://www.brentozar.com/blitz). To be honest, I admire the guy and how he presents help and techniques on how to trouble shoot your SQL instance - so I would start with the sp_blitz sp, run it, follow some of the links provided in the results and start learning a few things from that.

then download this and install it on all of your servers (i recommend having your own DBA databases on each server that you stick your tools in): https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

You could use sp_ineachdb(which just uses a cursor under the hood)

SQL Server First Responder Kit, Ozar et al. The First Responder Kit is a set of stored procedures for "first responder" consultants who want to troubleshoot SQL Server problems. Coupled with the various resources at brentozar.com, the kit gives a great set of tools for performance investigations to gain a strong foothold and then make immediate progress on key issues and low-hanging fruit. The resources at the site develop a strong understanding of SQL Server internals for iterative refinement.

100% this. Separating tempdb has a huge impact, and Ola’s scripts are a must, for anyone who doesn’t know: https://ola.hallengren.com

Since you are new to SQL - https://ola.hallengren.com/ and http://whoisactive.com/downloads/ + https://www.sqlshack.com/monitoring-activities-using-sp_whoisactive-in-sql-server/ will make your SQL experience night and day. Learn these SPs/Tooling.

First, don't use maintenance plans. Full Stop. Use Ola Hallengren's Maintenance Solution or Minion Backup. dbatools even has a way to install and schedule Ola's jobs, including backups. Quick and easy.

Instead of trying to reinvent the wheel look at https://ola.hallengren.com/

Great advise. I tend to use this for SQL: https://ola.hallengren.com

Ya I use https://ola.hallengren.com for my DB maintenance. I typically have to fix existing non maintained WSUS / SUSDB Sups. I found one the other day with about 20K updates lol

Install Ola Hallengren's Maintenance Solution and schedule the Agent jobs to run the backups when you need them (and make sure you understand the difference between FULL, LOG and DIFF backups, and when you should use each). Configure it with the URL for your Azure Blob Storage. You will also need to create a Credential for SQL Server to use to authenticate to Azure Blob Storage.

SQL Server database maintenance. You don't need to be a SQL expert - just set it and forget it with this: https://ola.hallengren.com/