We help IT Professionals succeed at work.

tools to scan a SQL server's problem

marrowyung
marrowyung asked
on
111 Views
Last Modified: 2018-03-21
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 ?
Comment
Watch Question

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ãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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?
Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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 ?
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
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ãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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ãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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ãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions