sql-server-maintenance-solution vs sp_whoisactive

sql-server-maintenance-solution

SQL Server Maintenance Solution (by olahallengren)

Sqlserver

Source Code

ola.hallengren.com

Suggest alternative

Edit details

sp_whoisactive

sp_whoisactive (by amachanic)

SQL Sqlserver Monitoring

Source Code

Suggest alternative

Edit details

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		sp_whoisactive
	Project
47	Mentions	3
2,763	Stars	1,104
-	Growth	-
0.0	Activity	0.0
13 days ago	Latest Commit	3 months ago
TSQL	Language	TSQL
MIT License	License	GNU General Public License v3.0 only

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

sql-server-maintenance-solution

Posts with mentions or reviews of sql-server-maintenance-solution. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-07-06.

Rookie dba questions on maintenance
1 project | /r/SQLServer | 7 Dec 2023
What are your SQL server best practices that you live by?
2 projects | /r/sysadmin | 6 Jul 2023

100% this. Separating tempdb has a huge impact, and Ola’s scripts are a must, for anyone who doesn’t know: https://ola.hallengren.com

1 project | /r/DBA | 6 Jul 2023
Securing SQL Standard 2019 server
1 project | /r/sysadmin | 3 Jul 2023

Since you are new to SQL - https://ola.hallengren.com/ and http://whoisactive.com/downloads/ + https://www.sqlshack.com/monitoring-activities-using-sp_whoisactive-in-sql-server/ will make your SQL experience night and day. Learn these SPs/Tooling.
Windows environmental variables and maintenance plans
1 project | /r/MSSQL | 29 Jun 2023

First, don't use maintenance plans. Full Stop. Use Ola Hallengren's Maintenance Solution or Minion Backup. dbatools even has a way to install and schedule Ola's jobs, including backups. Quick and easy.
To create a custom text log file using MS SQL server
1 project | /r/SQL | 26 Jun 2023

Instead of trying to reinvent the wheel look at https://ola.hallengren.com/
Slow SCCM Server and Console Performance
1 project | /r/SCCM | 16 May 2023

Great advise. I tend to use this for SQL: https://ola.hallengren.com
Sccm, Wsus pros.
1 project | /r/SCCM | 6 May 2023

Ya I use https://ola.hallengren.com for my DB maintenance. I typically have to fix existing non maintained WSUS / SUSDB Sups. I found one the other day with about 20K updates lol
Automatic backup to Azure blob
1 project | /r/SQL | 24 Apr 2023

Install Ola Hallengren's Maintenance Solution and schedule the Agent jobs to run the backups when you need them (and make sure you understand the difference between FULL, LOG and DIFF backups, and when you should use each). Configure it with the URL for your Azure Blob Storage. You will also need to create a Credential for SQL Server to use to authenticate to Azure Blob Storage.
Hired in to "fix" SCCM. Their build is running without issue (albeit fairly slow) but is quite messy. Where would you start looking to make improvements?
1 project | /r/SCCM | 12 Apr 2023

SQL Server database maintenance. You don't need to be a SQL expert - just set it and forget it with this: https://ola.hallengren.com/

sp_whoisactive

Posts with mentions or reviews of sp_whoisactive. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-04-21.

SQL not showing active kpid connection
1 project | /r/SQLServer | 22 Apr 2023
Unknown High SQL Server CPU usage
2 projects | /r/SQL | 21 Apr 2023
sp_whoisactive
1 project | /r/SQL | 10 Feb 2023

What are some alternatives?

When comparing sql-server-maintenance-solution and sp_whoisactive you can also consider the following projects:

dba-dash - DBA Dash - SQL Server Monitoring Tool

sql-server-password-secure - Securely storing passwords in SQL-Server for C# and verifying

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

nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative

AdvancedSQLPuzzles - Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.

Sql-Server-DBA-Toolbox - A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.

dp-300-database-administrator - Repository for lab exercises and instructions for Microsoft DP-300 learning content

litestream - Streaming replication for SQLite.