LancetCare - Managed Services for MicroStrategy
POWERFUL ANALYSIS, ISOLATED INVESTIGATION & EXPERT ADVICE 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? LancetCare's™ Infrastructure Inspection will help identify your MicroStrategy platform's strengths and weaknesses.
POWERFUL ANALYSIS
The LancetCare Infrastructure Inspection is a comprehensive analysis of your BI infrastructure, from hardware to software to report performance - and beyond.
ISOLATED INVESTIGATION
Many users already know what their problem areas are. Point your LancetCare inspector in the right direction and we'll identify the cause of the problems, as well as provide solutions.
EXPERT ADVICE
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
Hardware Inspection
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.
Interview
Your key end-users and administrators will have the opportunity to express their specific concerns while answering exploratory questions from your LancetCare interviewer. This interview is typically conducted remotely.
Performance Inspection
Based largely on the outcome 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
Diagnosis
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
| Task | Inspection | Review | Audit |
|---|---|---|---|
| Review and Document Settings |  |
|
|
| Review and Document Project Settings | |
|
|
| Review and Document VLDB Properties | |
|
|
| Review Hardware Sizing | |
|
|
| Inspect Logs | |
|
|
| 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 Enteprise Manager Performance Monitoring Reports | |
||
| Thorough Examination of SQL on Top 10 Longest Running Reports | |
||
| Interview Administrators | Remote | Onsite | Onsite |
| Interview Developers | Onsite | Onsite | |
| Interview Key Users | Onsite | Onsite | |
ADDITIONAL SERVICES |
|||
| Database Analysis (SQL Server Only) | |||
| ETL Analysis |
|||