microsoft/tigertoolbox

View on GitHub

Toolbox repository for Tiger team

Stars: 1.6k
Forks: 749
Open beginner issues: 0
Indexed issues: 93

Dominant language: Jupyter Notebook
License: No license data
Last GitHub push: Apr 10, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: Code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

93 open issues indexed

BUG in usp_AdaptiveIndexDefrag: When dbScope is set, a new scan is done every time. Open

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

microsoft/tigertoolbox#320 · Opened May 17, 2026
rebuild index never done ONLINE on Azure SQL ? due to EngineEdition IN (1804890536, 1872460670, 610778273, -2117995310) Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

microsoft/tigertoolbox#319 · Opened May 12, 2026
usp_AdaptiveIndexDefrag / Error converting data type bigint to numeric Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#312 · Opened Aug 19, 2024
usp_AdaptiveIndexDefrag / Not working on very large tables Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/tigertoolbox#311 · Opened Jul 5, 2024
Cannot insert the value NULL into column 'CounterName', table 'dba_local.dbo.PerformanceCounter'; column does not allow nulls Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

microsoft/tigertoolbox#307 · Opened Feb 29, 2024
Arithmetic overflows in view_IndexInformation_CurrentDB; No data output Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#306 · 1 comment · Opened Jan 6, 2024
AWS RDS instance limitations Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

microsoft/tigertoolbox#305 · 1 reaction · Opened Dec 6, 2023
Fixing-VLFs accurate to 73728MB only Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

microsoft/tigertoolbox#303 · Opened Nov 7, 2023
ChangeTrackingCleanup.sql doesn't work, it deletes nothing Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#302 · Opened Jul 28, 2023
Guidance on running `3_job_AdaptiveIndexDefrag` on Azure SQL Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#298 · Opened May 31, 2023
Check_BP_Servers is not returning the correct information for SQL Server services account. Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

microsoft/tigertoolbox#292 · Opened Dec 26, 2022
Index-Information - KeyCols_data_length_bytes also aggregates for included columns Open

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

microsoft/tigertoolbox#291 · 1 comment · Opened Dec 18, 2022
usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log Open

Difficulty 3/5 1-2 days Newbie friendliness 42/100

microsoft/tigertoolbox#288 · Opened Nov 29, 2022
Is 'optimize for ad hoc workloads'=ON still recommended? Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

microsoft/tigertoolbox#287 · Opened Nov 28, 2022
@sqlcmdRI variable short. Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

microsoft/tigertoolbox#285 · 1 reaction · Opened Oct 14, 2022
Run for a specific schema Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#284 · Opened Oct 10, 2022
Columnstore Reorganize Option Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

microsoft/tigertoolbox#282 · Opened Sep 27, 2022
Error to execute the script when default trace file is being written Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#281 · Opened Aug 17, 2022
Running AdaptiveIndexDefrag on AWS RDS SQL Server Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#279 · 3 reactions · Opened Jul 8, 2022
Executing usp_AdaptiveIndexDefrag in a Azure Data Factory (ADF) activity Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#270 · Opened Apr 29, 2022
DB_NAME(@dbID) returns Null Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

microsoft/tigertoolbox#268 · 1 comment · Opened Apr 20, 2022
How long does this take to run? Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#265 · Opened Jan 13, 2022
Error Index Compression Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#260 · Opened Nov 18, 2021
Installing AdaptiveIndexDefrag in MSDB ONLY to Defrag Multiple Databases Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

microsoft/tigertoolbox#259 · 1 comment · Opened Oct 21, 2021
Suggestion - Update Statistics Only Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#254 · 1 comment · Opened Aug 26, 2021
AdaptiveDefrag @statsThreshold having no impact Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

microsoft/tigertoolbox#249 · 1 comment · Opened Jul 17, 2021
usp_AdaptiveIndexDefrag - Error 911 being reported when debug mode = 1 Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

