How to evaluate a database

Copper Contributor

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.

6 Replies
Take a look at our (free) 4 Steps to Faster SQL Server Applications short course. It should help you start:

Hi @GregLow 

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

Please do not use it for the paid course or to self-promotion.

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

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 :smile:

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


Off-topic: congrats on the green circle!

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:
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.