February 9, 2017 at 9:58 pm
Comments posted to this topic are about the item SQL Server 2016 Just Runs Faster - DBCC
February 9, 2017 at 10:33 pm
Really interesting question, thanks Steve.
Had to read up on this, just to make sure....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
February 10, 2017 at 1:51 am
Good question, thanks Steve, learnt something new too..
...
February 10, 2017 at 9:47 am
Another one that sent me to BoL... Thanks, Steve!
February 12, 2017 at 2:56 pm
Revenant - Friday, February 10, 2017 9:47 AMAnother one that sent me to BoL... Thanks, Steve!
Me too. As with anything, there is a cost.
February 13, 2017 at 11:06 am
Interesting question - I had some fun finding the answer as there are several other DBCC performance improvements. The question might have been better if it had referred to DBCC CheckDB (& friends) instead of just to DBCC, as the rest of DBCC operations aren't affected by these changes but still have useful performance improvements from other changes. And when mentioning this pair of changes, why not include UDT columns not being checked as well? It's part and parcel of the same improvement and is switched back on (when wanted) by the EXTENDED_LOGICAL_CHECKS just as are the two that are mentioned.
Tom
March 30, 2017 at 2:28 pm
I am not much a fan of the wording of this question. "Which DBCC" was the first thing that came to mind. Then it occurred to me that maybe the question really means the CheckDB command and not just DBCC (which has hundreds of commands).
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-transact-sql
Here are some of those DBCCs
DBCC INPUTBUFFER
DBCC OUTPUTBUFFER
DBCC SQLPERF
DBCC OPENTRAN
DBCC DBREINDEX
DBCC SHRINKFILE
DBCC FREEPROCCACHE
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply