All Posts by Lori Brown


About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.

Dec 17

Stored procedure execution info with query plan

By Lori Brown | Expert , Performance Tuning , SQL Administration , SQL Server

Sometimes it is good to have some queries in your toolkit that give you information on how things are running that includes the actual execution plan. While looking at Glenn Berry’s diagnostic query scripts (, which are very good btw, I found queries that will list stored procedure statistics but none had the execution plan […]

Continue reading
Nov 12

Good DBA! Tasks that all DBA’s should do to have a Stable SQL Server

By Lori Brown | Beginner , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah What are the critical aspects of SQL Server that a DBA should check on a daily basis?  How about on a weekly or monthly basis? Daily Checklist Backups: Check your backups (Full, Differential, Transaction Logs) to validate that they were successfully created per your company’s policies. Nightly Processing: Review the nightly or […]

Continue reading
Oct 08

AlwaysOn Availability Groups – Enable or Disable Jobs on Failover

By Lori Brown | Helpful Scripts , Intermediate , SQL Administration , SQL Server

— By Lori Brown  @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (, I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]

Continue reading
Sep 03

Tip of the Month: WAIT_AT_LOW_PRIORITY option for Index Rebuilds

By Lori Brown | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

— By Lori Brown  @SQLSupahStah Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds. Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION […]

Continue reading