Thanks for your response. There is an identity column, and the first 3 are corresponding data.

ie, rows with identity values 1,2,3 will need to become columns 1,2,3 of row...

bytes/sec at any point in time by connections to different databases or some similiar measure

bumping the thread - apologies if not allowed

Thanks for the details - the queries are extremely helpful.

I am looking to collect data at intevals, and thereby identify the high, low and average usage patterns within a...

I have been able to work out the IO details per database, thank you for your inputs.

How do I get the CPU and memory per database over a period of...