SQL-Server-First-Responder-Kit
dba-dash
SQL-Server-First-Responder-Kit | dba-dash | |
---|---|---|
14 | 13 | |
3,222 | 229 | |
0.9% | 4.8% | |
9.0 | 9.1 | |
6 days ago | 2 days ago | |
TSQL | C# | |
GNU General Public License v3.0 or later | MIT License |
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-First-Responder-Kit
-
Resource Usage Historical Log
I would also check that the server is configured according to best practices - DBA Dash can also help with that. I would also recommend running sp_Blitz. In terms of memory configuration, you should set the max server memory to an appropriate value.
-
Unknown High SQL Server CPU usage
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.
- What is a good method to run an SP across all databases?
-
Web server is fine, but database or server is running slow, what tools can I use/how do I diagnose slowdowns/deadlocks.
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.
- Show HN: I wrote a free eBook about many lesser-known/secret database tricks
- Restoring database from another computer.
-
Seeking good resources after landing first SQL job
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
-
Easiest way to compile site numbers into one entry (tables are in different databases)?
You could use sp_ineachdb(which just uses a cursor under the hood)
- Question about SQL Server Standard vs Enterprise
-
SQL Optimization Resources
SQL Server First Responder Kit, Ozar et al. The First Responder Kit is a set of stored procedures for "first responder" consultants who want to troubleshoot SQL Server problems. Coupled with the various resources at brentozar.com, the kit gives a great set of tools for performance investigations to gain a strong foothold and then make immediate progress on key issues and low-hanging fruit. The resources at the site develop a strong understanding of SQL Server internals for iterative refinement.
dba-dash
-
Backup History Query Assistance
DBA Dash backup collection query for reference. Have you tried running the query in SSMS and timed the execution?
- RedGate SQL Monitor vs Foglight
-
Monitoring the health of hundreds of instances, what would/do you use?
It's still important to have alerts and DBA Dash doesn't have anything built in to do this. It is possible to create alerts based on the data collected in the repository database. There are some sample alerts here that might be worth a look. Hope this helps!
-
Would it be bad practice to hold general database/server information from dozens of servers in a central database?
You can almost get everything through SQL with sys.dm_os_volume_stats:https://github.com/trimble-oss/dba-dash/blob/main/DBADash/SQL/SQLDrives.sqlThis won't include volumes that don't have any SQL files on them. e.g. o/s volume, backup volume etc.
- CPU utilisation by core
-
Is there a way to watch what's happening in SQL server in real time?
I would definitely still recommend sp_whoisactive though - it's a great tool. Also, monitoring tools act like a flight recorder providing valuable information that you can use to diagnose performance issues after the event. I created DBA Dash an open-source monitoring tool that you might want to take a look at if you are interested in using a monitoring tool. Also, enabling query store at the DB level provides useful data to troubleshoot and fix performance issues.
- Question about SQL Server Standard vs Enterprise
-
Setting up monitoring for SQL Server
I created a monitoring tool called DBA Dash that's open source if you are interested in a free monitoring tool. https://github.com/trimble-oss/dba-dash When adding a connection to monitor click the checkbox for slow query capture and it will capture all queries that take longer than 1 second to run. This is similar to your profiler trace. It also captures a lot of other data that is useful to troubleshoot performance issues. As mentioned query store is great - enable this and use in combination with dba dash. (Or other monitoring tool)
- Database corruption is insidious. Check the integrity of your databases regularly!
-
slow database server troubleshooting checklist
sp_BlitzFirst, sp_whoisactive. Look at query store if you have this enabled. If its a bad plan query store can help you identify and fix it. Look at cpu, io performance metrics etc. If you can't create procs for some reason you could add ## to the name to make them global temp stored procs. The procs will live as long as the session is left open that created them. Consider a utility database where you can add diagnostic stored procs. Ideally consider a monitoring tool. I created a free open source one called DBA Dash. https://github.com/trimble-oss/dba-dash
What are some alternatives?
sql-server-maintenance-solution - SQL Server Maintenance Solution
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database
DarlingData - Open source SQL Server nonsense: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, etc.
xo - Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
grafana
express-status-monitor - 🚀 Realtime Monitoring solution for Node.js/Express.js apps, inspired by status.github.com, sponsored by https://dynobase.dev
Bitwarden - The core infrastructure backend (API, database, Docker, etc).
ketum - Open-Source and Cross-Platform Web / API Monitoring Tool
FluentMigrator - Fluent migrations framework for .NET
sp_whoisactive - sp_whoisactive
activerecord-summarize - Transparently combine many reporting queries (on the same tables) into one fast query—even when queries have different groups or scopes.