microsoft/tigertoolbox#244 · 2 comments · Opened Jun 18, 2021
sop038-install-az diagnostic notebook syntax error Open

Difficulty 1/5 Under an hour Newbie friendliness 48/100

microsoft/tigertoolbox#241 · 1 comment · Opened May 5, 2021
usp_AdaptiveIndexDefrag - Problem with permissions in Azure Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#240 · 5 comments · 2 reactions · Opened Apr 26, 2021
Why doesn´t you permit to execute the rebuild on online mode on SQL Azure? Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

microsoft/tigertoolbox#238 · 2 comments · 3 reactions · Opened Apr 12, 2021
Adjusting fill factor based on table usage Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

microsoft/tigertoolbox#236 · Opened Mar 26, 2021
change tracking extended event status have more values Open

Difficulty 2/5 1-3 hours Newbie friendliness 42/100

microsoft/tigertoolbox#230 · Opened Dec 15, 2020
Max server memory computation Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

microsoft/tigertoolbox#229 · Opened Dec 14, 2020
ClearCacheOnTreshold suggestion Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

microsoft/tigertoolbox#228 · Opened Dec 7, 2020
Azure columnstore indexes Online mode Fixes Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#224 · Opened Nov 19, 2020
The format of the section performance check can be improve Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#223 · Opened Nov 18, 2020
SP - dbo.usp_AdaptiveIndexDefrag logging error - "Scope has changed. Forcing rescan..." Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#222 · 1 comment · Opened Nov 15, 2020
AdaptiveIndexDefrag: NVARCHAR sqlcmdRI to short for long database names Open

Difficulty 1/5 Under an hour Newbie friendliness 55/100

microsoft/tigertoolbox#221 · 1 reaction · Opened Nov 13, 2020
Section => Index_and_Stats_checks - Sub-Section => Statistics_to_update => Legacy => Duplicate records in resultset Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

microsoft/tigertoolbox#219 · Opened Nov 1, 2020
Section => Index_and_Stats_checks - Sub-Section => Statistics_to_update => sys.dm_db_stats_properties Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

microsoft/tigertoolbox#218 · 1 comment · Opened Nov 1, 2020
Can a database other than msdb be used? Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#217 · Opened Oct 22, 2020
Converting data types issues Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

microsoft/tigertoolbox#210 · Opened Sep 15, 2020
Multiple Logfiles - only the last counts into the calculation and t-sql advice Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#207 · Opened Sep 11, 2020
The definition of @ColumnStoreGetIXSQL is problematic on a case-sensitive databases - @minPageCount_In Open

Difficulty 1/5 Under an hour Newbie friendliness 72/100

microsoft/tigertoolbox#199 · Opened Jun 20, 2020
dbo.usp_AdaptiveIndexDefrag, incorrect definition for @rodmodctr variable Open

Difficulty 1/5 Under an hour Newbie friendliness 55/100

microsoft/tigertoolbox#198 · Opened Jun 20, 2020
[dbo].[usp_bpcheck] :: does not accurately detect MS Windows 2012 Open

Difficulty 2/5 1-3 hours Newbie friendliness 48/100

microsoft/tigertoolbox#197 · 1 comment · Opened Jun 11, 2020
Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log' Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

microsoft/tigertoolbox#196 · 2 comments · 1 reaction · Opened Jun 10, 2020
Issue with table level indexes. Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

microsoft/tigertoolbox#195 · Opened Jun 5, 2020
Pull request failing Open

Difficulty 3/5 1-2 days Newbie friendliness 15/100

microsoft/tigertoolbox#194 · 1 comment · Opened May 11, 2020
usp_AdaptiveIndexDefrag_Exceptions.sql ignoring spaces in table names Open

Difficulty 1/5 Under an hour Newbie friendliness 48/100

microsoft/tigertoolbox#193 · Opened Apr 20, 2020

microsoft/tigertoolbox

Get new issues in your inbox