Concurrency

Database
Enthusiast

Concurrency

How to find out concurrency between two Teradata servers if one server workloads needs to migrate to second server in case of fail over. 

Any suggestion and pointers will be greatly appreciated.


Accepted Solutions
Senior Apprentice

Re: Concurrency

Hi,

 

I'm not sure 'concurrency' is the correct word here. However,

 

When you're trying to see if a single TD system can handle the workload that currently runs on two then these are the sorts of things that you need to consider:

  1. Look at Resusage data for cpu utilisation, AWT usage, IO traffic across time.
  2. Use DBC.LogonOffV to look at concurrent sessions across time. For any given TD configuration there is a maximum number of sessions that can be logged on.
  3. What are the TASM/TIWM settings like for the two systems? What would have to be done to make those compatible?
  4. What about disk space usage? Is there enough space for the data from both systems (if it isn't already the same).
  5. What about security? Are the AccessRights and Roles on the second system going to work for applications from the first.

 

...plus a few other areas...

 

For all of the above: Can your second system handle the combined amounts of the two existing systems?

 

This is a big subject. You are probably better off talking to your TD account team, they probably ave an idea about what currently happens on your system.

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: Concurrency

Hi,

 

I'm not sure 'concurrency' is the correct word here. However,

 

When you're trying to see if a single TD system can handle the workload that currently runs on two then these are the sorts of things that you need to consider:

  1. Look at Resusage data for cpu utilisation, AWT usage, IO traffic across time.
  2. Use DBC.LogonOffV to look at concurrent sessions across time. For any given TD configuration there is a maximum number of sessions that can be logged on.
  3. What are the TASM/TIWM settings like for the two systems? What would have to be done to make those compatible?
  4. What about disk space usage? Is there enough space for the data from both systems (if it isn't already the same).
  5. What about security? Are the AccessRights and Roles on the second system going to work for applications from the first.

 

...plus a few other areas...

 

For all of the above: Can your second system handle the combined amounts of the two existing systems?

 

This is a big subject. You are probably better off talking to your TD account team, they probably ave an idea about what currently happens on your system.

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Enthusiast

Re: Concurrency

Thanks Dave.