Question about BPA

Is it possible to use the Best Practice Analizer on a remote DB? I mean a DB
hosted in a hosting company?
Kenny M.
I believe as long as you can point it to the server you are all set. Have
you tried it?
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:D307CAF6-7126-497E-8421-CB5C13BB2E4A@.microsoft.com...
> Is it possible to use the Best Practice Analizer on a remote DB? I mean a
> DB
> hosted in a hosting company?
> --
> Kenny M.
|||umm well I did not ask very well, I already made login into the remote DB, my
question is how to specify my instance?
BPA has an input field: SQLServerinstance: 98.00.88.00
the login is OK but there are many DB on the server(it is a hosting server)
and I want to use only my instance.
I don't know how to specify it.
Kenny M.
"Andrew J. Kelly" wrote:

> I believe as long as you can point it to the server you are all set. Have
> you tried it?
> --
> Andrew J. Kelly SQL MVP
>
> "Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
> news:D307CAF6-7126-497E-8421-CB5C13BB2E4A@.microsoft.com...
>
>
|||OK I see now. Sorry about the confusion. Unfortunately I do not know that
answer as I no longer have that tool installed. I thought there was a way
to specify a particular db but I can't confirm that one way or another.
Hopefully someone else will reply that does have the tool installed.
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:82637589-85C7-4B5B-AFDC-57620DBF1F89@.microsoft.com...[vbcol=seagreen]
> umm well I did not ask very well, I already made login into the remote DB,
> my
> question is how to specify my instance?
> BPA has an input field: SQLServerinstance: 98.00.88.00
> the login is OK but there are many DB on the server(it is a hosting
> server)
> and I want to use only my instance.
> I don't know how to specify it.
>
> --
> Kenny M.
>
> "Andrew J. Kelly" wrote:
|||Kenny M. (KennyM@.discussions.microsoft.com) writes:
> umm well I did not ask very well, I already made login into the remote
> DB, my question is how to specify my instance?
> BPA has an input field: SQLServerinstance: 98.00.88.00 the login is OK
> but there are many DB on the server(it is a hosting server) and I want
> to use only my instance.
OK. Normally "instance" in the context of SQL Server means a whole instance
of SQL Server with master, tempdb, model, msdb and a whole lot of user
databases. One machine can have several instance of SQL Server.

> I don't know how to specify it.
When you add a Server, there is an entry field "Database list" where you
can enter the database that are of interest to you. By default the value
is * for all databases.
Whether you actually will be able to run BPA, I don't know. Some tests are
on server-level and requires sysadmin access (I would suppose). Then again,
I would expect to be able to access a database for which I am the DB ovner.)
I should add that I believe that I have a pre-release version of BPA, so
the final interface may look different.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||mell at this point I'm almost sure that it is not possible, I'm creating the
BPA repository on my local local machine but I can not analyze a my remote db
located in a hosting
Kenny M.
"Erland Sommarskog" wrote:

> Kenny M. (KennyM@.discussions.microsoft.com) writes:
> OK. Normally "instance" in the context of SQL Server means a whole instance
> of SQL Server with master, tempdb, model, msdb and a whole lot of user
> databases. One machine can have several instance of SQL Server.
>
> When you add a Server, there is an entry field "Database list" where you
> can enter the database that are of interest to you. By default the value
> is * for all databases.
> Whether you actually will be able to run BPA, I don't know. Some tests are
> on server-level and requires sysadmin access (I would suppose). Then again,
> I would expect to be able to access a database for which I am the DB ovner.)
> I should add that I believe that I have a pre-release version of BPA, so
> the final interface may look different.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
>