<div>
Has anyone used SQL Server Best Practices Analyzer
</div>


<div>
<div class="content wysiwyg-content">
If you have run the SQL Server Best Practices Analyzer can you let me know the following:<br />
<br />
1.Do you run it per database, or per instance.<br />
2.Do you run it per server, or the server has several instances of SQL installed, do you have to run it however many instances , i.e. once per instance<br />
3. How long roughly does it take to run the scans?<br />
4. What permissions do you need to run the scans?<br />
5. Has running a scan ever caused any issues with the instance being scanned? <br />
6. As a DBA would you recommend not running such a scan at a given time, can you provide some examples of ideal scan times, and times to avoid? <br />
7. Can you install the scanner remotely and scan it from say a PC, or does it need to be run locally on the same server as SQL Server.<br />
<br />
i'd much prefer some comments from people who have actually used the tool as opposed to being directed to MS articles...
</div>
</div>


If you have run the SQL Server Best Practices Analyzer can you let me know the following:

1.Do you run it per database, or per instance.
2.Do you run it per server, or the server has several instances of SQL installed, do you have to run it however many instances , i.e. once per instance
3. How long roughly does it take to run the scans?
4. What permissions do you need to run the scans?
5. Has running a scan ever caused any issues with the instance being scanned? 
6. As a DBA would you recommend not running such a scan at a given time, can you provide some examples of ideal scan times, and times to avoid? 
7. Can you install the scanner remotely and scan it from say a PC, or does it need to be run locally on the same server as SQL Server.

i'd much prefer some comments from people who have actually used the tool as opposed to being directed to MS articles...

Has anyone used SQL Server Best Practices Analyzer

MS SQL BPA basic questions

If you have run the SQL Server Best Practices Analyzer can you let me know the following:

1.Do you run it per database, or per instance.
2.Do you run it per server, or the server has several instances of SQL installed, do you have to run it however many instances , i.e. once per instance
3. How long roughly does it take to run the scans?
4. What permissions do you need to run the scans?
5. Has running a scan ever caused any issues with the instance being scanned? 
6. As a DBA would you recommend not running such a scan at a given time, can you provide some examples of ideal scan times, and times to avoid? 
7. Can you install the scanner remotely and scan it from say a PC, or does it need to be run locally on the same server as SQL Server.

i&amp;#39;d much prefer some comments from people who have actually used the tool as opposed to being directed to MS articles...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.