DBA 24/7
Team of DBAs 24/7, the company cannot stop. Proactive monitoring and incident response.
SQL Server · Remote DBA · Performance Tuning
Database Consulting · SQL Server (Remote DBA)
One of the main relational DBMSs on the market, being the fastest and most secure among all other databases. We have a team of SQL Server experts to be the best on the market.
SQL Server · Remote DBA · Performance Tuning
How can we help with your SQL Server database
Performance Tuning
National reference in Performance Tuning. Fabiano Amorim is part of the team.
High Availability
AlwaysOn, Cluster, Log Shipping, Replication, deployment and management.
Cloud Migration
Migration to Azure or Amazon RDS, version upgrades without downtime.
How can we help with your SQL Server database
One of the main relational DBMSs on the market, being the fastest and most secure among all other databases, SQL Server is versatile, powerful and already comes with a data platform built into the product license, including a data integration tool, Big Data tool (as of 2019), advanced analysis tool, data mining, reporting tool, data cleaning, MDM and much more.
Therefore, we have a team of experts in SQL Server, as we understand that it is not possible to be the best at everything, and, therefore, our proposal is to be the best in the market in SQL Server. Do you have SQL Server in your company? So let us analyze your environment for free and I'm sure we can help your bank to be even better, faster and safer.
Full scope
What we deliver
FREE check-up of your SQL Server
24-hour monitoring (errors, alerts, performance, proactive)
Analysis and implementation of DBA best practices
Database configuration and installation
High availability: AlwaysOn, Cluster, Log Shipping, Replication
Cloud migration (Azure or Amazon RDS)
Migration to another server or version upgrade
Creation of alert routines for critical problems
Creation/review/maintenance of backup routines (Full, Differential, Incremental)
Backup to cloud (Azure)
Daily monitoring routines (jobs, space, capacity, availability, permissions)
Audits (logins, data changes, structures, jobs, parameters: with history)
Development of SQL and Transact-SQL Queries
End-to-end performance resolution
Error and problem analysis
Online and In-person Training (In-Company)
Sale of SQL Server Licenses
Performance Tuning
Performance analyzes we perform
From basic to ultra-advanced: we cover the entire SQL Server tuning stack, from instance configurations to spinlocks and In-Memory OLTP.
BasicIntermediaryAdvancedSpecialist
Missing and unused indexes
Analysis of DMVs of missing indexes, duplicate indexes and never used: with prioritization by real impact.
Instance Settings
Review of MAXDOP, Cost Threshold for Parallelism, Max Server Memory, Optimize for Ad Hoc and other critical sp_configure.
Statistics and fragmentation
Intelligent index maintenance (rebuild vs reorganize) and update statistics with FULLSCAN where necessary.
TOP queries by CPU/IO/duration
Identification of the most costly queries via sys.dm_exec_query_stats with trend analysis over time.
Reading and tuning execution plans
Deep analysis of execution plans: identification of table/index scans, key lookups, unnecessary hash joins and wrong estimates.
Wait Statistics and bottlenecks
Analysis of sys.dm_os_wait_stats to identify real I/O, CPU, locking, memory and network bottlenecks.
Rewriting stored procedures and functions
Refactoring of complex procedures, elimination of scalar UDFs, table variables vs temp tables, cursors vs set-based.
Partitioning large tables
Implementation of partitioning for histories of billions of lines, with partition switching and sliding window.
Query Store and plan regressions
Query Store configuration and analysis, force stable plans, and detect regressions after upgrades or changes.
Parameter Sniffing and Plan Cache
Diagnosis and mitigation of parameter sniffing, plan cache pollution, OPTION (RECOMPILE), OPTIMIZE FOR and Plan Guides.
Tempdb contention (PFS, GAM, SGAM)
Resolution of allocation contention in tempdb with multiple data files, trace flags and SQL 2019+ optimizations.
Locks, blocks and deadlocks
Analysis of blocking chains, deadlock graphs, isolation levels (RCSI, Snapshot) and optimization of long-running transactions.
Latch contention and spinlocks
Surgical diagnosis of PAGELATCH, SOS_SCHEDULER_YIELD, LCK_M_*, CXPACKET and CXCONSUMER in highly competitive workloads.
Custom Extended Events
Creation of XE sessions for surgical diagnoses: query recompiles, lock escalations, page splits, auto-grow events.
NUMA, soft-NUMA and CPU affinity
Tuning of NUMA nodes, soft-NUMA, CPU affinity mask and Resource Governor configuration for mixed workloads.
In-Memory OLTP, Columnstore and Batch Mode
Implementation of Hekaton, Clustered/Nonclustered Columnstore, Batch Mode on Rowstore and Intelligent Query Processing.
SQL Server Specialties
Detailed SQL Server Consulting Services
Go deeper into each aspect of our work in SQL Server with specific pages on scope, approach, expected results and advantages for the business.
Performance Tuning
Deep diagnosis of queries, waits, tempdb, Query Store, indexes and configurations.
alwayson
Architecture, implementation, monitoring and failover testing for Availability Groups.
Replication
Transactional topologies, snapshot, latency troubleshooting and secure data distribution.
High Availability and DR
Real continuity with RPO/RTO, backup, log shipping, failover and operational runbooks.
Monthly Support
Recurrent model for support, prevention, incidents and continuous improvement of the environment.
Environment Monitoring
Observability, useful alerts, and monitoring of SQL Server operational health.
Security and Compliance Improvements LGPD/GDPR
Hardening, auditing, privileges, sensitive data protection and compliance trail.
Migration/Version Upgrade/Edition
Assessment, compatibility, cutover tests and post-go-live stabilization.
Our differences
Why Power Tuning?
More than 10 years delivering data projects that really work. See what sets us apart.
Microsoft MVPs
Our team is made up of Microsoft MVPs in data: Microsoft's highest recognition for experts in the field.
Microsoft Solution Partner
We are Microsoft Solution Partner in Azure Data and AI: highly qualified team with direct access to Microsoft.
Power BI experts
Power BI Desktop, Service, Embedded, Premium and Report Server: we know each layer of the platform.
End-to-end BI
Architecture, ETL, modeling, Data Warehouse, OLAP cubes and reports. We deliver the complete project.
Performance Tuning
National reference in SQL tuning. Forget BI loads taking hours to process.
Multidisciplinary team
Azure, databases, data engineering and architecture: always the best solution for your scenario.
Real experts
Here, Júnior has no place. We solve complex problems without learning during the project.
Remote and in-person
We serve anywhere in the world remotely. In person: ES, MG, CE and SP.
Training platform
Exclusive high quality training. Customers have a special discount on all courses.
5 million views
Our consultants' technical blogs have more than 5 million views: shared knowledge.
Instant communication
Teams, WhatsApp, Telegram, Slack: no call queue. Quick response, always.
Process
How we started
01
Diagnostic meeting (free)
We understand your scenario without commitment
02
Technical analysis and proposal
Complete diagnosis and personalized proposal
03
Quick win in 2 to 4 weeks
First quick and tangible results
04
Complete roadmap
Long-term planning aligned to the business
Database Consulting (DBA)
Other Database Consulting (DBA) services
Discover the other specialized services of our DBA team.
Oracle Consulting
Remote Oracle DBA, tuning, performance, RAC, DataGuard and migration to modern environments.
Get to know →PostgreSQL Consulting
Remote PostgreSQL DBA, query tuning, replication, high availability and performance optimization.
Get to know →MySQL Consulting
Remote MySQL and MariaDB DBA, tuning, replication, slow queries and schema and index optimization.
Get to know →Power Tuning Ecosystem
Discover our products
Solutions developed by our best experts to maximize your company's productivity. Guaranteed ROI.
Power EmbeddedReduce up to 90% on Power BI licensing costs. Smart embed for multiple users.
powerembedded.com.br
Power MonitorComplete observability for Power BI and Fabric: usage, cost, performance and security.
powermonitor.com.br
Power ATAIntelligent automation of meeting minutes with AI: transcription, summary and action items.
powerata.ai
Power Alerts for SQL ServerSmart alerts for SQL Server. Anticipate incidents before they become problems.
poweralerts.com.br- Power Alerts for Oracle
24×7 Oracle monitoring with Zabbix and Grafana. 199 items and 154 triggers.
To know 
Power Omni AIPrivate enterprise AI. Your own GPT with your data, running in your environment or Azure.
poweromni.aiPower CLR.NET functions integrated into SQL Server. More features and extensions for your database.
To knowPower Checkup for SQL ServerComplete SQL Server diagnostics. Identify risks and opportunities for improvement.
To knowPower Checkup for OracleComplete Oracle diagnostics. Analysis of performance, security and good practices.
To know
Schedule now
Talk to an expert
Choose the best time for a no-obligation meeting. In 30 minutes, we understand your scenario and present the best path.
Request a proposal
Let's talk about your challenge
Are you ready to get the most out of your data environment? Our experts evaluate your scenario without obligation.
Fill out the form below and our team will get in touch to better understand your needs and start a successful partnership.
- Free initial diagnosis of your scenario
- Response within 1 business day
- No commitment, no charge for evaluation
Do you need help managing your company's SQL Server database?
Do you want to update the version, migrate to the cloud or another server? Need to implement a high availability model? Get in touch!