Press Release


Technical Article

SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once

This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.

You rated this post out of 5. Change rating

2015-06-25

2,334 reads

Blogs

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

My 2024 in Data: Music

By

This is my last week of the year working (I guess I come back...

A New Word: Suente

By

suente– n. the state of being so familiar with someone that you can be...

Read the latest Blogs

Forums

String Variable and sp_executesql

By stevec883

I am not understanding why this command completes "successfully" and it seems correct to...

printing complete path

By mtz676

get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...

adding dtc to my pkg

By stan

Hi below i show the control flow of my pkg.   I'd like to enlist...

Visit the forum

Question of the Day

Superseded Indexes

Which of these indexes is superseded by another?

See possible answers