SentryOne Team Blog (

Category : Fragmentation

Finding Low Use Indexes via SentryOne

Finding Low Use Indexes via SentryOne

Andy Yun writes about one of his upcoming sessions for SQLBits and encourages everyone to take the time to find and clean up their low use indexes. For SentryOne users, Andy offers up sp_FindLowUseIndexesS1 to help you identify nonclustered indexes that are under used or not used at all.

Welcome to the Azure Marketplace

Mike Wood (@mikewo) introduces our first offering in the Azure Marketplace: a VM with SQL Sentry Performance Advisor, Event Manager, and Fragmentation Manager.

#TipTuesday Contest

From now until March 14th, you can win a $250 Visa gift card just by tweeting your tips about SQL Sentry software. Rick Pittser explains #TipTuesday…

Preview Support for SQL Server 2016

With the latest build of SQL Sentry software, v9.0.36.0, you will now be able to watch SQL Server 2016 instances. Read on for more details…

Applying Data Compression to the SQL Sentry Database : Part 2

Melissa Connors (@MelikaNoKaOi) continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.

Paul Randal : Mitigating Index Fragmentation

Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.

Connecting SQL Sentry to a Different Domain

Aaron Bertrand (@AaronBertrand) shows how to use the RunAs command to connect the SQL Sentry Client, Plan Explorer, or SSMS to a database in another domain.

Paul Randal : Unexpected Clustered Index Fragmentation

Paul Randal (@PaulRandal) of SQLskills describes several ways clustered index fragmentation can sneak up on us, and how it can impact your workload.

Erin Stellato : Proactive SQL Server Health Checks : Maintenance

Erin Stellato (@erinstellato) of continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.