thanks for everyones tips.

It turned out to be an execution plan that was changing as a result of a index.

We now run this index script daily

ALTER INDEX ALL ON dbo.PS_CI_SP

REBUILD...

We are working with MS support. Support agrees that there is a problem with the memory and they are looking at our logs

Bru,

From the screen shots that I have posted, would you agree that something looks wrong with the amount of memory being used?

We really never change any settings on the DB.

2 weeks ago, the snap manager (san drive stuff) software was updated. Then last weekend Microsoft server updates were installed.

We are...

I have attached the results

thanks

thanks for the tips everyone.

Today it is running quickly again. I believe that it is caching issue on the peoplesoft application server side.

thanks for the input Lowell

I just ran "sp_updatestats" and it did not make any difference.

Any other ideas?

No help needed. I found a work around.

The double new line was created by combining 3 text files. So instead of combining the 3 text files then doing 1...

Additional info.

Last week, another DBA tested an administration software by Idera. The software was supposed to test the security of our sql servers. Well during testing, it found...

my experience:

2 years+ of web developement in smaller companys

1 year as "Computer Operator" at large company, and then promoted to Associate DBA.

I don't think that a company will hire you off...

thanks for your help

i spoke with our dba and he said that it did not have to be exact. he suggested something like:

select datediff(dd,'2006-01-01', getdate()) / 7 * 5