• Log In
  • Contact Brent
Product has been added to your cart.
  • Consulting
  • Training
    • My Videos and Downloads
    • My Account
    • Corporate Group SQL Server Training
    • Conferences
    • Training FAQ
  • Scripts
    • sp_Blitz – free health check
    • sp_BlitzCache – find queries to tune
    • sp_BlitzFirst – instant performance check
    • sp_BlitzIndex – design the right indexes
    • sp_BlitzWho – what’s happening right now
    • PasteThePlan – share query plans
  • Blog
    • T-SQL
    • Query Exercises
    • Execution Plans
    • Indexing
    • Videos
    • Architecture
    • Backup and Recovery
    • Cloud Computing
    • Development
    • First Responder Kit
    • High Availability
    • Humor
    • Locking, Blocking, and Isolation Levels
    • Parameter Sniffing
    • Production Database Administration
    • Professional Development
    • SQL ConstantCare

dbcc

Home
dbcc

Where to Run DBCC on Always On Availability Groups

Last Updated February 9, 2017
Brent Ozar
Always On Availability Groups
48 Comments
With SQL Server 2012’s new AlwaysOn Availability Groups, we have the ability to run queries, backups, and even DBCCs on database replicas.  But should we? Paul Randal (Blog – @PaulRandal) covered this issue in today’s SQLskills Insider newsletter, and he says: “It’s not checking the I/O subsystem of the log shipping primary database – only…
Read More

© Brent Ozar Unlimited®. All Rights Reserved.
Privacy Policy – Terms and Conditions

  • Consulting
  • Training
  • Scripts
  • Blog