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

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

By

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

The Book of Redgate: Evidence

By

We aren’t the only company that does this, but Redgate Software does try to...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Sidoarjo Tlp:(08218200203)

By layanan_Bca88

Hub Via Wa:628218200203 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo,...

Alamat Kantor BCA KCU Diponegoro Tlp:(08218200233)

By m4rt1n4

Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241

Alamat Kantor BCA KCU Indrapura Tlp:08218200174

By R4nt4u

Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176

Visit the forum

Question of the Day

Transaction Log Truncation

In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?

See possible answers