Solved

MS SQL BPA basic questions

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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
Viewers will learn how the fundamental information of how to create a table.

734 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