Solved

MS SQL BPA basic questions

Posted on 2013-05-10
2
292 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

757 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now