Hi,

I'm not sure how the memory could be a problem.

When I clear the cache it is back up to 4gb again within a short period (e.g. an hour or less)...

Hi,

I totally agree - I am now at the last resort phase!

We simply cannot have a database which slows down after 3-10 days.

I have looked at the statistics, but i'm...

Hi,

After some research my next step is to try

DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’)

And see if that has the same effect as DBCC FREEPROCCACHE

Right now the tokenandpermstore cache is 791mb/1874000 entries and...

Hi,

If you are getting tcp/ip issues on the client then this would indicate that it is more of a network issue rather than a db issue.

If you are using a...

Hi,

Simply because it works.

'if it aint broke don't fix it'

This is a heavily used production system. To upgrade you have to pause mirroring and disconnect the mirror. If we got...

Hi,

I have found the cause of this for anyone who is interested.

It is a faulty raid battery on the mirror server. This causes the raid on the mirror to use...

Hi,

Failing over to the mirror speeds up the database to 0.2s.

Having said that though, I have a new idea....

At around the same time this started, one of the data centers...

Hi,

I have not looked into disk or network activity - I have played around with perfmon in the past, but tbh don't find it very useful at all. (Perhaps due...

Hi,

I have done a lot with the sql profiler, but it has not got me any further.

One problem with the profiler is that the system runs about 1000 queries a...

Hi,

Thanks for the reply.

We are on sp2 + a few hot fixes.

Presumably it must work for some people, otherwise what would be the point of having the option? I have...

Hi,

I take the point, however we are currently experiencing a slowdown at around a week, which if we do not intervene will grind to a halt.

It really can't be much...

Hi,

Thanks for your fast reply and I understand your response.

I have 2 problems with this...

1. It is Sql 2005 which does not have the 'optimize for ad-hoc workloads'

2. Our production...

Hi,

I think I have found the problem but need further advice.

After a lot of research I came to the conclusion that because all the queries are ad-hoc queries, it is...

Hi,

The cache must empty when failover occurs as queries take ages to run for a couple of minutes until the cache is repopulated.

Seeing as the cache is mostly in memory,...

Hi,

Thanks for all the replies..

I think you are right in that the best solution is probably to get a consultant on board who can really look into this properly.

All the...