MicroStrategy® Infrastructure Inspection
Keeping your Business Intelligence (BI) infrastructure running efficiently, reliably and consistently is crucial to your overall success. BI initiatives suffer from performance issues caused by poorly architected infrastructure, but how can you make sure you're using best practices before something goes wrong? Lancet's Infrastructure Inspection will help identify your MicroStrategy platform's strengths and weaknesses.
The Lancet's Infrastructure Inspection is a comprehensive analysis of your BI infrastructure, from hardware to software to report performance - and beyond.
Many users already know what their problem areas are. Point your Lancet inspector in the right direction and we'll identify the cause of the problems, as well as provide solutions.
Our seasoned, vendor-trained and certified staff average 15 years of experience. They have worked with some of the most complex and demanding BI infrastructures in the industry.
HOW IT WORKS
You'll complete a brief, but in-depth survey about your hardware specifications. We will compare your environment with industry-set best practices and deliver your results with our recommendations.
Your key end-users and administrators will have the opportunity to express their specific concerns while answering exploratory questions from your Lancet interviewer. This interview is typically conducted remotely.
come of your interview, Lancet experts will remotely inspect your configuration settings for weakness. A typical inspection includes:
- Review of System Settings
- Running Baseline Reports
- Analyzing Log Files
- Review Report Design & SQL
Based on the findings, your LancetCare expert will provide you with not only our recommendations for improvement, but a detailed roadmap for implementation. Here are a few things you can expect to receive upon completion of your inspection:
- Server Workbook
- Software Recommendations
- Implementation Road Map
- Performance Baseline Report
- Training Recommendations
- Configuration Reference Guide
- Hardware Recommendations
- Configuration Recommendations
MICROSTRATEGY INFRASTRUCTURE TASK MATRIX
|Review and Document Settings|
|Review and Document Project Settings|
|Review and Document VLDB Properties|
|Review Hardware Sizing|
|Baseline Performance - SQL, Desktop, and Web|
|Documentation of Log Messages|
|Intelligence Server CPU and Memory Analysis Reports|
|Optimize Enterprise Manager Data Warehouse|
|Review Security Model|
|Usage Trend Reports|
|User Adoption Tracking|
|Database Trending - Which Tables are Being Accessed|
|Detailed Report Running Analysis (Queue time, SQL time, Analytical Engine, etc.)|
|Review Data Model|
|Create Enterprise Manager Performance Monitoring Reports|
|Thorough Examination of SQL on Top 10 Longest Running Reports|
|Interview Key Users||Onsite||Onsite|
|Database Analysis (SQL Server Only)|