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

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

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • sql-server-maintenance-solution

    SQL Server Maintenance Solution

    • Ola Hallengren's scripts are well known and reliable (we even use them on our production servers with appropriate fine-tuning) and can help get you started if you don't have that set up yet.

  • SQL-Server-First-Responder-Kit

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

    • Someone mentioned Blitz scripts - these are a series of free, open source stored procedures that are simple to instal and run on your SQL instances. You can find them here (https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit) and at his website (https://www.brentozar.com/blitz). To be honest, I admire the guy and how he presents help and techniques on how to trouble shoot your SQL instance - so I would start with the sp_blitz sp, run it, follow some of the links provided in the results and start learning a few things from that.

  • 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