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

Technical Article

Take our SQLServerCentral Users Survey

Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.

You rated this post out of 5. Change rating

2015-06-02 (first published: )

13,214 reads

External Article

Database Continuous Integration Workshop - London, UK

Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.

2015-05-22

6,320 reads

Blogs

Azure – HorizonDB

By

As Open Source – PostgreSQL and AI is a growing and powerful DB system,...

A New Chapter: Why I Made the Move from Dayforce to ESO

By

A New Chapter: Why I Made the Move from Dayforce to ESO Over the...

Lean Six Sigma – Brief

By

When you have a project or system, it has to be optimized, tuned, and...

Read the latest Blogs

Forums

Using IFF within a WHERE clause

By DaveBriCam

I have a WHERE clause I need to add to a list of other...

Reading Parquet using openrowset

By saum70

Hi, We are looking out to read parquet file directly from on premise shared...

Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019

By abdalah.mehdoini

We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...

Visit the forum

Question of the Day

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

See possible answers