Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

DBCC Commands Expand / Collapse
Can you please explain commonly used in real time DBCC Commands?
Poll ResultsVotes
Hi All,
0%
0
 
66.67%
2
This is Rangaraja.im new to learn sql dba.
0%
0
Can you please explain commonly used in real time DBCC Commands?
0%
0
 
33.33%
1
Regards,
0%
0
Rangaraja
0%
0
rangarajasqldba@gmail.com
0%
0
Member Votes: 3, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Friday, December 28, 2012 3:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 25, 2014 7:41 AM
Points: 3,545, Visits: 2,653
I definitely use DBCC INPUTBUFFER(spid) and DBCC OPENTRAN the most and at times DBCC SQLPERF. These are the most basic, effective and commonly used DBCC commands.

Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.
Post #1400850
Posted Friday, December 28, 2012 3:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:13 AM
Points: 39,969, Visits: 36,329
sqlnaive (12/28/2012)
Apart from that I've used DBCC SHOWCONTIG and DBCC INDEXDEFRAG as and when required.


Both of those were deprecated 7 years ago, are included only for backward compatibility with SQL 2000 and should not be used any longer.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1400856
Posted Wednesday, January 2, 2013 3:15 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 25, 2014 7:41 AM
Points: 3,545, Visits: 2,653
Correctly said Gail, these two were the DBCC commands which I had used a lot during those days and were really a blessing while looking for optimization. Though now there are new and efficient ways like using sys.dm_db_index_physical_stats (for DBCC SHOWCONTIG) and ALTER INDEX...REORG (OR REBUILD) (for DBCC INDEXDEFRAG)
Post #1401729
Posted Wednesday, January 2, 2013 7:46 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:49 PM
Points: 589, Visits: 2,750
On the other side... I have never run REPAIR_ALLOW_DATA_LOSS.

-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1402151
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse