Melissa Connors continues her compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.
Articles by Melissa Connors
Melissa Connors continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
July 6, 2015 | Melissa Connors | SQL Sentry, SQL Server, Data Compression, Fragmentation, Performance Analysis 4
Melissa Connors investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.
Top Categories
- SQL Server (229)
- SQL Sentry (156)
- Community (147)
- T-SQL (133)
- SentryOne (105)
- Execution Plans (67)
- Azure (63)
- SQLFamily (63)
- Monitoring (62)
- Plan Explorer (54)
- SQL Server 2016 (51)
- Performance Analysis (50)
- Performance (49)
- Cloud (47)
- T-SQL Tuesday (47)
- Career (41)
- Advisory Conditions (40)
- Alerting (39)
- Query Plan Analysis (34)
- System Configuration (34)
- Best Practices (33)
- Azure SQL Database (31)
- SQLVacation (31)
- PASS Summit (30)
- SQLSaturday (28)
- PASS (26)
- Security (24)
- Professional Development (22)
- Virtualization (22)
- #BackToBasics (21)
- Event Calendar (20)
- SentryOne Builds (18)
- Statistics (18)
- SQL Server Builds (17)
- Slide Decks (17)
- Wait Stats (17)
- DevOps (16)
- Documentation (16)
- Events (16)
- Global Partner Network (16)
- Indexes (16)
- Data Lineage (15)
- I/O (15)
- Engineering (14)
- PowerShell (14)
- Custom Conditions (12)
- Database Documentation (11)
- Extended Events (11)
- SSAS (11)
- Support (11)
- Windows (11)
- AWS (10)
- CPU Performance (10)
- Data Mining (10)
- Database Mapper (10)
- Database Performance (10)
- Fragmentation (10)
- Migration (10)
- PowerBI (10)
- Tips and Tricks (10)
- Bad Habits (9)
- SQLBits (9)
- Analysis Services (8)
- Baselines (8)
- Data Compression (8)
- DataOps (8)
- Disk Performance (8)
- Management Studio (8)
- Performance Monitoring (8)
- SQL Server 2014 (8)
- SQL Server 2019 (8)
- SSIS (8)
- Task Factory (8)
- Tech Outbound (8)
- tempdb (8)
- Disaster Recovery (7)
- Hardware (7)
- Memory Limits (7)
- Reporting (7)
- SQL Server Agent (7)
- SQL Server on Linux (7)
- SQLintersection (7)
- SSMS (7)
- #entrylevel (6)
- Backups (6)
- ColumnStore (6)
- Microsoft (6)
- Optimizer (6)
- SQL Server 2017 (6)
- SQL Server Training (6)
- SentryOne Test (6)
- Speaking (6)
- Trace (6)
- AlwaysOn (5)
- Automation (5)
- Availability Groups (5)
- Customer Success (5)
- EHO (5)
- ETL (5)
- In-Memory OLTP (5)
- Licensing (5)
- Machine Learning (5)
- Partner Spotlight (5)
- PostgreSQL (5)
- SQLCruise (5)
- SQLPASS (5)
- Securing Azure SQL Database (5)
- Service Packs (5)
- Ship Shape Challenge (5)
- Standard Edition (5)
- Table Variables (5)
- Testing (5)
- Training (5)
- Agile (4)
- Azure Data Factory (4)
- Compliance (4)
- Connect (4)
- Deadlocks (4)
- GDPR (4)
- Hyper-V (4)
- Installation (4)
- Managed Instances (4)
- News (4)
- Query Store (4)
- Query Tuning (4)
- SQL Sentry Essentials (4)
- SQL Server 2012 (4)
- SSRS (4)
- SentryOne Portal (4)
- Storage (4)
- Storage Forecasting (4)
- Transaction Log (4)
- Troubleshooting (4)
- Women in Technology (4)
- Agile at Home (3)
- Amazon RDS (3)
- Azure DevOps (3)
- CTPs (3)
- Cumulative Updates (3)
- DTU Calculator (3)
- Data Governance (3)
- Data Testing and Validation (3)
- Demos (3)
- Evaluating (3)
- Event Chains (3)
- MSP (3)
- Multi-Tenancy with SQL Server (3)
- SQL Monitoring (3)
- SQLskills (3)
- STRING_SPLIT (3)
- Server Health (3)
- Upgrade (3)
- User Guide (3)
- VMware (3)
- Visual Studio (3)
- Webinar (3)
- .NET (2)
- 11.2 (2)
- 4K (2)
- Azure Data Studio (2)
- Cardinality (2)
- DOC xPress (2)
- Data Dictionary (2)
- Data Trends (2)
- Delayed Durability (2)
- Developer Edition (2)
- Docker (2)
- Environment Map (2)
- HTAP (2)
- Key Lookups (2)
- Open Source (2)
- Partitioning (2)
- Pragmatic Works Software (2)
- Python (2)
- Reflection (2)
- Sabin IO (2)
- SentryOne Cloud Sync (2)
- SentryOne Docs (2)
- SentryOne EMEA (2)
- UDFs (2)
- Volunteering (2)
- Wildcard (2)
- Azure Table Storage (1)
- Blocking (1)
- CodeStock (1)
- DB Sentry (1)
- DBA xPress (1)
- DEVELOPMENT (1)
- Dash (1)
- Data Platform (1)
- Data Pros of Tomorrow Scholarship (1)
- Data Stewardship (1)
- Data and Schema Comparison (1)
- MAXDOP (1)
- Personal Development (1)
- Problem Solving (1)
- Process Improvement (1)
- Product Samples (1)
- Republic Bank (1)
- SQL Sentry Premium (1)
- SQL Server 2022 (1)
- SSDs (1)
- SentryOne Ambassadors (1)
- SentryOne Database (1)
- Tableau (1)
- Tabular (1)
- Triggers (1)
- how to implement multi tenancy (1)
- how to optimize database performance (1)
- perfmon (1)
- sql database optimization techniques (1)
- what is multi tenancy (1)
