skyline6969 (6/23/2009)
One other change that may be needed is that not all the Data presented is an offset, some cleaning may be required withDELETE FROM Iops WHERE SUBSTRING(Detail, 1, 6) 'Offset'
where access appears to be denied otherwise the SUBSTRING section will fail on occasions.
or adding in another filter for Detail beginning with "Offset"
This may have been caused as I added in .ldf files also. Log files shows a very marked contrast to Data mdf files as the block size changes a lot and the tempdb can write a large amount of data out in quite large blocks for database.
Ok, got past that part.
The Delete helped.
I also had to change the Update statement from INT to BIGINT.
When I ran the IOCount though I end up with
34,818 that have IOSize of 8.
54,401 that have IOSize of 256. That concerns me since I only grabbed mdf items. Could I have corrupted the data with my changes above?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter