SQL Server Discovery Wizard
Story by Server Management, 31-05-2009, 0 comment
It sometimes feels as though SQL Server instances are like weeds. They seem to pop up where you least expect them, in areas you just cleared out and were sure were clean. The problem is there are just too many applications that install their own instance of SQL Server without so much as a by-your-leave - accountancy software, management packages, anything that needs to store data seems to think it's OK to add an instance to your network.
What this means is that it's difficult to know how many SQL Servers are deployed, how many are running mission-critical versus non-critical applications, where are they located, and whether any are candidates for consolidation.
Quest Discovery Wizard is a free graphical utility that lets you to detect SQL Server instances and monitor the current network for changes. It has a number of discovery methods which help you to reveal even those SQL Server instances which cannot be detected using the native tools.
You can
- Find how many databases there are and how much data is there
- Determine databases that are good candidates for consolidation
- See history of these databases including when created and installed
- Learn what versions of SQL Server are deployed and what their service packs are
- Understand server names, instance names and operating systems
- See who the end users are
The software gives you a choice of four different methods to discover the instances - network registry connection, WMI connection, SQL Server login, or general TCP connect. When an instance is detected, the information gathered from it is stored and available for you to view. You can see the servers' instance names, domain affiliations, IP addresses, and running port, along with the version, build, and operating system for the instance.
Once you have a list of instances, you can set the utility to run automatically on a schedule, then view the changed, new and lost instances from the previous scan.
The utility is currently in beta and can be downloaded from the Quest website.
Sign up to receive the latest news and updates from Server-Management via email.
DrayTek Vigor 2820 router
LaCie 5big Network NAS
Network Monitor Tutorial
Dell Latitude E6400
ZyXEL P660HN-F1Z
MSI Wind X600
Exchange Log Analyzer
Edimax IC-7000PTn Network Camera
Lab: multifunction printers
- Posted:
- 2010-03-11
- Location:
- City of London, London
- Salary range:
- 1 - 35000
- Salary period:
- year
Description:
Part time IT Trainer – 3 days – Up to £35,000 pro rota Training Needs Analysis, User Guides, Documentation, Developing & coaching delegates, City of London My client is based in the City of London and looking for a proactive IT Trainer with excellent interperso... read more
- Posted:
- 2010-03-11
- Location:
- West Midlands, West Midlands
- Salary range:
- 55000 - 60000
- Salary period:
- year
Description:
Head of Data - SQL/Data-warehouse/Data-modelling/Strategy - Industry Leader - West Midlands Data Manager/Head of Data/Data Strategy Manager/Head of BI As part of my well known client's ongoing IT strategy, they are in urgent need of an experienced Head of Data to make a real impact in the ... read more
- Posted:
- 2010-03-11
- Location:
- Reading, Berkshire
- Salary range:
- 20000 - 25000
- Salary period:
- year
Description:
This is a fantastic job opportunity for a keen IT person, who has a massive interest in computers and building a career within this sphere. My client a well known IT Reseller based in Reading is seeking to recruit a Technical Presales Consultant. You do not have to be qualified as my client is l... read more
- Posted:
- 2010-03-11
- Location:
- Sheffield, South Yorkshire
- Salary range:
- 20000 - 25000
- Salary period:
- year
Description:
IT Technician (Legal) Sheffield £20-25k The Job Role: We are looking for a network administrator who will be able to maintain and support the systems our client has in place providing services to their team. The Systems Administration Team will be responsible for building, supporting ... read more
- Posted:
- 2010-03-11
- Location:
- Cambridgeshire, Cambridgeshire
- Salary range:
- 35000 - 40000
- Salary period:
- year
Description:
My client, a specialist consultancy, are looking for a senior Infrastructure Consultant. You will be the sole owner of the companies infrastructure so must have solid Windows Server experienced including Active Directory coupled with excellent IIS Administration experience.Ideally you will have ... read more