SQL-Server-First-Responder-Kit
xo
SQL-Server-First-Responder-Kit | xo | |
---|---|---|
14 | 16 | |
3,222 | 3,567 | |
0.6% | 0.6% | |
9.0 | 6.2 | |
4 days ago | 9 days ago | |
TSQL | Go | |
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.
xo
-
Open-sourcing SQX, a way to build flexible database models in Go
i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.
- PHP to Golang
-
Best sqlc alternative for dynamic queries?
I use xo https://github.com/xo/xo . It generates CRUD queries by default so i don't have to write basic queries and it has option to write complex queries like sqlx. Only issue is it is not well documented.
-
Why SQL is right for Infrastructure Management
SQL is an old, irregular language to work with, but it is better known than HCL and SQL already has it's own Pulumi/CDK in the form of every ORM with introspection (like Javascript's Prisma, Python's Django, Go's XO etc) and QueryBuilder (LINQ, Knex, etc) in whatever programming language you prefer. You probably already know it.
-
Help with XO's new templating, how to access fields and params
I am using the library xo to generate basic data retrieval code from a sql schema for a crud api.
-
Matt Mueller: Building Modern Web Applications Faster With Bud
Sorry for the confusion, we're not generating the database client itself, more like generating an ORM around a database client. The ORM takes these database clients as dependencies. It's very similar to the way XO works with it's multi-database support: https://github.com/xo/xo/tree/master/_examples/northwind
-
What’s your preferred setup to work with SQL DB (without ORM) ?
i use xo . Reason is i prefer designing schema first and creating golang scaffolding later. Xo takes schema and gives me basic create/update/delete operations by default and i can also generate gocode for any sql queries that i write.
- Show HN: A Go framework for your projects
-
sqlc: Generating go code from sql statements
Thanks for sharing your thoughts! I see that it works best with Postgresql. The other commenter mentioned https://github.com/xo/xo for MySql which might work well.
-
Show HN: A Full-Stack Web Framework Written in Go
Thanks for your comment and question @onionisfruit. Top-notch handle too!
>> What are your plans for models and persistence?
I haven't worked out all the details, but it's going to be some blend of https://github.com/xo/xo and https://sqlc.dev/.
Design goals:
1. High-level, type-safe "ORM" that's generated from your database schema.
What are some alternatives?
dba-dash - DBA Dash - SQL Server Monitoring Tool
sqlc - Generate type-safe code from SQL
sql-server-maintenance-solution - SQL Server Maintenance Solution
igor - igor is an abstraction layer for PostgreSQL with a gorm like syntax.
sqlserver-kit - Useful links, scripts, tools and best practice for Microsoft SQL Server Database
SQLBoiler - Generate a Go ORM tailored to your database schema.
express-status-monitor - 🚀 Realtime Monitoring solution for Node.js/Express.js apps, inspired by status.github.com, sponsored by https://dynobase.dev
prometheus - The Prometheus monitoring system and time series database.
ketum - Open-Source and Cross-Platform Web / API Monitoring Tool
BTrDB - Berkeley Tree Database (BTrDB) server
sp_whoisactive - sp_whoisactive
dat - Go Postgres Data Access Toolkit