Solved

MS SQL BPA basic questions

Posted on 2013-05-10
2
299 Views
Last Modified: 2013-05-15
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...
0
Comment
Question by:pma111
2 Comments
 
LVL 3

Author Comment

by:pma111
ID: 39164379
Has anyone used SQL Server Best Practices Analyzer
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 39167195
Yes I have used it. I Believe it was like this:

1 = INSTANCE
2 = PER INSTANCE
3 = Dont remember, it was just a couple of minutes if Im not mistaken
4 = Not sure, Belive it is View Server State on the SQL, and rights to read logs, registry, WMI  and errorlogs.
5 = No, have run it on ca 20 instances all in all
6 = I ALWAYS prefere on a maintenance hole. Off hours (if possible), not while doing maintenance.
7 = I used it remotely. I NEVER install any tools on my precious SQL Servers, so Im 100% sure about this. If I remember correctly it needs PowerShell 2.0

Meant to reply from office, right after I done a BPA, but my kids been sick for a while.
Now I saw you bumbing your thread, and a reply is better than none in my opinion.

Regards Marten
PS I would run it on test system first to get familiare with it.

Oh, did a search and found a short demovideo from MS where BPA for SQL Server is shown:
http://www.youtube.com/watch?v=xU29PXeceD0
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question