since about one week our main App behaves strange. Every thing you do (e.g. Open Script, Open Table Structure, Open Object Properties, Switch to another tab....) takes considerably more time than before. If you open the Task Manager you can see that the CPU goes to 100% at that time. RAM is about 20% so thats not an issue.
Have restarted the whole Server - still the same.
Facts: - .qvw Size is about 460 MiB
- 11.2 SR 10
- Winodws Server 2008 R2 64 bit
- Data Model has one SynKey. This key has been there since the first start.
Can sombody help me?
edit: I have to say that its not always like that. Sometimes it behaves normal = fast.
In general objects which aren't displayed won't be calculated and if there aren't any selections to be calculate the cpu consumes should be by 0%. But there are exceptions by variables, trigger, calculations within object-title and probably some more which will be more or less continuously calculated. If such calculation includes synthec keys or are going over loosen tables or the system date/time will permanent accessed - they could never ending.
I think you should check these. Maybe it's easierto check in a large app if you worked in copies from the file and removed and/or reduced tables/fields/objects/variables step by step ...
Anothing point could be the system from your server - is it physically or virtual. If it's virtual and some settings had change it could be have heavy effects.
Per access point is ok. but per local fat-client or with fat-client opened on qv server is slow, right? Are all services and the fat-client on the same virtual server? Are there changes with the settings from the vm? Are there upgrades on another qv services release? Releases from server and fat-client are the same?
Such a change in service release could be cause these differences. Are you sure that the app worked fine within the first 4 weeks after the upgrade? Was on any reason made a reload + save with the fat-client instead of a server update task? Have you an older backup from the app which you could compare against the current one?
This table has about 60M Rows and 230 columns. But since its build by several smaller fact tables by using concatenate, it consinsts of many 'null' values.
So, we wrote this table into a .qvd file (yielding in 14GB file size and a RAM footprint of ~16GB).
I went home with this file and opened it on my PC (Intel Xeon 3,3Ghz, 4Cores+4HT, 16GB RAM, fresh .qvw file). Used the 'First' command to keep the RAM footprint under 16GB but it had the same symptoms as the virtual machine with AMD CPUs.