The instaDBA Data Collection tool (IDC) will baseline your SQL server.
It can be downloaded via the button below.
<instaDBA tool no longer available for download>
Instructions:
Once you have downloaded instaDBA_Setup.exe, double click it to extract the files and run instaDBAIDC.exe to start data collection.
When data collection is complete you will be prompted to upload your files to our servers for analysis.
idc
FAQ:
Q: What does a baseline cost and how do I pay?
A: The baseline can be purchased here
Q: Why do I need to run this on my server?
A: By using our baseline tool we save time and you don’t need to give us permissions to log on to your SQL Server. Doing a SQL Server review or taking a proper baseline can be very time consuming. Performance monitor has to be set up to collect the appropriate counters, SQL Profiler needs to be set up to capture the relevant events, and various diagnostic SQL queries need to be run on the SQL Server DMVs. When the monitoring is complete, all the information needs to be uploaded to our server for analysis. The complete process takes about 2 hours if done manually.
Q: What are the instructions?
A: Once you have downloaded instaDBA_Setup.exe, double click it to extract the files and run instaDBAIDC.exe to start data collection.
When data collection is complete you will be prompted to upload your files to our servers for analysis.
Q: Do I need to run the tool with an account that has administrator permissions?
A: Yes, you must run the tool with an account that has both windows administrator and SQL Server SYSADMIN permissions.
Q: How long should I run the data collection tool?
A: It should be run from 30 minutes to 6 hrs. If you are interested in identifying specific performance problems it is important that you run it while the problem is happening or while the server is experiencing normal use.
Q: Where should the data collection files be put?
A: Ideally, the files should be located on a disk that is not shared with your database data or transaction log files. The disk should also have at least 20GB of space available. The IDC is configured to stop collecting data when a disk has less than 10% free space.
Q: Will any confidential data be collected from my server?
A: Absolutely not! we do not collect data from your user databases. The only data we collect is configuration and performance data. We do collect security data in order to identify security vulnerabilities but passwords and logins are not collected.
Q: Will this tool install software on my server?
A: No, the tool consists of a lightweight executable that runs diagnostics tools that are already installed on every SQL Server out of the box.
Q: Are there any pre-requisites to using the tool?
A: You may need to install .NET Framework 3.5 if you are using Windows Server 2003/2008. It can be downloaded here
If you have any questions, please contact Us.