Unknown High SQL Server CPU usage

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

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

  • sp_whoisactive

    sp_whoisactive

  • SQL-Server-First-Responder-Kit

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

    • Either sp_WhoIsActive, or you can look into First Responder Kit - https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/tree/main - specifically sp_BlitzCache stored procedure, which, by default, will list out the most CPU expensive query in SQL Server plan cache. This should help you identify the "problematic" query.

  • 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

  • Accidental DBA - What database maintenance activities should I run?

    5 projects | /r/SQL | 3 Feb 2022

  • Resource Usage Historical Log

    1 project | /r/SQLServer | 8 May 2023

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

    1 project | /r/SQL | 13 Mar 2023