I spent some time evaluating the produt whilst in beta. It works - does what it says. For the project I was working onI could not justify the...

Looks like we may have found the cause.

Initially we could not find any blocking - however this morning we have used OSQL to run the stored procedure in question 10...

Klaas-Jan

We are seeing this variaation in query response time when the query is run locally on the server - this rules out any network issue.

Thanks for the reply

Tim

Andy

I am curious - why do you say

"identical query plans may not be a good thing?"

Tx

Tim

An update to this:

Deleting the multiple versions worked!

One month on and there have been no more reports of this error.

Thanks Antares

Solart,

Thanks - I hadn't considered the caveats of Autoshrink.

However just checked and, in this case, autoshrink is is set to false on all the user databases

Performance problem is still...

Another update

DBCC SHOWCONTIG on the indexes for operations with greatest cost showed Scan Density of nearly 100%. I have found one or two indexes that are fragmented - but...

Quick update:

Execution plan for the query is identical every time - and no variation in the subquery costs or the cost of individual operators within each query

T

Antares and Andy

Thanks for the replies.

I too thought that SQL memory could be the issue here, but an average of 99.85 % for the Buffer Cache Hit Ratio speaks for...

Hi,

Thanks for the reply - I'll get rid of old versions - wait a couple of months and see what happens

Whilst searching for information on this...

Hi

Copy the book.mdf to the test server then

use sp_sttach_db to attach the mdf file to the book database on the test server.

More information from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Tim

If it all worked - how many of us would not have a job

Tim

Hi,

We have a package that runs every day - 99% of the time it runs with no error - then out of the blue we get the following error;

DTSRun:

Loading... ...

I am surprised there is no mention in this topic of transactional replication with immediate updating subscribers and queued updating in case of fail-over (optionally using MSMQ).

Its more...

Guys

Thanks - at least I know it is somthing that I am doing that is wrong

I wish I could remember what the specific errors were -...