Solved

MS SQL BPA basic questions

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

943 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

10 Experts available now in Live!

Get 1:1 Help Now