Dear Kevin,

1. Ok. I will set max value to 2GB and monitor how it goes

2. I checked (netstat -t) TCP Chimney and is off

3. Meantime, I asked from customer to...

Dear Gevin,

my replies below:

1) do you have max memory for sql server set?

No, because memory is only 3 Gbytes. No min or max values.

2) Is TCP Chimney on?

No, because we...

Dear Grant,

thank you very much for your suggestions. What I found very interesting is to compare the execution plan of the query we suspect before and after performance degrade. The...

Dear Grant,

regarding your first issue. Every night we run a maintenance plan where we rebuild all indexes. By the way, since we rebulid is it necessary to Update statistics ?

Regarding...

Ok. To be honest I didn't like to backup to a local drive and then move the files to a network drive. I tried to find an one step solution.

Anyway,...

Basically I have two options for SQL service:

1.Built in account (Network service, Local system, Local service)

2.This account

Cuurently, I use first option and "Local system" but the drive is not accesible....

As the topic says I need to have a network backup. I need to backup sql db to a network drive. To my knowledge, the sql server service should run...

Hi Gail,

ok the trigger is fired when a new row is inserted to SQL View. Since the View is bounded to Oracle Table, I thought when a new row is...

Hi,

Oracle comes with SAP so its a critical system...! We already have a job that we scheduled to run every 5 minutes. The job covers completely what we need to...