tools to scan a SQL server's problem


I can't recall what is the name of the tools that when first assess the SQL server we can see the existing potential SQL serve problem. this can be a a quick report on what is happening and what's wrong with a SQL server 2012

what is the tools ?
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

marrowyungSenior Technical architecture (Data)Author Commented:
is it the Microsoft® SQL Server® 2012 Best Practices Analyzer ? but it don't scan potential SQL server performance related problem ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
BPA is a tool to check about the configuration of the SQL Server instance. It also says when was performed last backups of the database and if you're using deprecated features.
Don't expect something to check for performance issues. This kind of stuffs needs to be checked by DBAs with the help of some tools and features (DMV, Profiler, Extended Events, Performance Monitor, 3rd party software, ...).
marrowyungSenior Technical architecture (Data)Author Commented:
so when you check SQL server issue with customer, you never do this, right?

so you will use a lot of other tools for that?
CEOs need to know what they should worry about

Nearly every week during the past few years has featured a headline about the latest data breach, malware attack, ransomware demand, or unrecoverable corporate data loss. Those stories are frequently followed by news that the CEOs at those companies were forced to resign.

Vitor MontalvãoMSSQL Senior EngineerCommented:
I mostly work with monitoring tools like SCOM or BMC Patrol. Usually they have all the information that I need for troubleshooting.
Adding more tools and components is worthless as it's only take resources.
marrowyungSenior Technical architecture (Data)Author Commented:
"Adding more tools and components is worthless as it's only take resources."

I think the point is,  I need the right tools to check. so BPA is not by this point, agree ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I like BPA but isn't a daily tool usage. It's something that you should run at least once by year to check if your SQL Server instances are configured and running as expected.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
"I like BPA but isn't a daily tool usage."

 I think we have to run it for customer too, I am now just by eyes, not very robust, general suggestion is easy but I think I need more.

did you use a tools like SentryOne? it is a good tools, Idera DM, I gave 50/100, idea is good but far from working well/expected.
Vitor MontalvãoMSSQL Senior EngineerCommented:
No. I'm so used to Microsoft that I don't use 3rd party tools.
marrowyungSenior Technical architecture (Data)Author Commented:
this one:
SentryOne, very good tools.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Mind that I don't choose the monitoring tools for my clients. That's not my area. For now my experience is only with SCOM and BMC Patrol and I'm quite happy with them.
marrowyungSenior Technical architecture (Data)Author Commented:
ok. good ! what is the strength of Patrol let you keep using that ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not a Patrol specialist. I just talk with the monitoring team and tell them what I want to be monitored.
I think I already sent you the Hong Kong link for BMC Patrol.
marrowyungSenior Technical architecture (Data)Author Commented:
ahahaah, I think you know Patrol in detail. it seems we need to suggest customer a tools, what I am experiencing is, they seems very urgent to know what is going on insider the SQL server box, good or not good.'

actually  I prefer Idera DM  sentryone, include infrastructure + development code monitoring.  but Idera DM has a lot of feature problem in the recent build that development don't even know.
marrowyungSenior Technical architecture (Data)Author Commented:
tks anyway.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.