Best Practice Analyzer

First of all, let me say I think the Best Practice Analyzer is great - it's
a valuable tool. I've already identified a few things in my database that I
might not have ever seen without this tool.
I'd like to know if a couple of things are possible in the SQL Server Best
Practice Analyzer. If they are not, then please consider them as
suggestions:
a.. When I scan a server, is it possible to choose the databases I'd liked
scanned? I don't really care about scanning Northwind and Pubs.
b.. Is it possible to scan objects that begin with a certain prefix? For
example, the objects that I create all begin with certain prefix; IQWP_ for
example. Another developer's objects begin with IQP_. The objects are for
different apps, thus the difference in the naming convention. I'd prefer in
most cases to scan only my objects. Along this same line, it would be nice
to be able to exclude items using a wildcard - similar to how we do this
same thing in Profiler. For instance, exclude %test%.
c.. Is there a way to sort by sproc/view name when I click on "Scan
Details" in a report? It's pretty sporadic now.
Thanks, Andre
I think (a) may be in the works, the other two sound like great suggestions.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:%23%23IbKt7NEHA.3936@.TK2MSFTNGP12.phx.gbl...
> First of all, let me say I think the Best Practice Analyzer is great -
it's
> a valuable tool. I've already identified a few things in my database that
I
> might not have ever seen without this tool.
>
> I'd like to know if a couple of things are possible in the SQL Server Best
> Practice Analyzer. If they are not, then please consider them as
> suggestions:
>
> a.. When I scan a server, is it possible to choose the databases I'd
liked
> scanned? I don't really care about scanning Northwind and Pubs.
> b.. Is it possible to scan objects that begin with a certain prefix?
For
> example, the objects that I create all begin with certain prefix; IQWP_
for
> example. Another developer's objects begin with IQP_. The objects are
for
> different apps, thus the difference in the naming convention. I'd prefer
in
> most cases to scan only my objects. Along this same line, it would be
nice
> to be able to exclude items using a wildcard - similar to how we do this
> same thing in Profiler. For instance, exclude %test%.
> c.. Is there a way to sort by sproc/view name when I click on "Scan
> Details" in a report? It's pretty sporadic now.
> Thanks, Andre
>
|||Thanks Jasper.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:Opvdb%23AOEHA.1272@.tk2msftngp13.phx.gbl...
> I think (a) may be in the works, the other two sound like great
suggestions.[vbcol=seagreen]
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:%23%23IbKt7NEHA.3936@.TK2MSFTNGP12.phx.gbl...
> it's
that[vbcol=seagreen]
> I
Best[vbcol=seagreen]
> liked
> For
> for
> for
prefer
> in
> nice
>
|||Hi Andre
As usual Jasper's right :-) I've noted b & c for future enhancements.
Thanks for the feedback.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:ev0yczEOEHA.904@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Thanks Jasper.
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:Opvdb%23AOEHA.1272@.tk2msftngp13.phx.gbl...
> suggestions.
> that
> Best
IQWP_[vbcol=seagreen]
are[vbcol=seagreen]
> prefer
this
>
|||Would like to be able to schedule and mail reports automatically. When there are dozens of servers to review, this would be nice.
Also, from an announcement elsewhere: quote
Key features include the ability to generate reports on the databases you scan. The reports are generated in a Reporting Services–compatible format, so you can also send out automated nastygrams to people who oversee databases that aren't compliant with
your company's best practices.
endquote
So far, I haven't quite been able to understand how nastygrams or reports can be generated for viewing outside of the MS-SQLBPA user interface box.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||I'm assuming you're using the v1 bits posted on the web two weeks back.
To schedule and mail reports automatically you'll need to use SQL Server
Reporting Services. http://www.microsoft.com/sql/reporting/default.asp
BPA user's guide has a quick description of the steps needed to get BPA
reports.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23I1UNYnSEHA.3448@.TK2MSFTNGP09.phx.gbl...
> Would like to be able to schedule and mail reports automatically. When
there are dozens of servers to review, this would be nice.
> Also, from an announcement elsewhere: quote
> Key features include the ability to generate reports on the databases you
scan. The reports are generated in a Reporting Services?"compatible format,
so you can also send out automated nastygrams to people who oversee
databases that aren't compliant with your company's best practices.
> endquote
> So far, I haven't quite been able to understand how nastygrams or reports
can be generated for viewing outside of the MS-SQLBPA user interface box.
>
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.