SQLPerformanceTuning

Scripts for performance tuning

The example in the scripts based on the Adventureworks database

The sample database can be downloaded from the link below, restore the database on the respected versions and test

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

Here is my YouTube channel for further learning

https://www.youtube.com/channel/UCKeNRe2RyQ88MT0eUBNx-nQ

Name		Name	Last commit message	Last commit date
Latest commit History 12 Commits
Advanced Performance Tuning.pdf		Advanced Performance Tuning.pdf
CPU-intensive requests-2.sql		CPU-intensive requests-2.sql
CPU-intensive requests.sql		CPU-intensive requests.sql
Command vs Connection Timeout .pdf		Command vs Connection Timeout .pdf
Current waiting tasks.sql		Current waiting tasks.sql
Duplicate Indexes.sql		Duplicate Indexes.sql
Fragmentation Test.sql		Fragmentation Test.sql
Fragmentation-Fix.sql		Fragmentation-Fix.sql
High Signal wait time.sql		High Signal wait time.sql
IO Latency with DMV(dm_io_virtual_file_stats).sql		IO Latency with DMV(dm_io_virtual_file_stats).sql
Index Fragmentation.sql		Index Fragmentation.sql
Isolation Levels.sql		Isolation Levels.sql
Isolation Levels_2.sql		Isolation Levels_2.sql
IsolationLevels_CreateDB and Table.sql		IsolationLevels_CreateDB and Table.sql
IsolationLevels_Read_Committed.sql		IsolationLevels_Read_Committed.sql
IsolationLevels_Read_Uncommitted.sql		IsolationLevels_Read_Uncommitted.sql
IsolationLevels_RereatableReads.sql		IsolationLevels_RereatableReads.sql
IsolationLevels_Serializable.sql		IsolationLevels_Serializable.sql
LOcks-Row_Lock.sql		LOcks-Row_Lock.sql
LeadBlocker.sql		LeadBlocker.sql
LiveQueryTS.sql		LiveQueryTS.sql
Locks-LockEscalation.sql		Locks-LockEscalation.sql
Locks-Range_Lock.sql		Locks-Range_Lock.sql
Memory Performance.zip		Memory Performance.zip
MemoryGrants.sql		MemoryGrants.sql
Non-Clustered Index and lookups.sql		Non-Clustered Index and lookups.sql
Non-Clustered Index reads.sql		Non-Clustered Index reads.sql
QueryPerformance.sql		QueryPerformance.sql
Query_Memory_Grants.sql		Query_Memory_Grants.sql
README.md		README.md
ResourceGovernor.sql		ResourceGovernor.sql
ResourceGovernor_with_Classifier.sql		ResourceGovernor_with_Classifier.sql
SARGable and Non-SARGable-Queries Examples.sql		SARGable and Non-SARGable-Queries Examples.sql
Statistics-Example.sql		Statistics-Example.sql
Statistics_All_Table.sql		Statistics_All_Table.sql
TEMPDB contention.zip		TEMPDB contention.zip
Top Wait types-Historical waits.sql		Top Wait types-Historical waits.sql
Unused Indexes.sql		Unused Indexes.sql
slow-disk-io-issues.png		slow-disk-io-issues.png
statistics with more than 10% change.sql		statistics with more than 10% change.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Repository files navigation

SQLPerformanceTuning

About

Uh oh!

Releases

Packages

Languages

ChanduTechnet/SQLPerformanceTuning

Folders and files

Latest commit

History

Repository files navigation

SQLPerformanceTuning

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages