How to evaluate a database

[hayes504]

A user has requested a report to shed some light on what is happening in the databases on a sql server in order to determine what is causing slow processing time. We need to evaluate databases on a server. Looking for possible errors corruption, table issues etc.  Any help on scripts that I can run or tools would be appreciated.

[#2]

Take a look at our (free) 4 Steps to Faster SQL Server Applications short course. It should help you start: https://sqldownunder.com/training

[#3]

Hi @GregLow 

You are welcome to share the free course in the SQL Server 2022 group on Facebook 

Please do not use it for the paid course or to self-promotion.
https://www.facebook.com/groups/SQLServer.AzureSQLDBandMI

[#4]

Seems sad, given it's both free and covers exactly what he's asking about. But ok, works for me.

[#5]

Sry @GregLow , I did not understand you. What is sad?

Do you mean something I said? I said that you can publish it in another place (since it is free). In any case, you are right and this answer the question, which is why I marked "like" to your answer 

So everything should be "happy" and no "sad" 

Off-topic: congrats on the green circle!

[#6]

Hi DeAndra Hayes and welcome to the techCommunity forums

You can start with sp_Blitz, Free SQL Server Health Check Script written by Brent Ozar.
Check this tutorial and download the script here:
https://www.brentozar.com/blitz/
https://www.brentozar.com/first-aid/

[#7]

Hi Ronen, sorry, I thought you meant I couldn't mention it here but to mention it there instead. I didn't understand why. But now it makes sense thanks.