Thanks for your reply.

Can you expand upon your answer please ? Or could you point me to where i may be able to see some code that does something similar...

Thanks - you where correct. I ommite the = 20 and it worked.

Thank you very much

🙂

solution discovered ! - Our instances where being moved to another VM and they didnt tell me !!!

Yes the alert is the 'Increased % of fragmented indexes' - even so though, i changed the metric to be collected every 5 mins to intially see if it would...

Once a week you say ?

Mine is set to once a day. Daily is the longest time interval i can set - there is no option for a weekly collection,...

Grant

Thanks for all your help i know at least have a better understanding of how to drill down using sql monitor.

I have traced the problem to some sharepoint reports...

Grant,

The query with the largest numbers against it is the second one in the list:

INSERT INTO @MemStat

EXEC ('DBCC memorystatus() WITH tableresults');

From query plan: 0x06000100e090292b40e18282000000000000000000000000

*****************************************************************

Thje metrics are:

execution count...

Hello again Grant

Heres what i am finding.

The alert for hash warnings is showing up against server 15 and in the Master database.

I click on 'overview', then my server (server15), then...

Grant -Once i select the time to the desired time, the screen changes to show the following:

(local)

CPU, MEMORY DISKS, NETWORKS, PROPERTIES AND SYSTEM PROCESSES (TOP 10).

Can you guide me on...

Thank you very much for that info Grant - I'll be sure to check that out and get back to you if i have any further questions !!

Thanks very much:-)

Hi - Not sure if this is what your looking for but have you ran sp_whoisactive ?

Would this not tell you what process/user is having this effect ?

ahhh right that makes sense then. So 8k multiplied by 15586 is approx 121MB - which is what the query shows me.

So if the sql max memory setting is at...

The sql server has 24Gb and the server's max memory is set to approx 19Gb.

From the 1st query listed above (to return the objects in the buffer) i get the...

Sorry for the late reply to your post.

Thank you very much for those queries.

Can i ask though, once I have identified these large objects what is the recommended action ?...

I used the script that Kendra little uses in her optimizing indexes video from http://www.brentozar.com.

I have just added the excel spead sheet as ive noticed the text has got formatted...