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 ?
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, ...).
so you will use a lot of other tools for that?
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 ?
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.
I think I already sent you the Hong Kong link for BMC Patrol.
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.
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy 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.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
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