[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS SQL BPA basic questions

Posted on 2013-05-10
2
Medium Priority
?
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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
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.

656 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