SQL DB scan tools and performance monitoring

Hi all,

Im looking for two tools, one that can scan my domain for all SQL instances giving me basic info regarding SQL instances and DBs, and the other is SQL tool that will report of SQL performance. Preferably free.

Thanks
MJB2011Asked:
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.

bbaoIT ConsultantCommented:
1. for SQL instance discovery, the most common tool is SQL PIng, which is lightweight and able to use multiple discovery methods to scan SQL instances.

SQL Ping is available at http://www.sqlsecurity.com/downloads

2. for SQL performance monitoring, there are two levels: system level and application level, depending your role and development requirement. for system level, the most common tool is Performance Monitor, which is Windows built-in and comprehensive. for application optimisation, SQL Profiler is the first choice as it is integrated with SQL server and easy to use.

FYI -

Windows Performance Monitor
https://technet.microsoft.com/en-au/library/cc749249.aspx

SQL Server Profiler
https://technet.microsoft.com/en-us/library/ms173799(v=sql.110).aspx
David ToddSenior Database AdministratorCommented:
Hi,

For perfomon counters see this post by Brent Ozar:
https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

HTH
  David

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
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 2008

From novice to tech pro — start learning today.