If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Poor Performance running Win2008/SQL2008R2 and 10.1.1 FP3

Started by Pedro, 10 Sep 2014 05:35:41 AM

Previous topic - Next topic

Pedro

Hi All.

I am wondering whether anyone can please help me. We have recently created a new virtual environment running SQL2008R2 & Windows 2008 & CEP 10.1.1 FP3. As part of our plan to move away from an aging platform.

On testing this environment I have noticed that it is slower than our existing SQL2005/Windows2003/10.1.1 FP2 environment. The performance issue is noticeable for end users (i.e. opening data) and for admin users (i.e. navigating around the admin console).

An example of the performance issues is as follows: the time it takes to edit a macro step via the admin console (where the step is a simple GTP step) takes 25 seconds on the new (SQL2008R2 / Win 2008) environment whereas it only takes 5 seconds on our SQL2005/Win2003 environment.

We have checked that there is no resource issue on the servers and have also checked whether anti-virus is to blame but no joy. The specs of the two environments are the same (with the exception of the database server which has double the RAM on the new environment).

Has anyone else observed a general deterioration in system performance whilst moving away from Windows 2003 & SQL2005? Any observations would be gratefully received.

Thanks

SomeClown

Was the old environment on the same VM host?  If not, that's likely your issue.  Planning does not behave the same as other transactional systems so hosting it on an over-provisioned VM host will cause issues.   When I've seen these kinds of issues on upgrades, it's been more about the hosting platform and not the OS/DB version.  If it's the same host, the new servers may have put too much load on the host.

Related to that, check your network bandwidth from the host -- I've also seen these issues when too much traffic from the host is trying to go through the network interface and traffic is getting choked. If the timings are all from client machines, you may want to compare timings from running on the server versus from the client.  A difference there would point to networking issues

Pedro

Hi

Thanks very much for the reply.

I have checked with our team that the hosts are OK and they have confirmed no network related issues.
One other thing to mention is that our new environment is 64 bit whereas the older environment isn't.

Pedro

SomeClown

The bitness may have some impact - I seem to recall that there was some slowdown due to that but the difference is larger than I remember.

If you really want to chase it down, have the server team dedicate one or more CPUs to your VM and see if that makes a difference.  Issues from hosting on VM don't show up anywhere you can find them (perf stats all look good, no contention, queuing, etc).  Most client that had this issue had that same feedback from the server team -- it was a common response that I heard a lot.

Pedro

Thanks very much for your feedback. I'll follow up with our support team and will add an update as and when I get one.