skills.rest
IngvarConsulting
IngvarConsultingOFFICIAL
Explore all skills by this author →
WebsiteGitHub

db-performance

Diagnose 1C database slow queries, lock contention, and index misuse.

140|16|Updated May 2, 2026
Search Tags:#performance#database#queries#diagnostics#locks#index
One-click install
npx skills add https://github.com/IngvarConsulting/unica --skill db-performance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-performance
Source: https://github.com/IngvarConsulting/unica/tree/main/plugins/unica/skills/db-performance
Command: npx skills add https://github.com/IngvarConsulting/unica --skill db-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps identify bottlenecks and performance degradation in 1С databases by analyzing slow queries, index usage, and lock contention.

Core Features & Use Cases

  • Performance Diagnostics: Detects slow queries, analyzes execution plans, and reviews indexes to improve database efficiency.
  • Workflow Optimization: Assists 1C developers and administrators in diagnosing deadlocks, lock issues, and temp storage problems in large data environments.
  • Use Case: A user notices slow report generation, and this Skill guides them through analyzing query performance and suggesting index improvements.

Quick Start

Name the problematic query or scenario, and then run the corresponding diagnostics to gather performance evidence and identify root causes.

Frequently Asked Questions about db-performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose slow query performance in a 1C database?▼

To diagnose slow query performance in a 1C database, you execute provided scripts to analyze execution plans, review index usage, and gather data metrics. This approach identifies the root causes of query slowdowns and recommends improvements.

Why does lock contention happen in 1C data environments?▼

Lock contention in 1C data environments happens when concurrent transactions compete for database resources. You can diagnose these deadlocks and lock issues by running performance diagnostics to analyze contention patterns and optimize workflow efficiency.

What is the best way to troubleshoot slow report generation in 1C?▼

The best way to troubleshoot slow report generation in 1C is to name the problematic query, run diagnostics to gather performance evidence, and analyze execution plans. This identifies whether index misuse or lock contention causes the delay.

Can I analyze index usage for large-scale 1C databases?▼

Yes, you can analyze index usage for large-scale 1C databases. The Skill includes scripts that execute performance checks to detect index misuse and review efficiency, helping administrators optimize large data environments effectively.

Do I need specific scripts to detect temp storage problems in 1C?▼

Yes, you need specific diagnostic scripts to detect temp storage problems in 1C. These scripts execute performance checks to analyze data metrics and identify temporary storage issues affecting database performance.

Related Skills

Explore More Data & Analytics Skills→
dogeareddogeared

benchmark

Collect navigation timing metrics and resource usage to benchmark web application performance.

Community
Advanced
alexander-danilenkoalexander-danilenko
14

database-optimizer

Analyze PostgreSQL and MySQL execution plans to optimize slow queries.

Community
Advanced
BradliebsBradliebs

canary

Monitor live web apps for console errors, performance regressions, and visual anomalies.

Community
Advanced
zinohomezinohome
1

sql-query-optimizer

Analyze SQL EXPLAIN plans and recommend index strategies.

Community
Advanced