Ok, of course... I did not think about the ghost records...

I tried forcing the ghost cleanup process using::

DBCC ForceGhostCleanup;

But it does not seem to have an effect..?

Hi,

The shrink commands I used were:

DBCC Shrinkfile(dataFileNameHere,1)

DBCC Shrinkfile(logFileNameHere,1)

DBCC Shrinkdatabase(databaseNameHere)

The result of the query:

FileSizeMBUsedSpaceMBUnusedSpaceMBDBFileName

341463.06120929.25 220533.81 ***data

132.88 7.75...

Hi,

Thank you for the replies.

Some answers to your questions:

The wait types I see are CXPackets.

I see a lot of parallel queries during this time - the same parallel queries we...

Just some feedback on this - I manged to resolve the issue....

It was the service broker...

We send XML messages in our broker and ever since the creation of our broker,...

Thanks Vegard, just a quick question:

What is the impact of the service broker on the tempdb?

I have, amongst others, 2 DB on this server - one is the application database...

Hi,

Thanks so much for your input - I have unfortunately not received much help from the VM admin - he has this attitude of "It must be SQL". So...

Hi,

Yes I do have tables that reference this ID Primary key column.

So I guess I will go to BIGINT then?

Thanks again everyone

Hi,

Yes HowardW, you are correct - reseeding won't work because of the records and their relevant ID values that remain after the DELETE.

I was also thinking of the possibility of...

Hi,

Yes I am sure of the location and the file name and extension.

When I try doing the same from our QA server,it works fine, but from our production cluster, I...

There is a clustered index on this column and I have added an ORDER BY to confirm that IDs are skipped.

There are many constraints on this table as well.

What is...

There are definitely no other files on that drive besides the data files. I have no idea why this is happening.

There are not maintenance that would shrink a data...

Thought I would share with you all .... I resolved the issue.

It was the [LinkedServer] that used the SA login as the security credentials.

I replaced that with an alternative login,...

I found my problem - there was a space at the end of the DB name - silly me.

removed it - all worked fine

thanks

I managed to get the URL - here are the steps, should you be interested

Start - Control panel - Admin Tools - IIS - Expand Web Sites - Expand Report...

I forgot to mention this is SSRS 2005