microsoft azure-sql-tips issues

microsoft / azure-sql-tips

A T-SQL script for improving database configuration and design in Azure SQL DB.

https://aka.ms/sqldbtips

MIT License

144 stars 51 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Add a tip for memory-optimized tables with LOB columns

#70 dimitri-furman opened 2 years ago
0
Fix 1520 to consider remaining contiguous sequence range, not full sequence range

#69 dimitri-furman closed 2 years ago
1
TipID 1520 - Doing wrong comparison and calculation

#68 ClaudioESSilva closed 2 years ago
5
This repo is missing important files

#67 microsoft-github-policy-service[bot] closed 2 years ago
0
Adding Microsoft SECURITY.MD

#66 microsoft-github-policy-service[bot] closed 2 years ago
0
Fixed 1290, small changes to output of 1180 and 1320

#65 dimitri-furman closed 2 years ago
0
Wrong table size filter expression in tip 1290

#64 EitanBlumin closed 2 years ago
1
For 1180, add filters for minimum number of pages and minimum read percent

#63 m60freeman closed 2 years ago
6
Fixed output when memory-optimized tables are present, added new tip

#62 dimitri-furman closed 2 years ago
0
Added new tips

#61 dimitri-furman closed 3 years ago
0
Add a tip for untrusted constraints

#60 dimitri-furman closed 3 years ago
0
Add a tip for identity or sequence-based columns that are close to running out of numbers

#59 dimitri-furman closed 3 years ago
0
Add a tip for non-unique clustered indexes

#58 dimitri-furman closed 3 years ago
0
Add a tip for indexes with low fill factor

#57 dimitri-furman closed 3 years ago
0
Add a tip for disabled indexes

#56 dimitri-furman closed 3 years ago
0
Add a tip for indexes with excessively large keys

#55 dimitri-furman closed 3 years ago
0
Add a tip for database-column collation mismatches

#54 dimitri-furman closed 3 years ago
0
Added max local storage tip (1450)

#53 dimitri-furman closed 3 years ago
0
Added 1440, misc fixes and improvements

#52 dimitri-furman closed 3 years ago
0
Add a tip to find indexes with row or page locks disabled

#51 dimitri-furman closed 3 years ago
0
High query compilations tip, misc fixes

#50 dimitri-furman closed 3 years ago
0
Tips inside "groups" cannot be toggled independently

#49 EitanBlumin closed 3 years ago
2
Improved tips for readable replicas, bug fixes

#48 dimitri-furman closed 3 years ago
0
Fixed to evaluate more tips with lower permissions

#47 dimitri-furman closed 3 years ago
0
Improved tempdb space tips

#46 dimitri-furman closed 3 years ago
0
Improved details and perf for several tips

#45 dimitri-furman closed 3 years ago
0
Improved details for 1180 and 1310

#44 dimitri-furman closed 3 years ago
0
Improved output details for IO RG tips

#43 dimitri-furman closed 3 years ago
0
Fixed arithmetic overflow

#42 dimitri-furman closed 3 years ago
0
Better handling of lock timeouts and skipped tips

#41 dimitri-furman closed 3 years ago
0
Improved support for tip exclusions

#40 dimitri-furman closed 3 years ago
0
Added a tip for many non-indexed tables

#39 dimitri-furman closed 3 years ago
0
Support for tip exclusions, compat level 100

#38 dimitri-furman closed 3 years ago
0
syntax error

#37 JanosBerke closed 3 years ago
3
Add a tip for databases with many tables that have no indexes

#36 dimitri-furman closed 3 years ago
0
Added support for running with lower permissions, added stale stats tip, changed result set order

#35 dimitri-furman closed 3 years ago
0
Allow checks to show "failed due to permissions" instead of not running any of it

#34 wsmelton closed 3 years ago
8
Split calls for database and system level views

#33 wsmelton closed 3 years ago
1
Updated readme

#32 dimitri-furman closed 3 years ago
0
Add a tip for some stale stats cases

#31 dimitri-furman closed 3 years ago
0
Allowed lower permissions on some SLOs

#30 dimitri-furman closed 3 years ago
0
Added event_age to 1380, simplified 1320

#29 dimitri-furman closed 3 years ago
0
Tip 1320 on Top Queries shows up always and doesn't include query_id from Query Store

#28 rgward closed 3 years ago
9
Create a Powershell commandlet

#27 yorek opened 3 years ago
0
Create an AZ CLI extension

#26 yorek opened 3 years ago
0
Added top queries tip

#25 dimitri-furman closed 3 years ago
1
Update get-sqldb-tips.sql

#24 dimitri-furman closed 3 years ago
1
Update get-sqldb-tips.sql

#23 dimitri-furman closed 3 years ago
1
Update get-sqldb-tips.sql

#22 dimitri-furman closed 3 years ago
1
Update get-sqldb-tips.sql

#21 dimitri-furman closed 3 years ago
1