Ok its worked! One i wont forget!

So all I have to do now is re-instate all the FK, PK and Indexes and Move the documents table back from an ndf...

The rebuild index did not work, but ....some good news... 😀 I have dropped all FK's, Indexes and PKs from every table, ran an update usage and have started a...

hmmm I had started to script out all the indexes to drop them, shrink db then re-create... but i'll prob end up trying both as I still dont hold out...

I have used both tsql and gui and there is no difference in the result- gui just disapears after few mins, and in query analyser its just returns the file...

It would also appear that the updateusage did work and released the reserved pages correctly.. so I know that they are free..

DBCC UPDATEUSAGE: sysindexes row updated for table 'DOCUMENTS' (index...

I have just tried this and it works fine via linked server...

select top 10 image_data from [server].database.dbo.Documents where DATALENGTH(IMAGE_DATA) is not null

I have specified new values to shrink the file to , tried just taking 1Gb off, then 20GB then 200Gb but still no difference..

As I mentioned I have been doing...

Still think i'm being misunderstood, the memory allocated is 24GB this is fine and as expected as its the Max Server Memory...

The problem is that 75% of that 'allocated' memory...

Hi, you say this is normal behaviour but no other server holds this memory as 'used'. All our servers have min and max memory set and lock pages in memory...

Yep our SAP folk have done exactly that too, when i questioned they said that is sized as expected and doesnt need altering and wont need to have auto increase.

select si.name, so.name, so.crdate from sys.sysindexes si inner join sys.sysobjects so on si.id = so.id

where si.first is not null

and

si.name = 'your index name'

and

so.name = 'your table name'

Providing you have...

I think then DMV and Profiler would give you all the information you need.

If you use standard template in Profiler and select some events like;

Stored Procedures:

RPC:Completed

SP:Completed

SP:StmtStarting

TSQL:

Exec Prepared SQL

SQL:StmtCompleted

Plus any other...

There are many products out there, why are you loathed to use activity monitor?

..combined with SQL 2005 DMV's and SQL Profiler this will give you a good overview.

also

Yes it can but the developer needs to add this in as i mentioned earlier..

... using the Event Handlers section in SSIS. This enables you to create on event actions...

Hi There,

We have been using Idera Diagnostic Manager from Idera for over 18 months and it has been excellent. http://www.idera.com/Content/Home.aspx

We also use SQL Safe and SQL Defrag, and...