OK. Got it. Thank you very much Gail for clearing some of my misconceptions.

I am trying to reproduce these issues to understand the memory concepts well.

Again, thanks for the...

Shawn, thanks for pointing me to paul randal link.

Thanks a ton.

Gail, just checking what if it is ongoing transaction. As far as my knowledge goes, for instance, max server memory to a very low value say 500mb,...

I just wanted to know through DMV (if any), the most of workload is 'Ad hoc' type.

Can we get this information from plan cache using any DMV?

Hey, thank you very much.

I would go with second one which is from Brent ozar. I am much more comfortable with TSQL than Excel stuff. 🙂

Yeah. I mean normal disk as DAS.

Thanks for pointing out of SQLIO tool.

Is there anyway I can import results of sqlio and load it into sql server table and...

Hi sqlbuddy,

Thanks for reply.

I wanted to setup monitoring for I/O issues.

Are there any benchmark values of how much a normal disk can handle and how much a SAN...

Thank you sqlbuddy123. Nice posts. Thanks for sharing.:-)

Thanks very much Taylor and Dj.

Very nice explanation. Thank you very much Jessie.

Hi Mascot,

Yes. you are right and have taken the backup of both application and system database backups.

Thank you.

Thank you Perry 🙂

Thank you very much.

Hi mascot,

I wanted to test this on testing server whether it is possible or not. I wasn't aware of the fact that we can also do database upgrade using database...

Okay. Thank you Gail.