You can translate the question and the replies:

Data Virtualization Software Issue in Data Centre - Need Assistance

Hello Denodo Community, I hope you're all doing well. I'm currently facing an issue with data virtualization software in my [data center](https://www.lenovo.com/us/en/servers-storage/) and I'm seeking some assistance from the community. Here's a brief description of the problem I'm encountering: I have implemented a data virtualization solution using Denodo in our data centre environment. The software was functioning smoothly until recently when we experienced some unexpected performance degradation. Queries that used to execute quickly are now taking significantly longer, affecting our overall data access and delivery timelines. I have already checked the hardware resources and network connectivity within the data centre, and everything seems to be functioning properly. Additionally, there haven't been any significant changes to the infrastructure or software configuration recently. To troubleshoot the issue, I have reviewed the Denodo logs, but I couldn't identify any obvious errors or warnings that could explain the performance decline. I have also optimized the queries and verified the underlying data sources to ensure their performance is not causing the issue. At this point, I'm seeking advice and suggestions from the community. If any of you have experienced a similar problem or have insights into potential causes and solutions, I would greatly appreciate your input. Here are a few specific questions I have: Are there any known performance bottlenecks or common issues that can affect data virtualization software in a data centre environment? Are there any specific configuration settings or best practices that can optimize the performance of Denodo in a data centre setup? Are there any recommended tools or techniques to diagnose and troubleshoot performance issues within the Denodo environment? Any guidance, recommendations, or personal experiences related to this issue would be highly valuable to me. I'm eager to get our data virtualization solution back on track and ensure smooth operations within our data centre. Thank you in advance for your assistance and support!
user
07-07-2023 04:03:14 -0400
code

1 Answer

Hi, I think the following Expert Trails will answer your questions. Expert trails guide Denodo users through all the relevant materials related to a specific topic. * The first Expert Trail is: [Expert Trail: Query Performance Optimization](https://community.denodo.com/expert-trails/view/document/Expert%20Trail:%20Query%20Performance%20Optimization). * The second Expert Trail that I’d check: [Expert Trail: Monitoring](https://community.denodo.com/kb/en/view/document/Expert%20Trail:%20Monitoring?category=Expert+Trails). Also, I’d check the following sections: * [ Hardware Requirements](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/preinstallation_tasks/hardware_requirements/hardware_requirements) section of the Denodo Platform Installation Guide. * [Memory Management](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/memory_management/memory_management) section of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
10-07-2023 04:50:33 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here