need help

I want to configure new 64 bit server. my db size is around 50GB (one db)
my server has 4 cpu(64bit)
how many RAM I must buy to our new server to work with performance?
thanks
Hi
The amount of memory you use will depend on what the workload is and what
your predicted workload will be! I would say get at least as much as you
currently have plus an amount for any anticipated growth! To try and future
proof yourself you may want to make sure that you have the ability to add
more memory in the future.
You may want to consult the hardware vendor to see what they would recommend.
John
"Cenk FIRAT" wrote:

> I want to configure new 64 bit server. my db size is around 50GB (one db)
> my server has 4 cpu(64bit)
> how many RAM I must buy to our new server to work with performance?
> thanks
>

need help

I want to configure new 64 bit server. my db size is around 50GB (one db)
my server has 4 cpu(64bit)
how many RAM I must buy to our new server to work with performance?
thanksHi
The amount of memory you use will depend on what the workload is and what
your predicted workload will be! I would say get at least as much as you
currently have plus an amount for any anticipated growth! To try and future
proof yourself you may want to make sure that you have the ability to add
more memory in the future.
You may want to consult the hardware vendor to see what they would recommend.
John
"Cenk FIRAT" wrote:
> I want to configure new 64 bit server. my db size is around 50GB (one db)
> my server has 4 cpu(64bit)
> how many RAM I must buy to our new server to work with performance?
> thanks
>

need help

I want to configure new 64 bit server. my db size is around 50GB (one db)
my server has 4 cpu(64bit)
how many RAM I must buy to our new server to work with performance?
thanksHi
The amount of memory you use will depend on what the workload is and what
your predicted workload will be! I would say get at least as much as you
currently have plus an amount for any anticipated growth! To try and future
proof yourself you may want to make sure that you have the ability to add
more memory in the future.
You may want to consult the hardware vendor to see what they would recommend
.
John
"Cenk FIRAT" wrote:

> I want to configure new 64 bit server. my db size is around 50GB (one db)
> my server has 4 cpu(64bit)
> how many RAM I must buy to our new server to work with performance?
> thanks
>

Need a list of Error Code

Hi,

When we configure a transformation to redirect the error record, SSIS gives 2 columns: 'error code' and 'error column'. In one article, I have seen how to get the error description using the 'error code'.

My questions are,

Where I can get list of all possible error codes? 'error column' gives the id of the column. How to get the name of the 'error column'?

Thanks.

Basically you need to know the metadata of the normal output, not that easy, but simon has wrapped this up in a Tx.

http://sqljunkies.com/WebLog/simons/archive/2005/12/15/SSIS_Enhanced_Error_Component.aspx

Some related info -

http://msdn2.microsoft.com/en-us/library/ms345163.aspx

The SSIS error codes are listed in BOL. I also have them on my wiki, because BOL only got them in an update and I wanted them before that, and also you can add notes on the errors on the wiki.