Archives of the TeradataForum

Message Posted: Sat, 22 Jun 2003 @ 01:24:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, June 19, 2003 08:37 -->

Capacity Planning is an Art and not so much a science to me. There are many things we look at. We run through Unix cron scripts that capture a space report every day and load it into a Teradata table. From there I can check to see what growth is like for the overall system. This can be broken down by table or by Application. We interview our clients to see how data will be added over the next 18-24 months for each of these applications. We can compare it to what we have seen for historic growth and make some decisions about space.

I run a 'whoson' script every ten minutes that goes against dbc.sessioninfo. This allows me to see what my level of concurrent users is during peak times. I can trend this over the past 18-24 months. I also do a count of dbc.users to see how many users I have on the box and store all this stuff in Teradata tables too. I can report on how many new users have been added over time. I check with the users to see if how many more 'locusts' they will be adding for existing and new applications.

I look at Ampusage and Resusage and chart how much time our box is running at 90-100 utilization. How much time our box is running between 80-90 utilization and so on. I can report if these windows are growing which to me means we are taking longer to do our work.

I run canary queries to measure response time is it getting worse? Is it tolerable? I capture spool space usage and chart it to.

The biggest thing to remember is to ASK YOUR USERS how many new locusts are you adding, how much new space do you old apps need , how much space do new applications need. What is realistic response time? What is perceived response time?

I have looked at vendor packages and they are only as good as the time you take to care, feed and analzye them. If you feed them and read them and watch them over time they can and will tell you the same things you can gather for free if you just take the time to do it.

	<Prev	Next>		<<First	<Prev	Next>	Last>>