Best Practice Analyzer for SQL Server 2019

Question

Post reply

Best Practice Analyzer for SQL Server 2019

mohan.bndri

Old Hand

Points: 363
More actions
June 15, 2023 at 5:51 am

#4211672

Hello All
I am looing to run the BPA for SQL Server 2019 version , but don't see BPA available for SQL 2019.
Please help me if any other same as BPA available ( replacing BPA ) to use for SQL Server 2019.
Thanks,

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 2

Crud... sorry. I'd posted a link to the BPA for Windows, not SQL server. I took the post down.

Looking into it further, I don't even know if such a thing even exists anymore but, hopefully after me "bumping" this post, someone will know.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

David Burrows SSC Guru Points: 65142 More actions · Answer 3

Oops I think I did the same ☹️

This reply was modified 1 year, 5 months ago by David Burrows.

Far away is close at hand in the images of elsewhere.
Anon.

David Burrows SSC Guru Points: 65142 More actions · Answer 4

Knowing your feelings on so called SQL Server best practices, Jeff, would you trust a tool like this if it existed 😏

Far away is close at hand in the images of elsewhere.
Anon.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 5

David Burrows wrote:

Knowing your feelings on so called SQL Server best practices, Jeff, would you trust a tool like this if it existed 😏

Heh... You DO know me. That also means that you already know the answer to that question... It has to be tested and most certainly not by the people that made it. 😉

The irony here is that most people that use such a thing will never have the opportunity to make all the fixes it suggests because, according to management, "We have bigger fish to fry". It's usually better to do the migration/upgrade and discover the faults like it seems most companies are destined to realize... something breaks and it'll finally get fixed because now it's the "big fish". 😀

To wit, we're doing an upgrade to 2022. I intentionally left the Legacy Cardinality Estimator off. It took just one half of the first day if testing to find out we still need to leave it on because of the code that they "don't have the time to fix" because it still fits in the overnight slot.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

frederico_fonseca SSCoach Points: 16154 More actions · Answer 6

as far as I remember the latest version of SQL BPA is for 2012 - https://www.microsoft.com/en-in/download/details.aspx?id=29302

nothing seems to have been done (or will be done ) on that tool so you can stick to the 2012 version (where it works) or start using https://github.com/red-gate/SQLCop/ - this will give you some of the functionality (but not all)

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 7

Heh... or resolve yourself to the fact that no one will make any changes to the code no matter what you find and just let them do the testing they're supposed to do to see if something breaks. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Fernando Jacinto Alvarez SSC Veteran Points: 274 More actions · Answer 8

You can use Azure Data Studio and add "Azure SQL Assessment" extension after invoke an assessment and get results you will get a html report that you can export to excel of needed and work on priorities as you want.