January 2, 2014 at 4:55 am
Looking for recommendations on a SQL Server "Inventory tool" that will identify all SQL Servers in our environment.
We have over 100 production SQL Servers (includes SQL 2000 - SQL 2012 on both VM's and phys machines) and probably close to that in dev, qa, staging, d/r as well.
Can anyone recommend a reliable tool that will inventory all our SQL servers? (free or licensed)
I see Idera's "SQL Elements" and will download their trial version to review/assess. Anybody using that? Feedback?
thx in advance!
January 2, 2014 at 5:24 am
In the free arena you might want to check out Kendal Van Dyke's Powershell scripts.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 2, 2014 at 9:05 am
Microsoft has a tool specifically designed for such a purpose, called the Microsoft Assessment and Planning (MAP) toolkit. It scans and detects all installs it can see (i.e. if you were to hide one in the DMZ it might not find it).
Instructions are listed below:
Oh - by the way - this one's free as well.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 3, 2014 at 12:04 pm
Quest Discovery Wizard for SQL Server
January 3, 2014 at 3:47 pm
I have a simple vb script based around
Set objSQLDMOApp = CreateObject("SQLDMO.Application")
Set objSQLList = objSQLDMOApp.ListAvailableSQLServers()
Once I had a list of all the servers I created a 'Central Management Server', in management studio. It allows me to organize, query them all, set policies over them and allows other members of the team to work with the exact same set of servers.
More info http://technet.microsoft.com/en-us/library/bb934126.aspx
January 3, 2014 at 7:15 pm
All - thx for this terrific feedback. Plenty to work with.
August 4, 2016 at 2:00 am
disclaimer: I work for the company behind SQLDocKit
We have developed a tool that will help you with that https://www.sqldockit.com
To differentiate from other vendors we have built snapshots and compare technology (ability to compare any setting of the server that you have today and how it was configured for example 2 months before, so you can see the differences, and you can compare two different SQL servers so you can find differences in the configuration) and Best Practices that checks your SQL server configuration with the best practices Microsoft recommends and explains to your what you need to change on your SQL.
June 19, 2018 at 10:40 am
frane.borozan - Thursday, August 4, 2016 2:00 AMdisclaimer: I work for the company behind SQLDocKitWe have developed a tool that will help you with that https://www.sqldockit.comTo differentiate from other vendors we have built snapshots and compare technology (ability to compare any setting of the server that you have today and how it was configured for example 2 months before, so you can see the differences, and you can compare two different SQL servers so you can find differences in the configuration) and Best Practices that checks your SQL server configuration with the best practices Microsoft recommends and explains to your what you need to change on your SQL.
I'm currently looking for a good replacement for SQLDocKit (aka SysKit SQL Manager). RedGate bought this awesome tool, removed the contractor license model, renamed it (SQL Estate Manager), packaged it with some unrelated & equally expensive tools, and increased the price by anywhere between 700-2500%. Look at IDERA's free "SQL Instance Check" tool for SQL Server discovery, it works fairly well (although not great for cloud discovery).
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply