Larger IT organizations are likely to have a proliferation of SQL Server installations that are not fully known to the internal IT department. Furthermore, some of these installations may be in various stages of repair because they are not managed systematically. If these unsupervised SQL databases carry business-critical or sensitive information without backup or control, this can be problematic for the organization.
The MAP Toolkit helps you create an inventory of all the SQL Server installations in the network, complete with component and version information. This information can help you consider the value of consolidating, possibly virtualizing, certain databases, and bringing them under IT supervision when appropriate.
To do so , follow below steps which will guide you through this.
Select an account that have administrative permission on the targeted servers, you can add more than one account , and the MAP tool will try to login to servers using all the accounts sequentially until it succeed to login
select all the SQL servers to participate in the analysis
Though it runs a different thread where you can continue using the tool simultaneously but for SQL MAP you have to wait until this (collecting counters) are completely finished.
Now collect performance Data step is done.
Important: I will show in a later step where to find and how to read all the reports generated by our assessment.
After completing all previous steps , its now time to generate the reports :
Or there is another way to generate all reports of your selection :
Note: Reports and proposals are created in folders named after the database currently in use.
Clear & Nice Article..
Do we have any option to schedule this process which could run and collect performance report on hourly basis and give a detailed report by EOD.