SQL DB scan tools and performance monitoring

MJB2011
MJB2011 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
bbaoIT Consultant
Commented:
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
Senior Database Administrator
Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial