Question about BPA

24 Nov 2005 9:48 PM

Kenny M.

Is it possible to use the Best Practice Analizer on a remote DB? I mean a DB
hosted in a hosting company?

--
Kenny M.

25 Nov 2005 1:22 AM

Andrew J. Kelly

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

Show quote

"Kenny M." <Ken***@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.

25 Nov 2005 3:04 AM

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.

Show quote

"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." <Ken***@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.
>
>
>

25 Nov 2005 2:10 PM

Andrew J. Kelly

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

Show quote

"Kenny M." <Ken***@discussions.microsoft.com> wrote in message
news:82637589-85C7-4B5B-AFDC-57620DBF1F89@microsoft.com...
> 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." <Ken***@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.
>>
>>
>>

26 Nov 2005 11:03 PM

Erland Sommarskog

Kenny M. (Ken***@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, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

1 Dec 2005 7:52 PM

Kenny M.

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.

Show quote

"Erland Sommarskog" wrote:

> Kenny M. (Ken***@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, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>