Hi Grant,

Thanks for quick response.

I was little curious and I had my question to myself of why the storage engine behaves differently in allocating data pages. For...

Thanks Gail, for guiding me in the right direction. Thank you.

Thanks Gila for Awesome explanation.

Now, I am in a point where I was able to get insight of how sql server memory used by all queries but I feel...

Thanks Gail.

One more thing. Can I assume that queries which are doing more physical reads from disk are memory hogers? Is that a correct statement.

Okay, this is what I am doing Gail. This is a TEST to identify queries which are consuming more memory and seeking for help to get those queries which...

Thank you very much Gail.

Okay. Thank you.

Hi,

Would like to know is there any particular scenario wherein If I had to Kill a process/spid and thinking that the locks are released but it didn't but I had...

Thanks for the help.

Hi sql-lover,

Thanks for the query. However, this script would show only the buffer distribution. ITs doesn't include the memory allocations done outside buffer pool(i.e. memToleave or non-buffer or memory allocations...

Got it. Brilliant stuff.

Thank you very much Gila.

Thanks Gila for quick response.

one more clarification, in that case, SQL doesn't SUM up all the execution times for all the CPU's as it is one query which is...

Thanks for the clarification.

Hi Lynn,

You are right. It opened 600 separate txns. Once I made the change suggested by Gail, I was able to clear the log.

Select [spid],[Current LSN],[Operation],[Context],[Previous LSN],

...

Hi Gail,

You are right on! Thanks very much for the help. I verified the fn_dblog().

Select [spid],[Current LSN],[Operation],[Context],[Previous LSN],

[Transaction Name], [Begin Time] as [Transaction Begin Time],[End...