• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 491
  • Last Modified:

MAP tool for SQL Server

Has anyone ever run this tool:

http://technet.microsoft.com/en-us/solutionaccelerators/dd537572.aspx

Over your environment? And if so how long did it take to produce the reports/were they accurate? Did it cause any performance impact?

I dont have a production environment to test it on at present so could do with anyone with experience of the tool assisting?
0
pma111
Asked:
pma111
2 Solutions
 
Mark WillsTopic AdvisorCommented:
They have the "Training Toolkit" and that will likely answer some of your questions, and the Wiki Articles (http://social.technet.microsoft.com/wiki/contents/articles/1640.microsoft-assessment-and-planning-toolkit.aspx) looks pretty comprehensive along with TechNet : http://technet.microsoft.com/library/bb977556.aspx 

But, no, I haven't used their latest version in a live environment.

I had tried one of the earlier versions, and cancelled some of the tests because it was taking a while on a fairly simple test environment, and never really revisited...

Will be interesting to see other experts experiences... and if you continue, would like to hear about your own experiences (maybe write an article ?)

Cheers,
Mark
0
 
Ryan McCauleyData and Analytics ManagerCommented:
We've used it in a live environment, and it doesn't cause any performance issues at all. It effectively scans the network for SQL Servers, and when it finds one it can log into, it connects and gathers some basic info (version, edition, windows info, proc count, database size, etc) and that's it. It's not intensive at all when it works, and it's really straight-forward to use.

I've only used it against our SQL Server deployment to ensure we're licensed properly, and haven't used any of the Oracle or "migration" features, but I'd expect those to be pretty lightweight as well.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now