Deprecated Features

Question

Post reply

Deprecated Features

Viewing 11 posts - 16 through 25 (of 25 total)

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

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 1

Nils Gustav Stråbø

SSChampion

Points: 11259

August 5, 2010 at 7:07 am

#1202705

Good question. I didn't know about this. Thanks!

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

Even after a little bit of research I got it wrong. Tough question, thanks. More reading to do.

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 3

The trick to dealing with this question is to realize that the addition to 2008 and up was in the performance counters exposed to Performance Monitor. You could see this also in PM if you set it up. Therefore, the DMV that you want is the one that exposes the performance counters to SQL. The view itself hasn't changed, just the counters it reports on.

pjdiller SSC Eights! Points: 977 More actions · Answer 4

I think a nice or good question is one that includes the correct answer as an option. This is not one of those. I choose to reserve my praise for questions that are well formed.

It's impossible not to learn something from it and that's good, but isn't that true of just about anything for someone trying to learn?

I again appreciate the attempt, but I cannot join in the praise today.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 736478

August 5, 2010 at 8:27 am

#1202799

The typos have been corrected

Oleg Netchaev SSCertifiable Points: 5276 More actions · Answer 6

Steve Jones - Editor (8/5/2010)
The typos have been corrected

Almost. The sys.dm_os_sys_info is still spelled as sys.dm_os_sys.info with the dot before info instead of desired underscore.

Oleg

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 7

I left that alone since it wasn't a correct answer.

It's been removed.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Thanks Steve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Rune Bivrin SSCrazy Eights Points: 8524 More actions · Answer 9

While I agree that errors aren't good, I didn't really notice them in this question. I looked up "deprecated features" in BOL, and found a reference to sys.dm_os_performance_counters. Matching that to the answers wasn't that hard, and was probably done using a mental SOUNDEX.

Anyway, great question. I hadn't notice that view before, so I really learned something from this.

Just because you're right doesn't mean everybody else is wrong.

murray-906152 SSCarpal Tunnel Points: 4986 More actions · Answer 10

Another way of getting to this information is via ...

SELECT * FROM sys.sysperfinfo WHERE object_name LIKE ('%deprecated%')

... but don't use it because this view itself is on the deprecated list!

jts2013 Hall of Fame Points: 3226 More actions · Answer 11

A very useful view - added to my list to check after upgrading.

Are these all things that will be removed in the very next version of SQL Server, or two versions away? e.g. version 11 or 12?