Accidental DBA - What database maintenance activities should I run?

This page summarizes the projects mentioned and recommended in the original post on /r/SQL
sql-server Sqlserver sp-blitz sp-blitzcache sp-blitzindex

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • sql-server-maintenance-solution

    SQL Server Maintenance Solution

    • Check out Ola Hallengren's scripts - https://ola.hallengren.com - these will do all sorts of maintenance for you and are used by many huge (as well as small and medium) companies worldwide for SQL Server maintenance. You can schedule his jobs to run on a schedule. They'll optimise your table indexes, statistics, etc., but do so with some intelligence based on fragmentation, etc.

  • SQL-Server-First-Responder-Kit

    sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

    • Check out Ola Hallengren's scripts - https://ola.hallengren.com - and also Brent Ozar's first responder kit - https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Web server is fine, but database or server is running slow, what tools can I use/how do I diagnose slowdowns/deadlocks.

    2 projects | /r/SQLServer | 28 Feb 2023

  • Seeking good resources after landing first SQL job

    2 projects | /r/SQLServer | 23 Sep 2022

  • Resource Usage Historical Log

    1 project | /r/SQLServer | 8 May 2023

  • Unknown High SQL Server CPU usage

    2 projects | /r/SQL | 21 Apr 2023

  • What is a good method to run an SP across all databases?

    1 project | /r/SQL | 13 Mar 2023