Hi Brad,

Thanks for the reply, yeah, I re-initialized and it brought the record over. Was kind of hoping it would be clever enough to resolve the missing record its...

Thanks Gail,

I did think it was a little strange for the tempdb transaction/sec to be directly related to the fullscans/sec.

Although as you point out the procedures may be causing the...

Hi George,

thanks for letting me know that.

The figures from both now match up (my mistake) so thank you both for your help with this.

Once again Grant, many thanks for the additional info.

I'll be sure to try and find additional info regarding 'sys.dm_io_virtual_file_stats instead', however the interesting thing is that the values returned are...

Hi Grant,

Thanks for the reply, it's a good point you make about the constraints etc, do you know if it is possible to reset the values returned from the function,...

Hi Ellie,

Thanks for the reply, i've got the second and third books. Both are good books but I think you may have found a winner with the first link,...

Will do Brandie.

Thanks again.

Hi,

Thanks for the response, you make a good point about the transaction files.

As you point out "it all depends", so I think I'm going to gather some additional requirements and...

Hi,

Yes, original I just looked at the total, then to try and find the cause I added the user db's and the temp db.

As mentioned the tempdb accounts for approximately...

Sorry, should of done that in the original post.

The version number is 9.00.3042.00 (SP2) - none of the cumlitive updates have been applied to this.

The table that I beleive is causing this issue has a TEXT column in it.

It's a bit of an open ended question but what exactly is happening when this error...

It's certainly a strange one.

I cant find anything in either the SQL logs or the Windows logs. I'll shortly be posting the logs up so hopefully someone maybe able...

Thankyou both for the reply.

Your help is much appreciated.

Jackal

Hi Gail,

Thanks for the response, the SQL logs show the error occuring at 6.01pm, then transaction log backups at 7.00pm and then the actions involved with restarting SQL. Other...

Hi, scrub that comment.

Think I have it now, had to move a few bits and bobs round but it seems to be on the right lines now.

Thanks again for you...