Skip to content
John Perry

Business Intelligence, Data Warehousing, and beyond…

Primary Menu
  • Home
  • About
  • Contact

Day: August 21, 2015

  • Home
  • 2015
  • August
  • 21
By John Perry August 21, 2015January 29, 2019 Database Administration

CXPACKET Waits and High CPU Usage

Photo by Sarah Klockars-Clauser Scenario Your SQL box has consistently high CPU usage, possibly pegged at 100%. You look at your favorite DMV or (god forbid) Activity Monitor and see one or more active queries with a CXPACKET wait type. What do you do??? (Try not to Google it.) Solution I specifically

Continue Reading
Load More Posts
Categories
  • Database Administration
  • ETL
  • MicroStrategy
  • Software Engineering

You may also like

By John Perry December 29, 2017January 29, 2019 MicroStrategy

How to Increase MicroStrategy Mobile Performance

While desktop users are accustomed to waiting for large reports and dashboards to load, mobile users expect nearly-instant results. Getting those results can be a challenge, and since MicroStrategy doesn’t offer many tips to increase or improve mobile performance, I’ll share a few nuggets I’ve learned from my experience optimizing

Continue Reading
Database Administration

DBA Tools of the Trade: SQL Job Visualizer

ETL

Debugging and Troubleshooting Code in SSIS Packages

Database Administration

CXPACKET Waits and High CPU Usage

John Perry

Business Intelligence, Data Warehousing, and beyond…

Copyright All right reserved. Theme: Knight by Themeinwp

How to Increase MicroStrategy Mobile Performance

DBA Tools of the Trade: SQL Job Visualizer

Debugging and Troubleshooting Code in SSIS Packages

CXPACKET Waits and High CPU Usage

MicroStrategy Information Window INCEPTION

Failing Backups and FlushFileBuffers

Design Patterns Quick Reference