SQL Server Consulting, SQL Server Experts, SQL Server Migrations, SQL Server Performance, SQL Server High Availability, SQL Server Operations

info@techdevops.com | 437-991-3573 | Data Engineering Services

TechDevOps.com

Resources	Tools

Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance

< Back

October 1, 2023

SQL Server OPTION (FAST N)

by BF (Principal Consultant; Architecture; Engineering)

Query Optimizer

Tags SQLServerPerformance

October 8, 2022

High CPU Pressure

by BF (Principal Consultant; Architecture; Engineering)

Signal Wait Time

Tags SQLServerPerformance

May 8, 2022

Get CPU Usage Information

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_os_ring_buffers, sys.dm_exec_requests, sys.dm_exec_query_stats

Tags SQLServerPerformance

March 10, 2022

Get The TEQ (Top Expensive Queries)

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_exec_query_stats

Tags SQLServerPerformance

August 26, 2019

Microsoft SQL Server - Database Compression Estimator (PAGE and ROW)

by BF (Principal Consultant; Architecture; Engineering)

sp_estimate_data_compression_savings

Tags SQLServerPerformance

January 10, 2019

Restore a SQL Server Database Faster

by BF (Principal Consultant; Architecture; Engineering)

MAXTRANSFERSIZE, BUFFERCOUNT

Tags SQLServerPerformance

December 6, 2018

T-SQL Monitor TempDB Usage

by BF (Principal Consultant; Architecture; Engineering)

sys.database_files, sys.dm_os_performance_counters, sys.dm_db_file_space_usage

Tags SQLServerPerformance

June 17, 2018

Fing Queries using Parallelism

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_exec_query_stats, sys.dm_exec_sql_text, sys.dm_exec_cached_plans, sys.dm_exec_query_plan, sys.dm_os_tasks, sys.dm_os_workers, sys.dm_os_waiting_tasks

Tags SQLServerPerformance

June 13, 2018

Find the root cause of a TEMPDB LOG growth issue

by BF (Principal Consultant; Architecture; Engineering)

Extended Events, DBCC OPENTRAN, INPUTBUFFER & SYSPROCESSES

Tags SQLServerPerformance

May 18, 2018

Automate DBCC UpdateStats per select list of databases

by BF (Principal Consultant; Architecture; Engineering)

Exec sp_updatestats

Tags SQLServerPerformance

April 29, 2018

Running SQL Server Post-Installation Checks

by BF (Principal Consultant; Architecture; Engineering)

Builds

Tags SQLServerPerformance

April 28, 2018

Automate SQL Server Database Data & Log File Growth Sizes

by BF (Principal Consultant; Architecture; Engineering)

sys.master_files, sys.databases, sysaltfiles

Tags SQLServerPerformance

April 28, 2018

Check Allocation Unit Size for Disks in a SQL Server System

by BF (Principal Consultant; Architecture; Engineering)

DISKPART

Tags SQLServerPerformance

April 21, 2018

Monitor real-time query progress using sys.dm_exec_query_profiles DMV

by BF (Principal Consultant; Architecture; Engineering)

Use this DMV to determine which part of the query is running slow.

Tags SQLServerPerformance

April 17, 2018

Disk Performance on Azure Virtual Machine - storflt driver

by BF (Principal Consultant; Architecture; Engineering)

Virtual machines (VMs) that are running Windows Server 2012 R2

Tags SQLServerPerformance

March 10, 2018

Using Extended Events to capture Stored Procedure calls, Log & Extract Duration Buckets of % and/or #

by BF (Principal Consultant; Architecture; Engineering)

CREATE EVENT SESSION, ADD EVENT, ADD TARGET

Tags SQLServerPerformance

February 11, 2018

Hitting the 16 Terabytes Data File Limit

by BF (Principal Consultant; Architecture; Engineering)

Maximum Capacity Specifications for SQL Server

Tags SQLServerPerformance

January 22, 2018

The request limit for the database is 400 and has been reached

by BF (Principal Consultant; Architecture; Engineering)

Azure SQL Database resource limits

Tags SQLServerPerformance

November 8, 2017

T-SQL - Check Statistics Last Updated and Update All Statistics

by BF (Principal Consultant; Architecture; Engineering)

sys.stats, sys.stats_columns, sys.columns, sys.partitions, sys.objects

Tags SQLServerPerformance

November 8, 2017

T-SQL - Find Missing Indexes - incl. Improvement Measure and Avg User Impact

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_db_missing_index_group, sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_details

Tags SQLServerPerformance

August 29, 2017

Speeding up SQL Server Database Restores

by BF (Principal Consultant; Architecture; Engineering)

Multi-Threaded Approach, Database Instant File Initialization, Azure VM SSDs

Tags SQLServerPerformance

July 21, 2017

T-SQL Get Database Backups Throughput

by BF (Principal Consultant; Architecture; Engineering)

msdb.dbo.backupset, msdb.dbo.backupmediafamily

Tags SQLServerPerformance

June 30, 2017

High Memory Pressure

by BF (Principal Consultant; Architecture; Engineering)

sys.objects, sys.partitions, sys.allocation_units, sys.indexes, sys.dm_os_buffer_descriptors

Tags SQLServerPerformance

June 7, 2017

sp_server_diagnostics

by BF (Principal Consultant; Architecture; Engineering)

Captures diagnostic data and health information about SQL Server to detect potential failures. The procedure runs in repeat mode and sends results periodically.

Tags SQLServerPerformance

June 5, 2017

Capture Microsoft SQL Server Waits Stats

by BF (Principal Consultant; Architecture; Engineering)

sys.dm_os_wait_stats - Returns information about all the waits encountered by threads that executed. Use this aggregated view to diagnose performance issues with SQL Server and also with specific queries and batches.