Our great sponsors
-
SQL-Server-First-Responder-Kit
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
-
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.
make sure you have backups running on all of your servers. the community standard is ola's scripts found here: https://ola.hallengren.com/
then download this and install it on all of your servers (i recommend having your own DBA databases on each server that you stick your tools in): https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit
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.
Related posts
- Web server is fine, but database or server is running slow, what tools can I use/how do I diagnose slowdowns/deadlocks.
- Accidental DBA - What database maintenance activities should I run?
- Resource Usage Historical Log
- Unknown High SQL Server CPU usage
- What is a good method to run an SP across all databases?