🏹
Technical Solution
  • Architecture and Design
  • How ?
    • 👻Static Host in Github
    • General Help
      • SQL Server vs AWS Aurora MySQL
      • Create .NET Core Template
      • Detect Browser Close Event
      • Google reCAPTCHA
      • Find File is locked
      • 🐬Docker Cheat Sheet
  • Why ?
  • Issues & Fixes
    • Different ways to clear SQL Server Memory
    • SQL Connection Leaks
  • Solution
    • WebSocket - Client & Server
    • Trace Log - Execution History
    • Storing Files in Database / FS
    • Enable Lazy Loading in Blazor Wasm
  • White Papers
    • Microservice
  • Best Practices
    • SQL - Try Catch
Powered by GitBook
On this page

Was this helpful?

  1. Issues & Fixes

Different ways to clear SQL Server Memory

DBCC DROPCLEANBUFFERS

Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.

USE METRIC_DATABASE;
GO
CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

Ref:

https://www.mssqltips.com/sqlservertip/4714/different-ways-to-flush-or-clear-sql-server-cache/

PreviousDocker Cheat SheetNextSQL Connection Leaks

Last updated 4 years ago

Was this helpful?