SQL Server 2014 BPA?

Question

SQL Server 2014 BPA?

rummings

SSCarpal Tunnel

Points: 4575
More actions
April 16, 2015 at 1:08 pm

#316656

Is there a Best Practices Analyzer for SQL Server 2014? We are moving from SQL Server 2008 R2 to SQL Server 2014 in the near future. I would like to run the BPA on the 2014 installs if possible.
Thanks!
Charlie

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

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

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 1

No, there's still no Best Practices Advisor for 2014. There is the 2014 Upgrade Advisor though. That will help you through the upgrade process.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 2

Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 3

Henrico Bekker (7/13/2016)
Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.

No. I don't think you they are maintaining that code any more.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 4

Dammit - wonder if there's any replacement tool for BPA.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

bruce the wiesel Valued Member Points: 51 More actions · Answer 5

https://msdn.microsoft.com/en-us/library/ee342167(v=sql.120).aspx

Grant Fritchey SSC Guru Points: 398878 More actions · Answer 6

bruce the wiesel (8/29/2016)
https://msdn.microsoft.com/en-us/library/ee342167(v=sql.120).aspx

That's from Policy Based Management. It does have some examples that are similar to the BPA, but not complete the way the BPA was.

SQLCop from the LessThanDot.com web site is probably as close to the BPA as you're going to get these days.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 7

Pity, thanks for the feedback

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle