Hey There!

Thanks for posting your findings;

Let's gather some more info so we can help figure out why it didn't send the email.

Then, execute the following statement in the msdb database...

By all means, please do. That's what this forum is for.

🙂

Thanks for the comment. I am yet to update the script or create a new method using extended events.

Once i do, i will share it as well.

If you do find...

Yes it is. You can put it in a job that runs periodically and populates a table which you can use for analysis.

AvgCPUTime = 136722 -- Mathematical average cpu time (in miliseconds) it took per query execution.

execution_count = 25, -- Total count of executions of the query.

I bet when you look at...

Thanks JDeMoss!

Even better.

Most definitely.

Thanks for sharing your findings. The code was written to work with SQL Server 2008/2008R2 and will have to be modified for sql 2005. I do have a link from...

--A slight modification so it displays the memory used in MB as well.

-- Top 10 consumers of memory from Buffer Pool

SELECT TOP 10

[type] AS OBJECT_TYPE

...

Please do and post your feedback on the flaws with it and possible fixes so i can keep improving it.

Msg 213, Level 16, State 7, Line 1

Column name or number of supplied values does not match table definition.

What we are actually doing with that line of code is converting bytes to MB.

1024bytes = 1Kb

1024Kb = 1MB

therefore; 1MB = (1024 * 1024) = 1048576

Hence the "physical_memory_in_bytes/1048576" Column being...

What version of sql server id you run it against?

Thanks William!

I will test and make the updates

300 seconds is 5 minutes.

Microsoft recommends that if you have a PLE of 300 seconds, you should be good and generally, that works. The higher the number, the better for...