Avatar of marrowyung
marrowyung
 asked on

tools to scan a SQL server's problem

hi,

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 ?
Microsoft SQL Server

Avatar of undefined
Last Comment
marrowyung

8/22/2022 - Mon
marrowyung

ASKER
is it the Microsoft® SQL Server® 2012 Best Practices Analyzer ? but it don't scan potential SQL server performance related problem ?
Vitor Montalvão

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, ...).
marrowyung

ASKER
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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Vitor Montalvão

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

ASKER
"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 ?
ASKER CERTIFIED SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
marrowyung

ASKER
"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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

No. I'm so used to Microsoft that I don't use 3rd party tools.
marrowyung

ASKER
this one:
SentryOne, very good tools.
Vitor Montalvão

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
marrowyung

ASKER
ok. good ! what is the strength of Patrol let you keep using that ?
Vitor Montalvão

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

ASKER
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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
marrowyung

ASKER
tks anyway.