How to evaluate a database

%3CLINGO-SUB%20id%3D%22lingo-sub-3352447%22%20slang%3D%22en-US%22%3EHow%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3352447%22%20slang%3D%22en-US%22%3E%3CP%3EA%20user%20has%20requested%20a%20report%20to%20shed%20some%20light%20on%20what%20is%20happening%20in%20the%20databases%20on%20a%20sql%20server%20in%20order%20to%20determine%20what%20is%20causing%20slow%20processing%20time.%20We%20need%20to%20evaluate%20databases%20on%20a%20server.%20Looking%20for%20possible%20errors%20corruption%2C%20table%20issues%20etc.%26nbsp%3B%20Any%20help%20on%20scripts%20that%20I%20can%20run%20or%20tools%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3436801%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3436801%22%20slang%3D%22en-US%22%3ETake%20a%20look%20at%20our%20(free)%204%20Steps%20to%20Faster%20SQL%20Server%20Applications%20short%20course.%20It%20should%20help%20you%20start%3A%20%3CA%20href%3D%22https%3A%2F%2Fsqldownunder.com%2Ftraining%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsqldownunder.com%2Ftraining%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3443890%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3443890%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056281%22%20target%3D%22_blank%22%3E%40GregLow-MVP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome%20to%20share%20%3CU%3E%3CSTRONG%3Ethe%20free%3C%2FSTRONG%3E%3C%2FU%3E%20course%20in%20the%20SQL%20Server%202022%20group%20on%20Facebook%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%0A%3CP%3EPlease%20do%20not%20use%20it%20for%20the%20paid%20course%20or%20to%20self-promotion.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fgroups%2FSQLServer.AzureSQLDBandMI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.facebook.com%2Fgroups%2FSQLServer.AzureSQLDBandMI%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3443968%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3443968%22%20slang%3D%22en-US%22%3ESeems%20sad%2C%20given%20it's%20both%20free%20and%20covers%20exactly%20what%20he's%20asking%20about.%20But%20ok%2C%20works%20for%20me.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3468576%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3468576%22%20slang%3D%22en-US%22%3E%3CP%3ESry%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056281%22%20target%3D%22_blank%22%3E%40GregLow%3C%2FA%3E%26nbsp%3B%2C%20I%20did%20not%20understand%20you.%20What%20is%20sad%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20something%20I%20said%3F%20I%20said%20that%20you%20%3CU%3E%3CSTRONG%3Ecan%3C%2FSTRONG%3E%3C%2FU%3E%20publish%20it%20in%20another%20place%20(since%20it%20is%20free).%20In%20any%20case%2C%20you%20are%20right%20and%20%3CU%3Ethis%20answer%20the%20question%3C%2FU%3E%2C%20which%20is%20why%20%3CU%3EI%20marked%20%22like%22%20to%20your%20answer%3C%2FU%3E%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%0A%3CP%3ESo%20everything%20should%20be%20%22happy%22%20and%20no%20%22sad%22%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%400277EEB71C55CDE7DB26DB254BF2F52B%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOff-topic%3A%20congrats%20on%20the%20green%20circle!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3468582%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3468582%22%20slang%3D%22en-US%22%3EHi%20DeAndra%20Hayes%20and%20welcome%20to%20the%20techCommunity%20forums%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20start%20with%20sp_Blitz%2C%20Free%20SQL%20Server%20Health%20Check%20Script%20written%20by%20Brent%20Ozar.%3CBR%20%2F%3ECheck%20this%20tutorial%20and%20download%20the%20script%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.brentozar.com%2Fblitz%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.brentozar.com%2Fblitz%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.brentozar.com%2Ffirst-aid%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.brentozar.com%2Ffirst-aid%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3468621%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20evaluate%20a%20database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3468621%22%20slang%3D%22en-US%22%3EHi%20Ronen%2C%20sorry%2C%20I%20thought%20you%20meant%20I%20couldn't%20mention%20it%20here%20but%20to%20mention%20it%20there%20instead.%20I%20didn't%20understand%20why.%20But%20now%20it%20makes%20sense%20thanks.%3C%2FLINGO-BODY%3E
Occasional Visitor

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: https://sqldownunder.com/training

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.
https://www.facebook.com/groups/SQLServer.AzureSQLDBandMI

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:
https://www.brentozar.com/blitz/
https://www.brentozar.com/first-aid/
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.