Hi Gila,

thank you.

I wrote a stored procedure that do the folowing:

[font="Courier New"]read num_of_bytes_written from sys.dm_io_virtual_file_stats

random insert and delete rows from tables

read num_of_bytes_written from sys.dm_io_virtual_file_stats

calculate delta in megabytes

do a...

sys.dm_db_virtual_file_stats: thank you Gila. It is what I was really seraching for!

Yes, Ill do it in this way at the end, I'm only a bit worried about the I/O performance on theses database servers. Over than this, I have to use...

Thank you.

This make me sad.... It seems impossible to me that with sql server is not possible to get informations like this.

I hate Oracle because of complexity, but in...

Hallo Gail and MRdenny.

I totally understood your point of view but I have difficult to fully understand it. Reading blog articles and your replies to my questions I can resume...

Hello, thank you for your reply.

In the last days I spent some times making three of these database more stable and I accomplish this goal.

What I have done:

...

Hallo UDBA,

my two cents on it.

if you don't change your compatibility level, it does not means that you are not doing a major change. In fact you will do it...

Thanks!

I really don't always put max dop=1 ;).

I know that CXPACKET by themselves is not an issue, but I was quite sure that unbalanced execution time between parallel threads...